MS Excel Contents

  • Overview of Basic Excel Skills

    • Worksheet Operations
    • Format Cells
    • Freeze Panes
    • Security features of MS Excel
    • Overview of backup features of MS Excel
  • Time Saving Utilities

    • Techniques of Paste Special
    • Format Painter
    • Text to columns with fixed and delimited parameters
    • Tricks of Data Sorting using custom list (13 Real examples)
    • Summarizing data using Group and Auto outline
  • Concept of Cell referencing

    • Introduction to cell referencing
    • Importance of cell referencing
    • Relative referencing
    • Absolute referencing
    • Mixed referencing
  • Important Functions in Excel (More than 90 functions)

    • And, OR, NOT, COUNT, COUNTA, COUNTBLANK, COUNTIF, MAX, MIN, UPPER, LOWER, PROPER, RIGHT, LEFT, MID, POWER, SUM, SUMIF, AVERAGE, EXACT, CONCATENATE, LEN, NETWORKDAYS, NETWORKDAYS.INTL, IS FUNCTIONS, MATCH, INDEX, IF, VLOOKUP-1D, VLOOKUP-2D, REVERSE LOOKUP, HLOOKUP, LARGE, SMALL, SUBTOTAL, SUMPRODUCT, DATEDIF, Other DATE functions, NESTED FUNCTIONS, SEARCH, REPLACE, EOMONTH, EDATE, WEEKDAYS, DATE, PMT, IPMT, NPV, IRR, CUMIPMT, PV, FV, TREND etc.
  • Name Manager

    • Defining Static & dynamic list using names
    • Use of Names in advance reports
    • Automating calculations using Name Manger
  • Playing with Conditional Formatting

    • Conditional formatting using formulas and cell values
    • Highlighting duplicates in various ways
    • Highlighting top records, bottom records
    • Highlight above average, max, min, errors etc.
    • Highlight single color with multiple conditions
    • Calculation based conditional formatting
    • Complex formula based conditional formatting
  • Restriction using Data Validation

    • Different Data Validation in Excel
    • Complex calculation based Data Validation
    • Using Dynamic list in Data Validation
  • Prevent wrong Decisions using Excel Tables

    • Introduction to Excel Tables
    • Power of Excel Tables
    • Time saving features of Excel tables
    • Calculation logic of excel tables
  • The Power of Pivot Tables (57 Real Examples)

    • Pivot Table Creating methods
    • Rearranging a Pivot Table
    • Filtering Pivot Table Data
    • Performing Custom calculation
    • Creating dynamic Dashboards using Slicer
    • Consolidating multiple sheets in less than a minute
    • Creating multiple sheets in a single click using Pivot
  • Charts in Excel

    • Elements of Charts
    • Major charts used in Industry
    • Combining multiple charts together
  • Data Filtering Techniques

    • Introduction to Auto Filter
    • Challenges in Auto Filter
    • Power of Advance Filter
    • Complex calculations based filter
    • Filter using Wild Cards
  • Array Functions for quick calculations

    • Introduction to Arrays
    • The internal logic behind arrays
    • The power of array functions
    • Techniques of creating complex array functions
    • Array functions using basic Excel functions
  • Analyzing data with What-If Analysis

    • Introduction to What-If Analysis
    • Determine unknown with Goal-Seek
    • Analyze Data with Data Table
    • Enable Decision making using Solver
    • View results with Scenario Manager
  • Summarizing Data using Subtotal

    • Introduction to Subtotal
    • Logic behind subtotal
    • Calculations in Subtotal
  • Sparklines for Data Trends

    • Sparklines
    • Types of Sparklines in Excel
    • Different usages of Sparklines
  • Automation of activities using Macros

Enjoy this blog? Please spread the word :)

RSS
Follow by Email
Facebook
Google+
http://klick2learnmore.com/ms-excel-contents/
Twitter
YouTube
YouTube
LinkedIn