Easter Egg Hunt - Save up to 15%
watching now
5 Students

Course Details

Lessons

171

Skill Level

Beginner

Certificate

Available

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.

Description

Requirements

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

Curriculum

Section 1: Introduction to Excel 23:17
  • Course Files Watch now
    00:41
  • Starting With Excel Watch now
    01:43
Section 2: Calculations With Basic Formulas 23:13
  • Introduction to Arithmetic Operators Watch now
    01:45
Section 3: Calculations with Simple Excel Functions 22:05
  • Introduction to Function Syntax Watch now
    02:17
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 23:36
Section 10: Data Validation and Inserting Comments 17:53
Section 11: Date and Time Functions 42:36
  • WEEKDAY Function Watch now
    02:38
Section 12: Logical Functions in an Excel 59:16
Section 13: Lookup and Reference Functions in an Excel 37:19
  • Nesting the VLOOKUP Function Within an IFERROR Function Watch now
    04:29
Section 14: Adding Line and Combination Charts in an Excel 07:46
Section 15: Text Functions in an Excel 32:42
Section 16: Math and Trigonometry Functions in an Excel 16:32
Section 17: Information Functions in an Excel 03:36

About the Instructor

4.8
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