Skip to content
OnDemand Videos

Excel - Intermediate - Formulas and Functions


Course
Quantity
For someone else
Alicia Katz Pollock
Quantity
For someone else
Purchase for $81 or enter access code

Learn Excel, Microsoft Office’s spreadsheet software. This Excel tutorial covers sorting & filtering, logic formulas, text functions, and vlookup.

Class Description

Once you’re familiar with Excel, learning the more advanced tools will help you analyze your numbers for solid business decisions. We'll create pivot tables. We’ll demystify dozens of handy formulas: vlookup, date, text and logic formulas. We’ll sort and filter data tables, name ranges for easy understanding, and protect worksheets to keep them perfect. We’ll also explore more tools that you can use as soon as you get back to work.

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover work similarly in Excel for PC and Mac.

 

What You’ll Learn

    • AutoFill Handle
    • Relative and Absolute Cell References
    • Named ranges
    • Data Tables for working with Lists
    • Pivot Tables
    • IF function
    • AND/OR/NOT functions
    • Nested functions
    • VLOOKUP and HLOOKUP
    • DATE functions
    • TEXT formulas including CONCATENATE and splitting text into columns
    • Tracing formulas
    • Protecting worksheets
    • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

 

Instructional Level

Intermediate

Course Length

2.5 hours

Course Credits

2.5 CPE, Certificate of Completion

Field of Study

Computer Software & Applications

Delivery Method

QAS/Self Study

Prerequisites:

  • Our "Learn Excel in 3 Hours Flat" course, or
  • Prior Excel experience.
  • A copy of Microsoft Excel

Who should take this class?

  • Business owners and employees looking to manipulate and analyze Excel spreadsheet data for business decisions
  • Students and job-seekers looking to boost their employment marketability.
  • Advanced students looking to fill in gaps in their knowledge. Since we specialize in what you “don’t know that you don’t know,” even seasoned users are guaranteed to glean essential nuggets of information to make using Excel easier than before.

 

 


Refunds & Cancellations

Please view our Terms of Service, for information on refunds, cancellations, and complaint resolution. To request a refund, please contact us.

 

Royalwise Solutions Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

 

 




Course Credits: 2.5 CPE, Certificate of Completion. Must be awarded within one year of enrollment.


Course Updated: December 2021

Here is the course outline:

1. Download the Course Files

Download the handout that goes with the course.

Agenda and Notes
Download the Course Files
Alicia's finished spreadsheet

2. Watch the Recordings: Excel Intermediate

This is the recording of the class you attended. Watch and rewatch it until it all makes sense!

Getting Started
Formulas vs Functions - Review
Named Ranges
IF Functions
VLOOKUP Functions
Logic Functions (AND)
Sparklines
Tracing Formulas
Protecting Worksheets
Date formulas: NOW, TODAY, DATEDIF
Cells between Sheets
CONCATENATE and capitalization functions.
LEFT, RIGHT, and FIND text functions
Data Tables and Pivot Tables
Review Questions: Excel - Intermediate - Formulas and Functions

3. Assessment

To receive a Certificate of Completion for this course, submit your finished spreadsheet.

Submit Spreadsheet
Quiz: Excel - Intermediate - Formulas and Functions
Evaluation & Participation Survey

Completion

The following certificates are awarded when the course is completed:

Royalwise CPE Certificate
Back to top