Excel 3-in-1 bundle

Highlights of the courseThis 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 ExcelModerate/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 courseAfter 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 othersMost Powerful XL Functions - Learn the power of Excel to deal with large data-sets using look-up functions, data and pivots tables, macros, chartsStarting off with Microsoft Excel - Section for the first time Microsoft Excel user. Learn basic data handling, validations, and moreKey contents of the courseThe listing of key functions covered across sections is seen below for easy reference:Numerical formulae: Add, subtract, multiply,divide, sum, sumproduct, cell referencesPaste special, dependents, precedentsStatistical functions: Average, median, count,max, min, CAGR, roundDate functions: Workday, weekday, today, date differencesLogical functions: And, Or, Not, If, Iferror, Countif, Countifs, Sumif, Sumifs, Nested If, EvaluateSorting, filtering, Freeze panes, tables, split viewsVlookup, Hlookup, Choose, Index, MatchPivot tables and subtotalsGoal seek, PMT functionData tablesCircular references and recording macrosBar, column, line, stacked, pie, scatter chartsStarting off with Excel section for Beginners covers the followingOpening an excel work book, the look and feel of Excel workbookData entry, autofill, key data formats  Formatting, format painter, conditional formatting, autofit, change worksheet namesCut,copy, paste, merge, group, hide, comments, find & replace, data validation