Skip to content
OnDemand Videos

Excel: Intermediate - Formulas and Functions


Course
Alicia Katz Pollock
Purchase for $81

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.

Get 'Excel: Pivot Tables and Dashboards' for FREE when you bundle! 

Learn to use Microsoft Excel like a pro with this three course bundle, now for a limited time.

When you buy Excel in 3 Hours Flat Intermediate Excel as part of this bundle, and we'll throw in 'Excel Pivot Tables and Dashboards' for FREE!

 

Click here to buy the 3-part 'EXCEL LIVE COURSE BUNDLE' bundle and save $54  

 

 

Instructional Level

Intermediate to Advanced

Course Length

2.5 hours

Course Credits

2.5 CPE, Certificate of Completion

Field of Study

Software

Delivery Method

QAS/Self Study/Blended

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.

 

 


 

For more information regarding concerns, refunds, and program cancellation policies, visit our Terms and Conditions

 

 

Here is the course outline:

1. Download the Course Files

Download the handout that goes with the course.

pageText Agenda and Notes
pageText Download the Course Files
pageText 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!

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

3. Assessment

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

folderUp Submit Spreadsheet

Completion

The following certificates are awarded when the course is completed:

Royalwise Credit Certificate
Back to top