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.
This Course has been approved by the International eLearning Standards
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? Instructor Shawn McCreight
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
- Professionally Certified Instructional Designer
- eLearning Developer with 25+ years experience.
Shawn is a Professionally Certified Instructional Designer and eLearning Developer with 25+ years experience. Committed to continuing education, current and emerging technologies and best practices.
Shawn specialises in customizing solutions involving a collaborative approach to ensure the concepts introduced in the program can come to life within an organization and are supported for sustainability.
Very Helpfull Course
Good for a better understanding of Excel
Lots of Content
In depth course!
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? Instructor Shawn McCreight
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? Instructor Shawn McCreight