Basic and Advanced Excel courses are tailor made mainly for the needs of BPO Employees, MBA Students and Excel Enthusiasts.

Topics Covered

Basic Excel Course contains the following: • Creating a Microsoft Excel Workbook • Starting Microsoft Excel • Creating a Workbook • Saving a Workbook • The Status Bar • Adding and Deleting Worksheets • Closing a Workbook • The Ribbon • Tabs • Groups • Commands • The Backstage View (The File Menu) • Introduction to the Backstage View • Opening a Workbook • New Workbooks and Excel Templates • Printing Worksheets • Getting Help • Adding Your Name to Microsoft Excel • The Quick Access Toolbar • Adding Common Commands • Adding Additional Commands with the Customize Dialog Box • Adding Ribbon Commands or Groups • Placement Entering Data in Microsoft Excel Worksheets • Entering Text • Using Auto Complete • Entering Numbers and Dates • Using the Fill Handle • Formatting Microsoft Excel Worksheets • Selecting Ranges of Cells • The Font Group • The Alignment Group • The Number Group • Using Formulas in Microsoft Excel • Math Operators and the Order of Operations • Entering Formulas • Auto Sum (and Other Common Auto-Formulas) • Copying Formulas and Functions • Relative and Absolute Cell References • Working with Rows and Columns • Inserting Rows and Columns • Deleting Rows and Columns • Setting Row Height and Column Width • Hiding and Un-hiding Rows and Columns • Freezing Panes • Editing Worksheets • Find • Find and Replace • Using the Clipboard • Finalizing Microsoft Excel Worksheets • Setting Margins • Setting Page Orientation • Setting the Print Area • Print Scaling (Fit Sheet on One Page) • Headers and Footers Conditional Formatting • Applying Conditional Formatting • Working with Styles • Applying Styles to Tables • Applying Styles to Cells Working with Lists • Converting a List to a Table • Removing Duplicates from a List • Sorting Data in a List • Filtering Data in a List • Adding Subtotals to a List • Grouping and Ungrouping Data in a List Visualizing Your Data • Inserting Charts • Editing Charts • Data Validation • Pivot Tables Advanced Excel contains some Basic course contents and the following: Formulas • References, Using $ • COUNTIF • SUMIF • IF, Nested IF, CHOOSE • VLOOKUP, Adv VLOOKUP • MATCH • INDEX • OFFSET • SUMPRODUCT • ROWS, COLUMNS • SUMIFS, COUNTIFS • IFERROR, ISERROR • SMALL, LARGE • Text Formulas • Formula Debugging Formatting • Paste Special • Format Painter • Custom Cell Formats • Date / Time Formatting • Table Formats • Formatting Best Practices • Freezing Rows, Splits • Formatting for Print Conditional Formatting • Intro to Conditional Formatting • Formulas in Conditional Formatting • Using Data bars, Icons, Color Scales • Advanced Conditional Formatting thru Examples • Removing Conditional Formatting, Cleaning Charting • Choosing correct chart • Various charts in Excel • Chart formatting Options • Chart templates • Dynamic charts Tables • Excel 2007 Tables –Intro • Benefits of using tables • Table formatting • Table formulas • Table –named ranges Pivot Tables • What is a Pivot and why use one? • Creating Pivots • Summarizing data • Calculated Fields, Calculated Items • Grouping Data • Pivot Table Tips • Pivot Charts –Intro Data Filters • Data Filters • Sorting • Data Validation • Error Messages, Invalid Data • Advanced Filters • Filters in Tables, Pivots Importing Data • Text to Columns • Importing Text Files • Importing Web Data • Importing MS Access Data Advanced Formulas • Named Ranges, What are they and why use them? • Formula Audit • Array Formulas –Intro • Calculation Modes and uses • Formula Errors and What to do? Form Controls, Macros • Developer Toolbar / Ribbon • What are Form Controls? • Using Scroll-bar Control • Using Check boxes • What is a Macro?

Who should attend

Anybody who want to use Excel in an efficient way and get more done by it.

Pre-requisites

Familiarity with Computers and Basic Computer knowledge especially Microsoft Windows Operating System.

What you need to bring

The students who have laptops can bring them for their hands on working.

Key Takeaways

At the end of the course, the student will be confident in using the following Excel features: From Basic Course: 1. Excel features covered in Basic training 2. Basic Excel formulas i.e. Vlookup, H lookup 3. Conditional Formatting, 4. Basic Charting, 5. Basic Pivot tables 6. Data Filters 7. Sorting 8. Data Validation From Advanced Course Users will be confident in using the following: 1. Advanced functions 2. Interactive Charts 3. Advanced formulas 4. What-if Analysis 5. Scenario Manager 6. Interactive Pivot Charts and many more Advanced Excel functionalities