Live Training on MS Excel : Beginners to Advanced Level

(Complete Syllabus)

Microsoft Excel for Beginners

Section E101 : Microsoft Excel Fundamentals
1 Launching Excel
1A Excel Launching Ninja Technique
2 MS Excel Start up Screen
3 Introduction to the excel Interface
4 Customizing the Excel Quick access toolbar & Ribbons.
5 Understamding the structure of an Excel Workdbook.
6 Saving an Excel Document
7 Opening an Exiting Excel Document
8 Excel Shortcut Keys.
Section E102 : Entering and Editing Text and Formulas
1 Entering Text to Create Spread sheet Titles
2 Working with Numeric Data in Excel
3 Working with Date Values in Excel
4 Working with Cell References
5 Creating Basic Formulas in Excel
6 Relative Versus Absolute Cell References in Formulas
7 Understanding the Order of Operation
Section E103 : Working with Basic Excel Functions
1 The structure of an Excel Function
2 Working with the SUM(), MIN(), MAX(), AVERAGE() Function
3 Working with the COUNT() Function
4 Adjacent Cells Error in Excel Calculations
5 Using the Auto Sum Command with shortcut Key
6 Using the AutoFill Command to Copy Formulas
Section E104 : Modifying an Excel Worksheet
1 Moving and Copying Data in an Excel Worksheet
2 Inserting and Deleting Rows and Columns
3 Changing the Width and Height of Cells
4 Hiding and Unhiding Excel Rows and Columns
5 Renaming & Deleting an Excel Worksheet
6 Moving and Copying an Excel Worksheet

Trainer : Mir Masud Uz Zaman www.facebook.com/Exceleschool

Certified Microsoft Office Specialist - Expert 1 of 4 Whatsapp : 01910 623 143
 Section E105 : Formatting Data in an Excel Worksheet
1 Working with Font Formatting Commands
2 Changing the Background Color of a Cell
3 Adding Borders to Cells
4 Formatting Data as Currency Values
5 Formatting Percentages
6 Using Excel's Format Painter
7 Creating Styles to Format Data
8 Merging and Centering Cells
9 Using Conditional Formatting and Editing Conditional formatting
Section E106 : Inserting Images and Shapes into an Excel Worksheet
1 Inserting Images
2 Inserting and Formatting Excel Shapes
3 Working with Excel SmartArt
Section E107 : Creating Basic Charts in Excel
1 Creating an Excel Column Chart
2 Working with the Excel Chart Ribbon
3 Formatting an Excel Chart
4 Adding and Modifying Data on anExcel Chart
5 Moving a Chart to another Worksheet
6 Working with Excel Pie Charts
Section E108 : Printing an Excel Worksheet
1 Viewing your Document in Print Preview
2 Changing the Margins, Scaling andOrienta on
3 Working with Page Layout View
4 Adding Header and Footer Content
5 Printing a Specific Range of Cells

Trainer : Mir Masud Uz Zaman www.facebook.com/Exceleschool

Certified Microsoft Office Specialist - Expert 2 of 4 Whatsapp : 01910 623 143
 Microsoft Excel _ Intermediate Level
Section E201 : Working with an Excel List
1 Understanding Excel List Structure
2 Sorting a List Using Single Level Sort
3 Sorting a List Using Multi Level Sort
4 Using Custom Sorts in an Excel List
5 Filter an Excel List Using the AutoFilter Tool
6 Creating Subtotals in a List
7 Excel Function: SUBTOTAL()
8 Format a List as a Table
9 Using Conditional Formatting to Find Duplicates
10 Removing Duplicates
Section E202 : Working with Large Sets of Excel Data
1 Using the Freeze Panes Tool
2 Grouping Data (Columns and/orRows)
3 Print Options for Large Sets of Data
4 Linking Worksheets (3D Formulas)
5 Consolidating Data from Multiple Worksheets
Section E203 : Excel Data Validation
1 Understand and Create an Excel Data Validation List
2 Adding a Custom Excel DataValida on Error
Section E204 : Excel PivotTables and Pivot Charts
1 Understanding Excel Pivot Tables
2 Creating an Excel Pivot Table
3 Modifying Excel Pivot Table Calculations
4 Grouping Pivot Table Data
5 Formatting Pivot Table Data
6 Modifying Pivot Table Calculations
7 Drilling Down into Pivot Table Data
8 Creating Pivot Charts
9 Filtering Pivot Table Data
10 Filtering with the Slicer Tool
Section E205 : Making a Dynamic Sales Dashboard using Pivot Charts
1 Making a Dashboard - 1
2 Making a Dashboard - 2
3 Making a Dashboard - 3
Section E206 : Protecting Excel Worksheets and Workbooks
1 Protecting Specific Cells in a Worksheet
2 Protecting the Structure of a Workbook
3 Adding a Workbook Password

Trainer : Mir Masud Uz Zaman www.facebook.com/Exceleschool

Certified Microsoft Office Specialist - Expert 3 of 4 Whatsapp : 01910 623 143
 Microsoft Excel_ Advanced Level
Section E301 : Working with Excel's Conditional Functions
1 Working with Excel Name Ranges
2 Advantages and Disadvantages of Excel Name Ranges
3 Editing an Excel Name Range
4 Using Excel's IF() Function
5 Excel's IF() Function with a Name Range
6 Nesting Functions with Excel
7 Nes ng Excels AND() Func onwithin the IF() Func on
8 Using Excel's COUNTIF() Function
9 Using Excel's SUMIF() Function
Section E302 : Working with Excel's Lookup Functions
1 Microsoft Excel VLOOKUP() Function
2 Microsoft Excel HLOOKUP() Function
3 Using Excel's IFERROR() Function
4 Microsoft Excel INDEX() Function
5 Microsoft Excel MATCH() Function
6 Microso Excel INDEX() andMATCH() Func on Combined
7 Microsoft Excel INDEX() and MATCH() Function Combined Continued
Section E303 : Working with Excel's Text Based Functions
1 Using Excel's LEFT(), RIGHT() andMID() Func ons
2 Using Excel's LEN() Function
3 Using Excel's CONCATENATE()Func on
Section E304 : Working with Excel's Date Functions
1 Using Excel's Today() Function
2 Using Excel's Now() Function
3 Using Excel's Weekday() Function
4 Using Excel's Datedif() Function
Section E305 : Auditing an Excel Worksheet
1 Tracing Precedents in Excel Formulas
2 Tracing Dependents in ExcelFormulas
3 Working with the Watch Window
4 Showing Formulas
Microsoft Excel_ Tips and Tricks ( Bonus Section)
Section E401 : Excel Tips and Tricks
Section E402 : Real Life queries with solutions.

Trainer : Mir Masud Uz Zaman www.facebook.com/Exceleschool

Certified Microsoft Office Specialist - Expert 4 of 4 Whatsapp : 01910 623 143