Microsoft Excel 2013

Module 1: Excel Introduction

1.1 Intro To Excel Overview Of Screen
1.2 Ribbon Elements
1.3 Entering Data And Editing Font Attributes
1.4 Number Formats
1.5 Formatting Cells
1.6 Printing
1.7 Formulas Part 1
1.8 Formulas Part 2
1.9 Rearranging Data
1.10 More Formulas Part 1
1.11 More Formulas Part 2 Review And Sort
1.12 More Formulas Part 3 Concatenate
1.13 Chart Part 1
1.14 Chart Part 2
1.15 Chart Part 3
1.16 Summary

Module 2: Excel Intermediate

2.1 Introduction
2.2 Review
2.3 Formulas Across Worksheets ­Part 1
2.4 Formulas Across Worksheets ­Part 2
2.5 Conditional Formatting
2.6 Data Validation
2.7 Named Ranges
2.8 CSV Files
2.9 Text To Column
2.10 Grouping Data
2.11 More Charts Beyond Building Blocks
2.12 Working With Windows Part 1
2.13 Working With Windows Part 2
2.14 Headers Footers And Protecting Data

Module 3: Excel Advanced

3.1 Pivot Tables Part 1
3.2 Pivot Tables Part 2
3.3 Sparklines
3.4 Trancing Formulas
3.5 What If Scenario
3.6 External Data Sources
3.7 Customizing Menus And Options Part 1
3.8 Customizing Menus And Options Part 2
3.9 Macros