My Excel Class

Course Description

Learn everything Excel has to offer to your home and office in a very easy-to-understand format. With visual training methods, you will retain the information you learn so you can effectively put it to use immediately and further down the road. Dive deep into all of Excel’s features and functions in this Basic to advanced Level course.

Streamline Your Workflow and Enhance Your Results

Whether you’re in the field of engineering, management, marketing, accounting, finance, or education, the skills you will acquire from this course will launch you to a much higher level of value. Taking advantage of Excel in its entirety will make what you do and how you do it much easier, no matter what industry you work in.

Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite

Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 52 lectures and 17+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. You’ll also be shown clever multi-interacting formula work, and you’ll tackle how to resolve missing data that causes that pesky “N/A.”

The Ability to Master Excel

Whilst in this course we’ll cover the basics of Excel after that we’ll move onto more advanced-level topics. With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process. Complete with working files, you’ll be able to follow along with the author throughout the lessons.

Lessons are also focused on organizing your data easily through outlining, expanding or contracting columns to display more or less data, and summarizing data.

Before long, you’ll be able to set up and record your own macros and array formulas, and you’ll know how to ask Excel to try out different solutions for you.

Your ability to master everything from sorting and managing data, to performing complex calculations quickly will help you use the program to its fullest potential.

By the end of the course, you’ll be confident when using Excel’s most advanced features for complex tasks at home and in the office.


What am I going to get from this course?

  • Visual training method, offering users increased retention and accelerated learning.
  • Over 50 lectures and 17+ hours of content!
  • To take your basic Excel skills to the next level
  • Learn basic to Advanced Level Microsoft Excel 2013 from a professional trainer from your own desk.
  • 52 lectures (17+ hours of content) Master functions for working with lookups, advanced IF statements, math, and text, Macros, Sparklines, outlining, custom views, and scenarios ,Create and edit pivot tables, charts and much more!
  • Breaks even the most complex applications down into simplistic steps.
  • Suitable advanced Excel users. Ideal for users who learn faster when shown.
  • To gain a solid understanding of the more powerful features and functions in Excel
  • To be able to use Microsoft Excel in a commercial environment
  • Learn auditing and troubleshooting formulas, such as goal seek, solver, and macros


01 Basics Number Format, Keyboards, PivotTables, Formulas.

02 Comprehensive Excel Formula Types & Elements Video and 12 Examples.

03 How Formulas Calculate: Order of Precedence in Excel.

04 Percentage Increase or Decrease Formula.

05 Cell References: Relative, Absolute & Mixed and 8 Examples.

06 Scenarios to Save Sets of Formula Inputs, Paste Special Trick.

07 Worksheet & Workbook References, 3-D Cell References.

08 Excel Table Formula Nomenclature / Structured References and 22 Examples.

09 Defined Names & Aggregate Functions.


11 Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM.

12 AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT.

13 AND & OR Criteria Calculations: Table Feature.

14 AND, OR, IF Functions For AR Dept (Multiple Logical Tests)

15 IF & IS Functions To Deliver Numbers, Text, Formulas, Nested Ifs

16 Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more…

17 Introductions to SUMPRODUCT Function

18 VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP

19 Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP

20 VLOOKUP, DGET & MATCH For Looking Up Records and 7 Examples

21 INDEX and MATCH Functions For Unusual Lookups and 4 Examples

22 CHOOSE function to lookup table for VLOOKUP with Multiple Tables

23 VLOOKUP and IFNA for Commissions

24 Getting Top 5 Values With LARGE And Bottom 5 With SMALL

25 Goal Seek: Get Formula to Evaluate To Desired Result

26 Excel Compare Two Lists Formula: Item In List? Item Not In List?

27 How to Track Down Excel Formula Errors (16 Examples)

28 Excel Data Validation: List, Date, Time, Custom (22 Examples)

29 Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)

30 Custom Number Formatting & Text Functions, (33 Examples)

31 Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More

32 Introduction To Array Formulas and Array Functions

33 Sorting In Excel. Excel Sort (13 Examples)

34 Excel Subtotals, Add Subtotals based on One or Two Columns

35 Excel 2013 PivotTables: Basic To Advanced 58 Examples

36 Excel Filter For Extracting Records with AND or OR Criteria

37 Excel Advanced Filter Extract Data 26 Examples Basic – Advanced

38 Excel Text To Columns To Split or Convert Data 7 Examples

39 Excel Import Data: Text File, CSV File, Access, Excel File

40 Conditional Formatting Basic To Advanced 50 Examples

41 Review Of Chart Basics For Excel 2013

42 Save Chart As Template in Excel 2013

43 Set Default Chart in Excel 2013, Keyboard Shortcuts Charts

44 Pie within Pie Chart in Excel 2013

45 Combining Chart Types and Secondary Axis in Excel 2013

46 Statistics: Histogram Formulas & Chart in Excel 2013

47 Statistics: Dot Plot (Cell Chart)

48 Conditional Formatting: Bar Chart with Data Labels

49 Break Even Analysis Formulas & Chart, Plotting Break Even Point

50 Financial Functions_ PMT, RATE, NPER and FV 12 Examples.

51 Recorded Macro Basics, including Absolute & Relative References

Course Reviews


  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.

Apply for Course

Advanced Course Search Widget