Instant access

Interactive Course

4 Hours

Certified Course
Course never expires
Complete on multiple devices
Courses receive accredited certificate

Advanced Excel Course

Advanced Excel - Online Course

Course Description

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.
logo-1-1024x1024This Course has been approved by the International eLearning Standards



Course Overview

Module 1 - Understanding Commands


Lesson 1: Problem Solving and Understanding Commands
Problem Solving, TRUE, FALSE, IF, AND, OR and NOT

Module 2 - Finding and Highlighting Formulas


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

Module 3 - Date and Time


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

Module 4 - Macros


Lesson 1: Understanding and Using Macros
Understand Macros, How to create Macros, Creating triggers, Multiple actions and Fixing errors.

Module 5 - Using Formulas


Lesson 1: Using Formulas for Information
How to get information and fix errors using formulas

Module 6 - PivotTables


Lesson 1: Understanding and Using PivotTables
Understanding and creating PivotTables, Using formulas in PivotTables, Making interactive PivotTables

Module 7 - Cleaning your Spreadsheets


Lesson 1: Cleaning your Spreadsheets
Steps to making charts cleaner, Adding projections and trends, Adding pictures and charts, Creating break-even charts

What Will I Learn?
You will learn the advanced features that will improve your excel skills including the following:
- Finding and Highlighting Formulas
- Date and Time Functions
- Macros
- Using formulas to find and edit data
- PivotTables
- Cleaning your spreadsheets
- Problem Solving and Commands

Requirements?
- Microsoft Excel 2013 (most functions taught in this lesson are compatible with other Excel versions)
- A basic understanding of Excel


Instructor

38b4c14Shawn McCreight
- Professionally Certified Instructional Designer
- eLearning Developer with 25+ years experience.

 

About Shawn
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.
Read More

Very Helpfull Course

5 5 1
Very Helpfull Course Thank You!

good course

4 5 1
course provided good information, the clickable course was good but slow at times

Fantastic Course

5 5 1
I loved this course. Thank you Shawn/CourseFirst

Good for a better understanding of Excel

5 5 1
I knew the basics of the excel program but I decided to get a better understanding and this course was perfect

Nice Course

4 5 1
This course really helped to expand my knowledge with Excel

Lots of Content

5 5 1
Lots of Content. Great Course. Interactive course makes it very easy to remember

In depth course!

5 5 1
I always knew I could get much more out of Excel but did not know how. This course was perfect and easy to follow
Name
Review Title
Rating
Review Content
Advanced Excel Course Overall rating: ★★★★★ 4.7 based on 7 reviews
5 1

Single payment of $199