Excel 3-in-1 bundle

Become proficient in Microsoft Excel and boost your productivity at work !

Highlights of the course

What you’ll learn

  • Course 1 : Excel Essentials – key excel functions like numerical, logical, date and data tabulation functions, among many others.
  • Course 2: Most Powerful Excel Functions – Learn the power of Excel to deal with large data-sets using look-up functions, data and pivots tables, macros, charts.
  • Course 3: Starting off with Microsoft Excel – Excel for the first time Microsoft excel user. Learn basic data handling and validations, and more.
  • The above 3-in-1 bundle will cover all key excel functions in 5 hours & you will practice functions with reference excel sheets while going through the courses.

Course Content

  • Introduction –> 1 lecture • 2min.
  • Excel Essentials –> 8 lectures • 1hr 41min.
  • Section 3: Most Powerful XL Functions –> 6 lectures • 1hr 58min.
  • Starting Off with Excel –> 5 lectures • 43min.

Excel 3-in-1 bundle

Requirements

  • No prior knowledge required. Start from where you are on the journey with excel. Moderate excel user? Absolutely fine. First time user? Get started ! Destination is the same. Excel proficiency..

Highlights of the course

  • This course helps you practice the most relevant Microsoft Excel functionalities as you go along the course videos.
  • In just 5 hours of videos, you will learn all important functionality in Excel hands-on, to boost your productivity at work.
  • The course has a separate section for beginners, so that even first time excel users can get started with MS Excel
  • Moderate/Intermediate users can skip the beginners section and get started with the more advanced functionality.
  • This course captures all that you would need in Excel, culled out from 14 years of my own experience of using Microsoft Excel .
  • The whole objective of this course is to make learning Excel simple and gain proficiency!

 

Structure of the course

After an introduction to the course, this course comprises of 3 main sections covering 35 most important functionalities of MS Excel.

  • Excel Essentials – Key excel functions like numerical, logical, date and data tabulation functions, among others
  • Most Powerful XL Functions – Learn the power of Excel to deal with large data-sets using look-up functions, data and pivots tables, macros, charts
  • Starting off with Microsoft Excel – Section for the first time Microsoft Excel user. Learn basic data handling, validations, and more

 

Key contents of the course

The listing of key functions covered across sections is seen below for easy reference:

  • Numerical formulae: Add, subtract, multiply,divide, sum, sumproduct, cell references
  • Paste special, dependents, precedents
  • Statistical functions: Average, median, count,max, min, CAGR, round
  • Date functions: Workday, weekday, today, date differences
  • Logical functions: And, Or, Not, If, Iferror, Countif, Countifs, Sumif, Sumifs, Nested If, Evaluate
  • Sorting, filtering, Freeze panes, tables, split views
  • Vlookup, Hlookup, Choose, Index, Match
  • Pivot tables and subtotals
  • Goal seek, PMT function
  • Data tables
  • Circular references and recording macros
  • Bar, column, line, stacked, pie, scatter charts

 

Starting off with Excel section for Beginners covers the following

  • Opening an excel work book, the look and feel of Excel workbook
  • Data entry, autofill, key data formats
  • Formatting, format painter, conditional formatting, autofit, change worksheet names
  • Cut,copy, paste, merge, group, hide, comments, find & replace, data validation
Get Tutorial