Excel 365/2016 Level 1

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.

Subscribe to this Course

Course Content

Expand All | Collapse All

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

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

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

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

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

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

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

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

9

Lesson 9 – Basic Conditional Formatting

Excel 2016 – 1.9.1 – Using Data Bars

Excel 2016 – 1.9.2 – Using Color Scales

Excel 2016 – 1.9.3 – Using Icon Sets

Excel 2016 – 1.9.4 – Create Multiple Conditions

Excel 2016 – 1.9.5 – Show Top 10%

Excel 2016 – 1.9.6 – CF With Text

Excel 2016 – 1.9.7 – CF With Dates

10

Lesson 10 – Features for Working with Large Data

Excel 2016 – 1.10.1 – Freeze Panes

Excel 2016 – 1.10.2 – How To Split a Screen

Excel 2016 – 1.10.3 – Display Two Copies Of The Same Workbook

Excel 2016 – 1.10.4 – Scale Multiple Pages To Fit On One Page

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

12

Lesson 12 – Set up for Printing

Excel 2016 – 1.12.1 – Print Titles Across Pages

Excel 2016 – 1.12.2 – Insert and Delete Page Breaks

Excel 2016 – 1.12.3 – Use Spell Check

Excel 2016 – 1.12.4 – Print a Selection

Excel 2016 – 1.12.5 – Print Comments or Notes

Excel 2016 – 1.12.6 – Create Custom Views

13

Lesson 13 – Styles

Excel 2016 – 1.13.1 – Apply Cell Styles

Excel 2016 – 1.13.2 – Edit a Style

Excel 2016 – 1.13.3 – Create a Style by Example

Excel 2016 – 1.13.4 – Copy a Style to Another Workbook

Excel 2016 – 1.13.5 – Return to the Normal Style

Excel 2016 -1.13.6 – Delete a Style