Microsoft Excel is the industry leading spreadsheet program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel.

Excel learns your patterns, organizing your data to save you time. Easily create spreadsheets from templates or on your own and use modern formulas to perform calculations.

Charts and graphs help you present your data in compelling ways, with formatting, sparklines, and tables to better understand your data. Easily create forecasts to predict trends with just a click.

1. BASICS & OVERVIEW
2. • Title Bar.
   • Quick Access Tool Bar.
   • Back Stage View.
   • Name Box.
   • Formula Bar.
   • Clipboard.
   • Formatting.
   • Filters.
   • Column Charts.
   • Page Setup.
   • Print Titles.
   • Paste Special.
   • Format Painter.
   • Relative Address.
   • Working with Multiple Worksheets.
   • Merge And Center.
   • Defined Named Ranges.
   • Date Functions.
   • Text Functions.
   • Protecting a Worksheet.
   • Importing Text File.

2. ADVANCE EXCEL –LEVEL 1
3. • Setting Up a workbook.
   • Working with Data and Excel Tables – including Converting A Range to Table.
   • Performing Calculations on Data – including Lookup Functions, Formula Auditing & Countif.
   • Changing Workbook Appearance – including Conditional Formatting.
   • Focusing on Specific Data by Using Filters.
   • Reordering and Summarizing Data – including Absolute Address, Data Validation & Consolidation, Data Tables.
   • Combining Data from Multiple sources – including Creating Dashboards.
   • Analyzing alternative Data Sets – including Remove Duplicates, Sorting & Custom Sort.
   • Creating Dynamic Lists by using PivotTables – including Pivot chart.
   • Creating Charts and Graphics – including Pie Chart, Combination Chart & Sparklines).
   • Printing and setting up a print area.
   • Automating Repetitive Tasks by Using Macros.
   • Working with Other Microsoft Office Program – including Database functions and Data Linking.
   • What-If-Analysis – including Goal Seek and Scenario Manager.

3. ADVANCE EXCEL LEVEL 2 –WITH PIVOT TABLES, MACROS, AND FORMULAS& FUNCTIONS
4. • Introducing Formulas and Functions – including recording a macro.
   • Creating Formulas that Manipulate Text – including recording a Macro-Using Relative References.
   • Working with Dates and Times.
   • Creating Formulas that Count and Sum.
   • Creating Formulas that Look Up Values.
   • Creating Formulas for Financial Applications.
   • Introducing Array Formulas.
   • Array Formulas- Exercise.

4. CREATING CHARTS AND GRAPHICS/li>
5. • Getting Started Making Charts.
   • Learning Advanced Charting.
   • Visualizing Data Using Conditional Formatting – including editing a macro.
   • Creating Sparkline Graphics.
   • Enhancing Your Work with Pictures and Drawings.

5. USING ADVANCED EXCEL FEATURES
6. • Customizing the Excel User Interface – including Assigning a Macro to a Button.
   • Using Custom Number Format.
   • Using Data Validation.
   • Creating and Using Worksheet Outlines.
   • Linking and Consolidating Worksheets.
   • Excel and the Internet.
   • Sharing Data with Other Office Applications.
   • Using Excel in a Workgroup.
   • Protecting Your Work.
   • Making Your Worksheets Error-Free.