- Certified Course
- Lifetime access & no monthly fees
- Complete on multiple devices
- Courses receive accredited certificate
Advanced Excel Course
Advanced Excel – Online Course
This Microsoft Excel Advanced training course will give you a deeper understanding of the many complex and in-depth features of Excel.
With over 400 formula functions you need to know how to find the ones you need, This course will prepare you to locate and use the many advanced functions in Excel and will provide an in-depth look at the most commonly used.
This is an interactive course that will not only show you but also allow you to participate in the lesson by clicking and typing the appropriate commands which will drastically improve your memory of the course.
Module 1 - Understanding Commands Module 2 - Finding and Highlighting Formulas Module 3 - Date and Time Module 4 - Macros Module 5 - Using Formulas Module 6 - PivotTables Module 7 - Cleaning your Spreadsheets What Will I Learn? Requirements?
Lesson 1: Problem Solving and Understanding Commands
Problem Solving, TRUE, FALSE, IF, AND, OR and NOT
Lesson 1: How to Find and Highlight Formulas
How to find and highlight formulas, Hierarchy of actions in formulas, ROUND, ROUNDUP, ROUNDDOWN and Using CONVERT
Lesson 1: Understanding and Using Date and Time
Understanding Date and Time formatting, Using formula with your Date and Time, Using DATEDIF and END-OF functions
Lesson 1: Understanding and Using Macros
Understand Macros, How to create Macros, Creating triggers, Multiple actions and Fixing errors.
Lesson 1: Using Formulas for Information
How to get information and fix errors using formulas
Lesson 1: Understanding and Using PivotTables
Understanding and creating PivotTables, Using formulas in PivotTables, Making interactive PivotTables
Lesson 1: Cleaning your Spreadsheets
Steps to making charts cleaner, Adding projections and trends, Adding pictures and charts, Creating break-even charts
You will learn the advanced features that will improve your excel skills including the following:
– Finding and Highlighting Formulas
– Date and Time Functions
– Using formulas to find and edit data
– Cleaning your spreadsheets
– Problem Solving and Commands
– Microsoft Excel 2013 (most functions taught in this lesson are compatible with other Excel versions)
– A basic understanding of Excel
Single payment of $199
Module 2 - Finding and Highlighting Formulas Module 3 - Date and Time Module 4 - Macros Module 5 - Using Formulas Module 6 - PivotTables Module 7 - Cleaning your Spreadsheets What Will I Learn? Requirements?
Module 3 - Date and Time Module 4 - Macros Module 5 - Using Formulas Module 6 - PivotTables Module 7 - Cleaning your Spreadsheets What Will I Learn? Requirements?