5.00(2)

Microsoft Excel Beginner to Advanced

  • Categories Microsoft Excel
  • Duration 14h
  • Total Enrolled 8
  • Last Update August 4, 2021

What Will I Learn?

  • Microsoft Excel basics
  • Data & Conditional Formatting in Excel
  • Data Validation
  • Excel Functions & Formulas
  • VLOOKUP, XLOOKUP, MATCH , INDEX
  • Data Analysis using Pivot Tables
  • Printing & Sharing Excel Files
  • Data Security & Protection in Excel

Topics for this course

31 Lessons14h

Excel Basics

1. Introduction to Microsoft Excel00:34:18
2. Getting Started with Excel00:37:07
3. Data Formatting in Excel00:41:26
4. Working with Cells in Excel – Part 100:24:28
5 : Working with Cells in Excel – Part 200:26:31
6. Excel Table Basics00:12:26
7. Excel Conditional Formatting00:26:23
8.2 Cells Options in Excel00:09:48
8.3 Data Validation in Excel00:24:22
9.1 Default Data Alignment In Excel00:02:21
9.2 Difference Between Functions and Formulas in Excel00:03:58
9.3 Calculation Operators in Excel Formulas00:08:03
9.4 Order of Operator Precedence in Excel
9.5 Show Formula Shortcut in Excel (Tip)
9.6 Evaluate Formulas in Excel
9.7 Insert FUNCTION
9.8 F9 key in Excel
9.9 Remaining Reg

Excel Advanced

Tips & Tricks

About the instructor

5.00 (7 ratings)

4 Courses

19 students

Student Feedback

5.0

Total 2 Ratings

5
2 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

This Excel course is unique and powerful. Loved it

Excellent Course

2500

Material Includes

  • 14+ Hours of on-demand video
  • Full lifetime access
  • Certificate of completion

Enrolment validity: Lifetime

Requirements

  • No prior Excel knowledge is needed
  • A computer or laptop with Windows 10
  • Microsoft Excel 2016, Excel 2019 or Microsoft 365

Target Audience

  • Students
  • Professionals