Advanced Excel

——   Created by Simon Sez IT

Share this course:

NEW
Course
57
Lessons
8h 05m
Lesson time
intermediate
Skill level
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today.

More about this course

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of more advancedExcel features thatdelve into high-level consolidation, analysis and reporting of financial information.

What You'll Learn

What's new/different in Excel 2019

Advanced charting and graphing in Excel

How to use detailed formatting tools

Lookup and advanced lookup functions

Financial functions including calculating interest and depreciation

Statistical functions

Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

How to create awesome visualizations using spark lines and data bars

Mastery of PivotTables and Pivot Charts

Scenario Manager, Goal Seek and Solver

Advanced charts such as Surface, Radar, Bubble and Stock Charts

Course Format

This is a video-led course. You can preview some videos below.

This course includes practice exercises so you can practice as you learn.

This course is suitable for Windows users.

57 Lessons

Chapter 1: Introduction to Excel 2019 Advanced Course
0:06:39
Introduction to the Course
free preview
0:04:19
Course Structure
free preview
Chapter 2: Functions
0:13:38
Functions - Part 1
0:08:04
Functions - Part 2
0:06:01
Autosum
Chapter 3: Date and Time Functions
0:09:59
How Date and Time Works
0:09:43
Basic Date and Time Functions
0:10:38
Complex Date and Time Functions
Chapter 4: Text Functions
0:12:21
Using Text Functions - Part 1
0:12:12
Using Text Functions - Part 2
Chapter 5: Logical Functions
View more lessons +
Enroll in this course for $19.97
or $15/mo for unlimited courses

Class benefits

  • Certificate of Completion
  • 14 day free trial
  • 24/7 streaming access
  • Teacher Q&A
  • 8h 05m of on-demand video
  • 3 downloadable files
  • Have a coupon?

About the instructor

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no …

View full profile

Access unlimited courses for only $15 per month

Start your 14 day free trial. Cancel at any time.

Join Today