Excel 2013 Level 1
Excel 2013 Level 1 is suitable for those who are completely new to Excel or for those who are self-taught and would like to pick up some tips. This course will also be of value for those who would like to brush up on some of their existing Excel skills.
Course Content
Lessons
Status
1
Lesson 1 – Getting Comfortable with Excel
-
Excel 2013 – 1.1.1 – Customise the Start Screen
-
Excel 2013 – 1.1.2 – Customise the Quick Access Toolbar
-
Excel 2013 – 1.1.3 – Customise the Ribbon
-
Excel 2013 – 1.1.4 – Basic Entering and Editing of Data
-
Excel 2013 – 1.1.5 – Basic Keyboard Navigation Techniques
-
Excel 2013 – 1.1.6 – Basic Keyboard Selection Techniques
-
Excel 2013 – 1.1.7 – Using Undo and Redo
-
Excel 2013 – 1.1.8 – Issues with Deleting Content and Formats
-
Excel 2013 – 1.1.9 – Saving a Workbook
-
Excel 2013 – 1.1.10 – Using Help
- Excel 2013 – 1.1.1 – Customise the Start Screen
- Excel 2013 – 1.1.2 – Customise the Quick Access Toolbar
- Excel 2013 – 1.1.3 – Customise the Ribbon
- Excel 2013 – 1.1.4 – Basic Entering and Editing of Data
- Excel 2013 – 1.1.5 – Basic Keyboard Navigation Techniques
- Excel 2013 – 1.1.6 – Basic Keyboard Selection Techniques
- Excel 2013 – 1.1.7 – Using Undo and Redo
- Excel 2013 – 1.1.8 – Issues with Deleting Content and Formats
- Excel 2013 – 1.1.9 – Saving a Workbook
- Excel 2013 – 1.1.10 – Using Help
2
Lesson 2 – Work with Basic Formulae
-
Excel 2013 – 1.2.1 – Addition using a Formula
-
Excel 2013 – 1.2.2 – Subtraction using a Formula
-
Excel 2013 – 1.2.3 – Multiplication using a Formula
-
Excel 2013 – 1.2.4 – Division using a Formula
-
Excel 2013 – 1.2.5 – Calculate a % Of
-
Excel 2013 – 1.2.6 – Understand Calculation Mode
-
Excel 2013 – 1.2.7 – Understand the Order of Operations
-
Excel 2013 – 1.2.8 – Calculate the % Difference Between Two Values
- Excel 2013 – 1.2.1 – Addition using a Formula
- Excel 2013 – 1.2.2 – Subtraction using a Formula
- Excel 2013 – 1.2.3 – Multiplication using a Formula
- Excel 2013 – 1.2.4 – Division using a Formula
- Excel 2013 – 1.2.5 – Calculate a % Of
- Excel 2013 – 1.2.6 – Understand Calculation Mode
- Excel 2013 – 1.2.7 – Understand the Order of Operations
- Excel 2013 – 1.2.8 – Calculate the % Difference Between Two Values
3
Lesson 3 – Work with Basic Functions
-
Excel 2013 – 1.3.1 – How to use the AutoSum Function
-
Excel 2013 – 1.3.2 – How to use the AVERAGE Function
-
Excel 2013 – 1.3.3 – How to use the MAX Function
-
Excel 2013 – 1.3.4 – How to use the MIN Function
-
Excel 2013 – 1.3.5 – How to use the COUNT (Numbers) Function
-
Excel 2013 – 1.3.6 – How to use the COUNTA Function
-
Excel 2013 – 1.3.7 – How to use the COUNTBLANK Function
-
Excel 2013 – 1.3.8 – Calculating Functions by Row
- Excel 2013 – 1.3.1 – How to use the AutoSum Function
- Excel 2013 – 1.3.2 – How to use the AVERAGE Function
- Excel 2013 – 1.3.3 – How to use the MAX Function
- Excel 2013 – 1.3.4 – How to use the MIN Function
- Excel 2013 – 1.3.5 – How to use the COUNT (Numbers) Function
- Excel 2013 – 1.3.6 – How to use the COUNTA Function
- Excel 2013 – 1.3.7 – How to use the COUNTBLANK Function
- Excel 2013 – 1.3.8 – Calculating Functions by Row
4
Lesson 4 – Understand how Calculations Work
-
Excel 2013 – 1.4.1 – How Relative Calculations Work
-
Excel 2013 – 1.4.2 – Relative Calculation Problem
-
Excel 2013 – 1.4.3 – When NOT to use Relative Calculation
-
Excel 2013 – 1.4.4 – Understand Absolute Calculation
-
Excel 2013 – 1.4.5 – Convert Single Numbers to Text
-
Excel 2013 – 1.4.6 – Explanation of Number Conversion
-
Excel 2013 – 1.4.7 – Convert Multiple Numbers to Text
-
Excel 2013 – 1.4.8 – Convert Blank Cells to Text
- Excel 2013 – 1.4.1 – How Relative Calculations Work
- Excel 2013 – 1.4.2 – Relative Calculation Problem
- Excel 2013 – 1.4.3 – When NOT to use Relative Calculation
- Excel 2013 – 1.4.4 – Understand Absolute Calculation
- Excel 2013 – 1.4.5 – Convert Single Numbers to Text
- Excel 2013 – 1.4.6 – Explanation of Number Conversion
- Excel 2013 – 1.4.7 – Convert Multiple Numbers to Text
- Excel 2013 – 1.4.8 – Convert Blank Cells to Text
5
Lesson 5 – Different Types of Cut, Copy and Paste
-
Excel 2013 – 1.5.1 – Create a Series Fill using Text
-
Excel 2013 – 1.5.2 – Series Fill using Numbers and Dates
-
Excel 2013 – 1.5.3 – Different Ways to Cut and Paste
-
Excel 2013 – 1.5.4 – Different Ways to Copy and Paste
-
Excel 2013 – 1.5.5 – Paste Column Widths
-
Excel 2013 – 1.5.6 – Transpose
-
Excel 2013 – 1.5.7 – Paste Values
-
Excel 2013 – 1.5.8 – Using the Fill Handle
- Excel 2013 – 1.5.1 – Create a Series Fill using Text
- Excel 2013 – 1.5.2 – Series Fill using Numbers and Dates
- Excel 2013 – 1.5.3 – Different Ways to Cut and Paste
- Excel 2013 – 1.5.4 – Different Ways to Copy and Paste
- Excel 2013 – 1.5.5 – Paste Column Widths
- Excel 2013 – 1.5.6 – Transpose
- Excel 2013 – 1.5.7 – Paste Values
- Excel 2013 – 1.5.8 – Using the Fill Handle
6
Lesson 6 – Page Layout
-
Excel 2013 – 1.6.1 – Inserting and Deleting Columns and Rows
-
Excel 2013 – 1.6.2 – Insert, Rename and Delete Sheets
-
Excel – 1.6.3 – Moving and Copying Sheets Within a Workbook
-
Excel 2013 – 1.6.4 – Hiding and Unhiding Rows, Columns and Sheets
-
Excel 2013 – 1.6.5 – Change the Page Orientation
-
Excel 2013 – 1.6.6 – Adjust Page Margins
-
Excel 2013 – 1.6.7 – Insert Headers & Footers
-
Excel 2013 – 1.6.7 – Insert Headers & Footers
- Excel 2013 – 1.6.1 – Inserting and Deleting Columns and Rows
- Excel 2013 – 1.6.2 – Insert, Rename and Delete Sheets
- Excel – 1.6.3 – Moving and Copying Sheets Within a Workbook
- Excel 2013 – 1.6.4 – Hiding and Unhiding Rows, Columns and Sheets
- Excel 2013 – 1.6.5 – Change the Page Orientation
- Excel 2013 – 1.6.6 – Adjust Page Margins
- Excel 2013 – 1.6.7 – Insert Headers & Footers
- Excel 2013 – 1.6.7 – Insert Headers & Footers
7
Lesson 7 – Formatting
-
Excel 2013 – 1.7.1 – Format Figures as Currency
-
Excel 2013 – 1.7.2 – Format Figures as Percentages
-
Excel 2013 – 1.7.3 – Format as Dates
-
Excel 2013 – 1.7.4 – Format as Time
-
Excel 2013 – 1.7.5 – Add Borders
-
Excel 2013 – 1.7.6 – Format Background and Font
-
Excel 2013 – 1.7.7 – Remove Borders, Shading and Font Colour
-
Excel 2013 – 1.7.8 – Using Merge & Center
-
Excel 2013 – 1.7.8 – Using Merge & Center
-
Excel 2013 – 1.7.9 – Using Wrap Text and Line Breaks
- Excel 2013 – 1.7.1 – Format Figures as Currency
- Excel 2013 – 1.7.2 – Format Figures as Percentages
- Excel 2013 – 1.7.3 – Format as Dates
- Excel 2013 – 1.7.4 – Format as Time
- Excel 2013 – 1.7.5 – Add Borders
- Excel 2013 – 1.7.6 – Format Background and Font
- Excel 2013 – 1.7.7 – Remove Borders, Shading and Font Colour
- Excel 2013 – 1.7.8 – Using Merge & Center
- Excel 2013 – 1.7.8 – Using Merge & Center
- Excel 2013 – 1.7.9 – Using Wrap Text and Line Breaks
8
Lesson 8 – Basic Conditional Formatting
-
Excel 2013 – 1.8.1 – Conditional Formatting using Data Bars
-
Excel 2013 – 1.8.2 – Conditional Formatting using Color Scales
-
Excel 2013 – 1.8.3 – Conditional Formatting using Icon Sets
-
Excel 2013 – 1.8.4 – Create Multiple Conditions
-
Excel 2013 – 1.8.5 – Conditional Formatting to Show Top 40%
-
Excel 2013 – 1.8.6 – Conditional Formatting Using Text
-
Excel 2013 – 1.8.7 – Conditional Formatting Using Dates
- Excel 2013 – 1.8.1 – Conditional Formatting using Data Bars
- Excel 2013 – 1.8.2 – Conditional Formatting using Color Scales
- Excel 2013 – 1.8.3 – Conditional Formatting using Icon Sets
- Excel 2013 – 1.8.4 – Create Multiple Conditions
- Excel 2013 – 1.8.5 – Conditional Formatting to Show Top 40%
- Excel 2013 – 1.8.6 – Conditional Formatting Using Text
- Excel 2013 – 1.8.7 – Conditional Formatting Using Dates
10
Lesson 10 – Present Data as a Chart
-
Excel 2013 – 1.10.1 – Create a Column Chart
-
Excel 2013 – 1.10.2 – Format a Chart Using the Design Tab
-
Excel 2013 – 1.10.3 – Format a Chart Using the Format Tab
-
Excel 2013 – 1.10.4 – Format a Chart Using the Chart Tabs
-
Excel 2013 – 1.10.5 – The Special Printing Feature of Charts
-
Excel 2013 – 1.10.6 – Create a Pie Chart
-
Excel 2013 – 1.10.7 – Specific Formats for Pie Charts
- Excel 2013 – 1.10.1 – Create a Column Chart
- Excel 2013 – 1.10.2 – Format a Chart Using the Design Tab
- Excel 2013 – 1.10.3 – Format a Chart Using the Format Tab
- Excel 2013 – 1.10.4 – Format a Chart Using the Chart Tabs
- Excel 2013 – 1.10.5 – The Special Printing Feature of Charts
- Excel 2013 – 1.10.6 – Create a Pie Chart
- Excel 2013 – 1.10.7 – Specific Formats for Pie Charts