Advance Excel

Introducing Excel • Entering and Editing Worksheet Data • Essential Worksheet Operations • Working with Cell and Ranges • Introducing Table • Worksheet Formatting • Understanding Excel Files • Using and Creating Templates • Printing Your Work • Introducing Formulas and Functions • Creating Formulas and Functions • Working with Dates and Time • Creating Formulas that Count and Sum • Creating Formulas That Look Up Values • Creating Formulas for Financial Applications • Performing Magic with Array Formulas • Creating Chart and Graphics • Creating Sparklines • Line Graphics • Using Custom Number Formats • Using Data Validation • Projecting Your Work • Importing and Cleaning Data • Introducing Pivot Tables • Performing Spreading Sheet What if Analysis • Project and Templates