One Day Basic Excel with 100+ Functionalities and Case Studies

Scope and Coverage - Indepth coverage of Basic and Advanced Ms-Excel, more than 100 functionalities in business application oriented case studies. The scope includes working on excel from scratch. Basic Structure of MS-Excel (100+ Exercises), Financial Functions and Formulae, Statistical Functions and Formulae, Analytical Functions and Formulae, Data Formatting and Organizing, Calculations for daily use, Conditional Formatting, Data Validations, creation of forms, Creating charts for various purposes, Applying Sorting, Filters, Subtotals, Pivot Table, Look up and Referencing Functions, Navigations, Key Board shortcuts to ease working with Excel, Text Functions, Using Links, Online tools, Date and Time related Functions, Converting Text to columns, Formulae Auditing and Review, Introduction to advanced Functions.