22/04/2015
Two months Excel Training Basics to Advance Level
Session 1: Introduction
1.01 Introduction
1.02 Interface
1.03 Tabs and Ribbons
1.04 Document Windows
1.05 Navigation Tips
1.06 Office Button and Save (2007) Backstage (2010)
Session 2: Entering, Editing and Formatting Data
2.01 Introduction
2.02 Entering Data
2.03 Fonts, Fills & Alignments
2.04 Cut, Copy & Paste
2.05 Paste Special
2.06 Undo & Redo
2.07 Moving, Finding and Replacing a Value
2.08 Cell Styles
2.09 Comments
2.10 Copy as Picture (Excel 2010 only)
Session 3: Formatting Numbers
3.01 Introduction
3.02 Currency Format
3.03 Format Painter
3.04 Formatting Dates
3.05 Custom and Special Formats
Session 4: Managing Worksheets
4.01 Introduction
4.02 Naming and Moving Worksheets
4.03 Copying Worksheets
4.04 Adding, Deleting and Hiding Worksheets
4.05 Grouping Worksheets
4.06 Move, Copy, Delete and Hide Grouped Worksheets
Session 5: Modifying Rows and Columns
5.01 Introduction
5.02 Inserting and Deleting Columns and Rows
5.03 Inserting & Deleting Cells
5.04 Inserting Multiple Columns and Rows
5.05 Modifying Cell Width and Height
5.06 Hiding and Unhiding Rows and Columns
Session 6: Understanding Formulas
6.01 Introduction
6.02 Using Operations
6.03 Creating Formulas
6.04 AutoSum
6.05 Common Functions
6.06 Searching for Functions
6.07 Copying Formulas
6.08 Using Relative and Absolute References
Session 7: Changing Views
7.01 Introduction
7.02 Workbook Views
7.03 Show/Hide
7.04 Zoom Features
7.05 Freeze Panes
7.06 Split Windows
7.07 Viewing Multiple Windows
7.08 Minimise The Ribbon
7.09 Worksheet Backgrounds
7.10 Watermarks
Session 8: AutoFill and Custom Lists
8.01 Introduction
8.02 Autofill a Series
8.03 Autofill Non-Adjacent Cells
8.04 Autofill on Multiple Sheets
8.05 Creating Custom Lists
8.06 Series Formatting
Session 9: Conditional Formatting
9.01 Introduction
9.02 Highlight Cell Rules
9.03 Top/Bottom Rules
9.04 Data Bars
9.05 Color Scales
9.06 Custom Formatting Rules
Session 10: Tables
10.01 Introduction
10.02 Insert a Table and Style Options
10.03 Add Rows & Columns
10.04 Perform A Function In A Table
10.05 Summarise With Pivot Table
Session 11: Data Tools
11.01 Introduction
11.02 Data Validation
11.03 Drop Down Lists
11.04 Removing Duplicates
11.05 Text To Columns
11.06 Goal Seek
11.07 Scenario Manager
11.08 Importing and Exporting Data
Session 12: Referencing Formulas
12.01 Introduction
12.02 Multiple Sheet References
12.03 Consolidating Data – With or Without Links
12.04 Trace the Precedents and Dependents
12.05 Using the Watch Window
Session 13: Ranges and Dates
13.01 Introduction
13.02 Cell Names
13.03 Named Ranges
13.04 Formulas With Cell Names
13.05 Date Formulas
Session 14: Lookups
14.01 Introduction
14.02 VLOOKUP
14.03 VLOOKUP Exact Match
14.04 HLOOKUP
14.05 HLOOKUP Exact Match
14.06 CHOOSE
14.07 INDEX & MATCH
Session 15: Conditional Logic
15.01 Introduction
15.02 IF Statement
15.03 Nested IF
15.04 IF AND Functions Nested
15.05 IF OR Functions Nested
15.06 IF NOT Functions Nested
15.07 IFERROR
15.08 SUMIF and SUMIFS
15.09 AVERAGEIF and AVERAGEIFS
15.10 COUNTIF and COUNTIFS
15.11 SUMPRODUCT
Session 16: Text Formulas
16.01 Introduction
16.02 Case Formulas
16.03 Fix Number Fields
16.04 Trim Spaces
16.05 Substitute Text
Session 17: Introduction to Charts
17.01 Introduction
17.02 Chart Types
17.03 Instant Chart – Pie Chart
17.04 Update Chart
17.05 Column Chart
17.06 Picture Fill
17.07 Adjust Chart Size
17.08 Line Chart
17.09 Scatter Chart
17.10 Sparklines (Excel 2010)
Session 18: Formatting Charts
18.01 Introduction
18.02 Chart Styles
18.03 Chart Layouts
18.04 Add Labels
18.05 Axis Options
18.06 Chart Titles
18.07 Legends
18.08 Data Labels
Session 19: Adding Graphics to Spreadsheets
19.01 Introduction
19.02 Insert Pictures
19.03 Modifying Pictures
19.04 Insert Shapes
19.05 Insert Smart Art
19.06 Apply Themes
19.07 Arrange
Session 20: Outline, Sort, Filter, and Subtotal
20.01 Introduction
20.02 Group & Ungroup
20.03 Sort Data
20.04 Sort Multiple Levels
20.05 Filter Data
20.06 Advanced Filter
20.07 Conditional Sorting and Filtering
20.08 Sorting with Custom Lists
20.09 Subtotal
Session 21: PivotTables
21.01 Introduction
21.02 Creating Pivot Tables
21.03 Choosing Fields
21.04 Pivot Table Layout
21.05 Filtering Pivot Tables
21.06 Modifying Pivot Table Data
21.07 Pivot Charts
21.08 Slicers (2010 Only)
Session 22: Protecting Data
22.01 Introduction
22.02 Workbook Passwords
22.03 Protecting Workbooks
22.04 Unlocking Cells
Session 23: Collaboration
23.01 Introduction
23.02 Documents Properties
23.03 Inserting Hyperlinks
23.04 Sharing A Workbook
23.05 Track Changes
23.06 Accept/Reject Changes
23.07 Mark As Final
Session 24: Printing
24.01 Introduction
24.02 Page Orientation
24.03 Page Breaks
24.04 Print Area
24.05 Margins
24.06 Print Titles
24.07 Headers and Footers
24.08 Scaling
24.09 Sheet Options
