Excel 365/2016 Level 1
Excel 2016 Level 1 is suitable for those who are coming to Excel for the first time or for those who are self-taught and would like to pick up best practice techniques. This course will also be of value for those who are migrating from an earlier version of Excel or for those who would like to improve on some of their basic Excel skills.
Course Content
Lessons
Status
1
Lesson 1 – Getting Comfortable with Excel
-
Excel 2016 – 1.1.1 – Open Excel
-
Excel 2016 – 1.1.2 – The Excel Screen
-
Excel 2016 – 1.1.3 – Basics of Entering Data
-
Excel 2016 – 1.1.4 – Enter a Table of Data
-
Excel 2016 – 1.1.5 – Adjust Column and Row Widths
-
Excel 2016 – 1.1.6 – Close a Workbook But Not Excel
-
Excel 2016 – 1.1.7 – Create, Save, Close and Re-open a Workbook
- Excel 2016 – 1.1.1 – Open Excel
- Excel 2016 – 1.1.2 – The Excel Screen
- Excel 2016 – 1.1.3 – Basics of Entering Data
- Excel 2016 – 1.1.4 – Enter a Table of Data
- Excel 2016 – 1.1.5 – Adjust Column and Row Widths
- Excel 2016 – 1.1.6 – Close a Workbook But Not Excel
- Excel 2016 – 1.1.7 – Create, Save, Close and Re-open a Workbook
2
Lesson 2 – Basic Features of Excel
-
Excel 2016 – 1.2.1 – Open an Existing Workbook & Move Between Two Workbooks
-
Excel 2016 – 1.2.2 – Customise the Quick Access Toolbar
-
Excel 2016 – 1.2.3 – Customise the Ribbon
-
Excel 2016 – 1.2.4 – Basic Keyboard Navigation Techniques
-
Excel 2016 – 1.2.5 – Basic Keyboard Selection Techniques
-
Excel 2016 – 1.2.6 – Basic Font and Cell Formatting
-
Excel 2016 – 1.2.7 – Basic Alignment Features
-
Excel 2016 – 1.2.8 – Using Undo and Redo
-
Excel 2016 – 1.2.9 – Issues With Deleting
-
Excel 2016 – 1.2.10 – Using Help
-
Excel 2016 – 1.2.11 – Using Find & Replace
-
Excel 2016 – 1.2.12 – Create Comments or Notes
- Excel 2016 – 1.2.1 – Open an Existing Workbook & Move Between Two Workbooks
- Excel 2016 – 1.2.2 – Customise the Quick Access Toolbar
- Excel 2016 – 1.2.3 – Customise the Ribbon
- Excel 2016 – 1.2.4 – Basic Keyboard Navigation Techniques
- Excel 2016 – 1.2.5 – Basic Keyboard Selection Techniques
- Excel 2016 – 1.2.6 – Basic Font and Cell Formatting
- Excel 2016 – 1.2.7 – Basic Alignment Features
- Excel 2016 – 1.2.8 – Using Undo and Redo
- Excel 2016 – 1.2.9 – Issues With Deleting
- Excel 2016 – 1.2.10 – Using Help
- Excel 2016 – 1.2.11 – Using Find & Replace
- Excel 2016 – 1.2.12 – Create Comments or Notes
3
Lesson 3 – Work with Basic Formulae
-
Excel 2016 – 1.3.1 – Signs Used for Calculation
-
Excel 2016 – 1.3.2 – Addition Using a Formula
-
Excel 2016 – 1.3.3 – Subtraction Using a Formula
-
Excel 2016 – 1.3.4 – Multiplication Using a Formula
-
Excel 2016 – 1.3.5 – Division Using a Formula
-
Excel 2016 – 1.3.6 – Calculate a % Of
-
Excel 2016 – 1.3.7 – Understand Calculation Mode
-
Excel 2016 – 1.3.8 – Order of Operations
-
Excel 2016 – 1.3.9 – % Difference Between Two Years
- Excel 2016 – 1.3.1 – Signs Used for Calculation
- Excel 2016 – 1.3.2 – Addition Using a Formula
- Excel 2016 – 1.3.3 – Subtraction Using a Formula
- Excel 2016 – 1.3.4 – Multiplication Using a Formula
- Excel 2016 – 1.3.5 – Division Using a Formula
- Excel 2016 – 1.3.6 – Calculate a % Of
- Excel 2016 – 1.3.7 – Understand Calculation Mode
- Excel 2016 – 1.3.8 – Order of Operations
- Excel 2016 – 1.3.9 – % Difference Between Two Years
4
Lesson 4 – Work with Basic Functions
-
Excel 2016 – 1.4.1 – How To Use The AutoSum Function
-
Excel 2016 – 1.4.2 – How To Use The AVERAGE Function
-
Excel 2016 – 1.4.3 – How To Use The MAX Function
-
Excel 2016 – 1.4.4 – How To Use The MIN Function
-
Excel 2016 – 1.4.5 – How To Use The COUNT (Numbers) Function
-
Excel 2016 – 1.4.6 – How To Use The COUNTA Function
-
Excel 2016 – 1.4.7 – How To Use The COUNTBLANK Function
-
Excel 2016 – 1.4.8 – Calculating Functions By Row
- Excel 2016 – 1.4.1 – How To Use The AutoSum Function
- Excel 2016 – 1.4.2 – How To Use The AVERAGE Function
- Excel 2016 – 1.4.3 – How To Use The MAX Function
- Excel 2016 – 1.4.4 – How To Use The MIN Function
- Excel 2016 – 1.4.5 – How To Use The COUNT (Numbers) Function
- Excel 2016 – 1.4.6 – How To Use The COUNTA Function
- Excel 2016 – 1.4.7 – How To Use The COUNTBLANK Function
- Excel 2016 – 1.4.8 – Calculating Functions By Row
5
Lesson 5 – Understand how Calculations Work
-
Excel 2016 – 1.5.1 – How Relative Calculations Work
-
Excel 2016 – 1.5.2 – Relative Calculation Problem
-
Excel 2016 – 1.5.3 – When Not To Use a Relative Calculation
-
Excel 2016 – 1.5.4 – Understand Absolute Calculation
-
Excel 2016 – 1.5.5 – Convert a Number To Text
-
Excel 2016 – 1.5.6 – Explanation Of Number Conversion
-
Excel 2016 – 1.5.7 – Convert Multiple Numbers To Text
-
Excel 2016 – 1.5.8 – Convert Blank Cells To Text
- Excel 2016 – 1.5.1 – How Relative Calculations Work
- Excel 2016 – 1.5.2 – Relative Calculation Problem
- Excel 2016 – 1.5.3 – When Not To Use a Relative Calculation
- Excel 2016 – 1.5.4 – Understand Absolute Calculation
- Excel 2016 – 1.5.5 – Convert a Number To Text
- Excel 2016 – 1.5.6 – Explanation Of Number Conversion
- Excel 2016 – 1.5.7 – Convert Multiple Numbers To Text
- Excel 2016 – 1.5.8 – Convert Blank Cells To Text
6
Lesson 6 – Different Types of Cut, Copy and Paste
-
Excel 2016 – 1.6.1 – Create a Series Fill Using Text
-
Excel 2016 – 1.6.2 – Series Fill Using Numbers and Dates
-
Excel 2016 – 1.6.3 – Cut and Paste
-
Excel 2016 – 1.6.4 – Copy and Paste
-
Excel 2016 – 1.6.5 – Keep Column Widths
-
Excel 2016 – 1.6.6 – Transpose
-
Excel 2016 – 1.6.7 – Paste Values
-
Excel 2016 – 1.6.8 – Fill Handle
-
Excel 2016 – 1.6.9 – Using Flash Fill
- Excel 2016 – 1.6.1 – Create a Series Fill Using Text
- Excel 2016 – 1.6.2 – Series Fill Using Numbers and Dates
- Excel 2016 – 1.6.3 – Cut and Paste
- Excel 2016 – 1.6.4 – Copy and Paste
- Excel 2016 – 1.6.5 – Keep Column Widths
- Excel 2016 – 1.6.6 – Transpose
- Excel 2016 – 1.6.7 – Paste Values
- Excel 2016 – 1.6.8 – Fill Handle
- Excel 2016 – 1.6.9 – Using Flash Fill
7
Lesson 7 – Page Layout
-
Excel 2016 – 1.7.1 – Insert & Delete Columns & Rows
-
Excel 2016 – 1.7.2 – Insert, Rename & Delete Sheets
-
Excel 2016 – 1.7.3 – Move and Copy Sheets Within a Workbook
-
Excel 2016 – 1.7.4 – Move and Copy Sheets Between Workbooks
-
Excel 2016 – 1.7.5 – Hide/Unhide Columns
-
Excel 2016 – 1.7.6 – Hide/Unhide Rows
-
Excel 2016 – 1.7.7 – Hide/Unhide Sheets
-
Excel 2016 – 1.7.8 – Change The Page Orientation
-
Excel 2016 – 1.7.9 – Change Page Margins
-
Excel 2016 – 1.7.10 – Insert Headers & Footers
-
Excel 2016 – 1.7.11 – Group Worksheets
- Excel 2016 – 1.7.1 – Insert & Delete Columns & Rows
- Excel 2016 – 1.7.2 – Insert, Rename & Delete Sheets
- Excel 2016 – 1.7.3 – Move and Copy Sheets Within a Workbook
- Excel 2016 – 1.7.4 – Move and Copy Sheets Between Workbooks
- Excel 2016 – 1.7.5 – Hide/Unhide Columns
- Excel 2016 – 1.7.6 – Hide/Unhide Rows
- Excel 2016 – 1.7.7 – Hide/Unhide Sheets
- Excel 2016 – 1.7.8 – Change The Page Orientation
- Excel 2016 – 1.7.9 – Change Page Margins
- Excel 2016 – 1.7.10 – Insert Headers & Footers
- Excel 2016 – 1.7.11 – Group Worksheets
8
Lesson 8 – Formatting
-
Excel 2016 – 1.8.1 – Format Figures As Currency
-
Excel 2016 – 1.8.2 – Format Figures As Percentages
-
Excel 2016 – 1.8.3 – Format As Dates
-
Excel 2016 – 1.8.4 – Format As Time
-
Excel 2016 – 1.8.5 – Add Borders To Excel Data
-
Excel 2016 – 1.8.6 – Add Background and Font Colouring
-
Excel 2016 – 1.8.7 – Remove Formatting
-
Excel 2016 – 1.8.8 – Using Merge & Center
-
Excel 2016 – 1.8.9 – Wrap Text and Line Breaks
-
Excel 2016 – 1.8.10 – About Custom Formatting
-
Excel 2016 – 1.8.11 – Create Custom Formats
-
Excel 2016 – 1.8.12 – Custom Format Example
-
Excel 2016 – 1.8.13 – Custom Date Formatting
- Excel 2016 – 1.8.1 – Format Figures As Currency
- Excel 2016 – 1.8.2 – Format Figures As Percentages
- Excel 2016 – 1.8.3 – Format As Dates
- Excel 2016 – 1.8.4 – Format As Time
- Excel 2016 – 1.8.5 – Add Borders To Excel Data
- Excel 2016 – 1.8.6 – Add Background and Font Colouring
- Excel 2016 – 1.8.7 – Remove Formatting
- Excel 2016 – 1.8.8 – Using Merge & Center
- Excel 2016 – 1.8.9 – Wrap Text and Line Breaks
- Excel 2016 – 1.8.10 – About Custom Formatting
- Excel 2016 – 1.8.11 – Create Custom Formats
- Excel 2016 – 1.8.12 – Custom Format Example
- Excel 2016 – 1.8.13 – Custom Date Formatting
11
Lesson 11 – Present Data as a Chart
-
Excel 2016 – 1.11.1 – Create a Column Chart
-
Excel 2016 – 1.11.2 – Format a Chart Using The Design Tab
-
Excel 2016 – 1.11.3 – Format a Chart Using The Format Tab
-
Excel 2016 – 1.11.4 – Format a Chart Using The Chart Tabs
-
Excel 2016 – 1.11.5 – The Special Printing Feature Of Charts
-
Excel 2016 – 1.11.6 – Create a Pie Chart
-
Excel 2016 – 1.11.7 – Specific Formats For Pie Charts
- Excel 2016 – 1.11.1 – Create a Column Chart
- Excel 2016 – 1.11.2 – Format a Chart Using The Design Tab
- Excel 2016 – 1.11.3 – Format a Chart Using The Format Tab
- Excel 2016 – 1.11.4 – Format a Chart Using The Chart Tabs
- Excel 2016 – 1.11.5 – The Special Printing Feature Of Charts
- Excel 2016 – 1.11.6 – Create a Pie Chart
- Excel 2016 – 1.11.7 – Specific Formats For Pie Charts