Microsoft Advanced Excel

ü  Microsoft Excel Introduction

ü  How to Work in Excel And Use Basic Formulas

ü  Use Clipboard Like Pro Full Explain

ü  Organize Row Column And Worksheet

ü  Data Entry Like Pro

ü  Create Your Own Custom List

ü  How Make Password your Excel File

ü  How To Create a Backup Excel File

ü  How to Use Sum Formula

ü  How to Use Skip Blanks

ü  Subtract, Multiple, Divide And Percentage

ü  Use of Number Format in Excel

ü  Use Conditional Formatting

ü  How to Sort & Filter Data

ü  Using Find and Replace and Using GoTo

ü  How to Use Status Bar

ü  Freeze Panes Option

ü  Concatenate

ü  Fill Option

ü  Flesh Fill

ü  Pivot Table

ü  All Table Option

ü  Pictures Option

ü  Use Shape

ü  Smart Art

ü  Advanced Charts & Graph

ü  Create Hyperlinks

ü  Dashboard

ü  Complete Page Setup

ü  Scale to Fit Setup

ü  IF Formula

ü  IF Formula With Multiple Conditions

ü  Change Case and Round Figure Formula

ü  VLOOKUP Formula

ü  Stock Record

ü  HLOOKUP Formula

ü  Subtotal Formula

ü  Calculate Age With Date, Date If Formula

ü  Date and Eo-Month Formula

ü  Calculating Percent Formula

ü  Concatenate Formula

ü  Count, Counta, Countblank Formula

ü  Countif Formula

ü  Countifs Formula

ü