Excel: Intermediate - Formulas and Functions
Learn Excel, Microsoft Office’s spreadsheet software. This Excel tutorial covers sorting & filtering, logic formulas, text functions, and vlookup.
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.
Intermediate to Advanced
2.5 CPE, Certificate of Completion
Field of Study
Who should take this class?
Here is the course outline:
1. Download the Course Files
Download the handout that goes with the course.
2. Watch the Recordings: Excel Intermediate
This is the recording of the class you attended. Watch and rewatch it until it all makes sense!
To receive a Certificate of Completion for this course, submit your finished spreadsheet.
The following certificates are awarded when the course is completed:
|Royalwise Credit Certificate|