Blog
Library

Mastering MS Excel Basic to Advanced Level

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration

    07:15:37

  • 69 Students Enrolled

Description

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 will you 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
Course Curriculum
Number of Lectures: 80 Total Duration: 07:15:37
Reviews
Stefan Kuppe – June 26, 2019

Jose Maria Arnedo – July 17, 2019

Very good and complete

Jimi Alice Demmitt – November 14, 2019

I have used several of the techniques in my everyday excel use at work.