5.00(2)

Microsoft Excel Beginner to Advanced

  • Categories Microsoft Excel
  • Duration 14h
  • Total Enrolled 9
  • Last Update August 7, 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 Excel00:03:32
9.5 Show Formula Shortcut in Excel (Tip)00:01:34
9.6 Evaluate Formulas in Excel00:02:22
9.7 Insert FUNCTION00:08:29
9.8 F9 key in Excel00:00:59
9.9 Excel Functions & Formulas – Part 100:29:24

Excel Advanced

Tips & Tricks

About the instructor

5.00 (7 ratings)

5 Courses

20 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

500

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