Microsoft Excel 2013/2016 (Basic & Intermediate)

DAY 1

MODULE B1: WALKING THROUGH EXCEL 2013/2016

1. Excel 2013/2016
2. 2013 Landing Page
3. Signing In Office 2013/2016
4. Cloud Computing
5. Charts
6. Quick Analysis
7. Power View
8. Flash Fill

MODULE B2: MANAGING WORKBOOKS & NAVIGATING WITH EXCEL

1. The User Interface
   1. Tabs & Ribbons
   2. Customising The User Interface
2. Using Shortcuts
   1. Keyboard short cuts
   2. Keyboard & mouse combinations
3. Getting More Menu Options
4. Creating A New Workbook
5. Saving A Workbook
6. Opening A Workbook
7. What’s Compatibility Mode?
   1. Problems With Compatibility Mode
   2. How to Convert a file in Compatibility Mode
8. Working With Templates
9. Handling Multiple Workbooks
10. Selecting A Range
    1. With Mouse
    2. With Keyboard
    3. With Short Cut Keys
    4. When to use the SHIFT key
    5. When to use the CTRL key

MODULE B3: DATA ENTRY IN EXCEL

1. Entering and Editing Data
   1. Text
   2. Values
   3. Formulas
2. Copying & Pasting Data
   1. Short cuts
   2. The Various Types of Paste
3. Filling Trends, Formulas & Text
   1. Short cuts
   2. Fill Tricks
   3. Flash Fill

MODULE B4: INTRODUCTION TO FUNCTIONS AND FORMULAS

1. Basic Formulas
   1. Operators
   2. Using cell references
2. Functions
   1. AutoSum
   2. Summing Tricks
   3. AVERAGE / AVERAGEA
   4. MAX / MIN
   5. COUNT / COUNTA

MODULE B5: MODIFYING A WORKSHEET

1. Handling Columns & Rows
   1. Changing Column Width
   2. Fitting Contents to a Column
   3. Adding & Removing Columns
   4. Hiding Columns
   5. Adding & Removing Rows
   6. Hiding Rows
   7. Fitting Font Size to a Row
2. Formatting Text
   1. Changing the Font Properties
   2. Using Cell Styles
3. Formatting Numbers
   1. Changing Number Formats
   2. Customising Number formats
4. Changing Alignment
   1. Changing Text Alignment
   2. Merging Cells
   3. Controlling Text Appearance in a cell
5. Borders and Shading
6. Format Painter

MODULE B6: PRINTING YOUR WORK

1. Printing Your Worksheet
   1. Choosing What To Print
   2. How To Insert / Remove Page Breaks
   3. Changing Page Orientation
   4. Creating Custom Headers
   5. Inserting Dates & Page Numbers
2. How to Print Repeated Headings in Excel
3. How to Print The Entire Workbook

DAY 2

MODULE I1: WORKSHEETS AND WORKBOOKS

1. Managing The View of Your Worksheet
   1. Changing the Zoom settings
   2. Freezing Rows & Columns for large worksheets
   3. Splitting windows to views different parts of the worksheet
   4. Customising and Saving Custom Views with hidden rows / columns together with print settings
2. Handling Multiple Windows
   1. Viewing Multiple Workbooks Simultaneously
   2. Viewing Multiple Sheets Within the same Workbook Simultaneously
3. Managing Worksheets
   1. Hiding and Unhiding Worksheets
   2. Changing Tab Colors
   3. Renaming Worksheet
   4. Adding / Removing Worksheets
   5. Moving Worksheets
   6. Copying Worksheets
   7. Deleting Worksheets
4. Manipulating WorkSheets Simultaneously

MODULE I2: BASIC FUNCTIONS & FORMULAS

1. Understanding Cell References
   1. When to use the double $ sign ($A$1)
   2. When to use the single $ sign ($A1 or A$1)
2. Inserting Date and Time
   1. Shortcuts
   2. TODAY Function
   3. NOW Function
3. Conditional Count & Sum Function
   1. COUNTIF
   2. SUMIF

MODULE I3: ANALYSING DATA

1. Quick Analysis
   1. Conditional Formatting
   2. Recommended Charts
   3. Automatic Totals
   4. Tables
   5. Recommended Pivot Tables
   6. Sparklines

MODULE I4: PERFORMING VISUAL ANALYSIS

1. With Formatting
2. Applying Cell Formatting
3. Using Built In Pre-sets
4. Using Data Bars and Icon Sets
5. Using Custom Rules
6. Managing Rules
7. Prioritizing Rules

MODULE I5: ADDING ILLUSTRATIONS

1. Customizing your Workbook
2. Adding Shapes
   1. Formatting
   2. Adding Effects
3. Precision Text Placement with Text Boxes
   1. Adding a Text Box
   2. Formatting a Text Box
   3. Creating Dynamic Text Box
4. SmartArt
   1. Inserting SmartArt
   2. Adding Text
   3. Formating With Colours & 3D Effects
5. Inserting Image Files
   1. Insert a Photo
   2. Performing Colour Corrections
   3. Adding Effects
   4. Removing Background
   5. Layering Images
   6. Grouping objects

MODULE I6: PERFORMING VISUAL ANALYSIS

1. With Charts
2. Introduction To Charting
3. Excel 2013’s Recommended Chart
4. Inserting A Chart
   1. Column
   2. Bar
   3. Line
   4. Pie
   5. Dual Axis Charts
   6. Combination Charts
5. Adding Chart Elements
   1. Title
   2. Legend
   3. Data Labels
   4. Data Table
6. Chart Styles (Formatting a Chart)
   1. Change the Chart Type
   2. Changing the Chart Location
   3. Adding Dynamic Text Boxes
   4. Adding An Image in the Plot Area
7. Adding Chart Data
8. Filtering Chart Data
9. Charting Tips.

APPENDIX A

1. Excel 2013 Short Cuts
2. CTRL combination shortcut keys
3. Function shortcut keys
4. Other useful shortcut keys