watching now
1 Students

Course Details



Skill Level




RESERVE - Only minutes left for your FREE certificate!

What You Will Learn?

  • Learn most commonly used formulas in the office.
  • Learn excel from beginner to expert.
  • Learn all basic concepts of excel.
  • Learn all advance concepts of excel 2019.
  • Learn how to create pivottable and pivotchart in excel.



  • This course is recorded on excel 2019 but all previous versions 2007, 2010, 2013, 2016 and office 365 will work on this course.


Section 1: Introduction to Excel 23:17
  • Course Files
    Watch now
  • Starting With Excel
    Watch now
Section 2: Calculations With Basic Formulas 23:13
  • Introduction to Arithmetic Operators
    Watch now
Section 3: Calculations with Simple Excel Functions 22:05
  • Introduction to Function Syntax
    Watch now
Section 4: Formatting a Worksheet 32:49
Section 5: Saving and Printing a Workbook 15:50
Section 6: Project Calculations with Operators and Functions 25:05
Section 7: IF and VLOOKUP Functions 23:29
Section 8: Adding Chart in an Excel worksheet 15:20
Section 9: Creating Excel Tables, Pivot Tables and Pivot Charts 46:07
  • Freezing Header or Row
    Watch now
  • Filtering Data in an Excel Worksheet and Deleting an Excel Table
    Watch now
Section 10: Analyzing Sales Data in Pivot Tables and Pivot Charts 34:38
Section 11: Data Validation and Inserting Comments 17:53
Section 12: Date and Time Functions 42:36
  • WEEKDAY Function
    Watch now
Section 13: Logical Functions in an Excel 59:16
Section 14: Lookup and Reference Functions in an Excel 37:19
  • Nesting the VLOOKUP Function Within an IFERROR Function
    Watch now
Section 15: Adding Line and Combination Charts in an Excel 07:46
Section 16: Text Functions in an Excel 32:42
Section 17: Math and Trigonometry Functions in an Excel 16:32
Section 18: Information Functions in an Excel 03:36

About the Instructor

95% of students rated this instructor as excellent!
Reviews 1
Students 8
Courses 1

I am a middle school math teacher. I also work in a school office. I create school files in Excel. I prepare finance data of school employee in Excel. I receive school files in Excel from the education department and answer to the education department by using Excel tools. I have four years job experience on working with Excel. I hope if you follow my courses, you will have deep learning materials (Lectures Files, Home Work Exercises Files, Quizzes). I hope that after completing this course you will pass Job Interview Questions about Excel.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo