Library

Course: Mastering MS Excel Basic to Advanced Level

Mastering MS Excel Basic to Advanced Level

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Dear friends,

Welcome to Mastering MS Excel Basic to Advanced Level Course.

As you know MS Excel skills are high in demand by most of the organizations. 

In this complete practical course I will teach you how to use MS Excel from Basic to Advanced level.

This course will teach you how to save time and be productive and will teach you step by step formulas with syntax so that you can apply on your data.

Best of Luck & Happy Learning ! 

Ramzan Rajani

Basic knowledge
  • You should know how to open, close & save the files, rest I will teach you step by step
What you will learn

You will learn,

  • Excel Shortcuts to that you can work faster
  • Conditional Formatting
  • Sorting & Filtering with tips & tricks
  • Pivot table for Management Reporting and using Slicer & Timelines
  • Lots of formulas interesting including
  • Concatenate
  • Trim
  • Change Case
  • SUMIF
  • COUNTIF
  • SUMIF
  • SUMIFS
  • Mastering VLOOKUP
  • IF Condition with Multiple Level of IF
  • Macros Recording & Running
  • Security in Excel at different levels and lots of other options
Curriculum
Number of Lectures: 47
Total Duration: 04:25:18
MS Excel Shortcuts
  • Excel Shortcuts Part 1  
  • Excel Shortcuts Part 2  
  • Excel Shortuct Revision Part 3  
Conditional Formatting
  • Conditional Formatting Part 1  
  • Conditional formatting Part 2  
Charts
  • Charts Part 1 Column  
  • Charts Part 2 Line & Pie  
  • Charts Part 3 Combination Chart  
  • Charts Part 4 Secondary Axis  
  • Charts Part 5 Linking  
Pivot Tables
  • Pivot Table Part 1  
  • Pivot Table Part 2  
  • Pivot Table Part 3  
  • Pivot Table Part 4  
  • Pivot Table Part 5  
Validation
  • Validation Part 1 Creating Drop down  
  • Validation Part 2 Creating Error Alert  
  • Validation Part 3 Whole Number  
Sparklines
  • Sparklines  
Dynamic Tables
  • Dynamic Table Part 1 Dynamic Chart Range  
  • Dynamic Table Part 2 Automatic Formulas  
  • Dynamic Table Part 3 Inserting Formula and Rows  
  • Dynamic Table Part 4 Using Slicer for AutoFilter  
  • Dynamic Table Part 5 Freeze Top Row  
  • Dynamic Table Part 6 Convert Dynamic Table to Normal Range  
Security
  • Security - File Level  
  • Security - Sheet Level  
  • Security - Workbook Level  
  • Security - Cell Level  
  • Security - Hiding & Protecting Formulas  
  • Security - Viewing all the Formulas on Worksheet  
  • Security - Making Read only File  
  • Security - Prevent your data from Copying  
  • Security - Password to each Range  
  • AutoRecover your files  
  • Set Timing for Auto Recovery  
  • Saving file on Onedrive  
  • Group UnGroup Rows and Columns  
  • Getting External Data  
  • Recommended PivotTables  
  • Recommended Charts  
Hyperlinks
  • Hyperlink Part 1 Linking to other Sheet  
  • Hyperlink Part 2 Linking in Same Sheet to other Cell  
  • Hyperlink Part 3 Linking to other File  
  • Inserting object  
  • Macros Recording & Running  
  • Practice Files  
Reviews (0)