77-420: Excel 2013

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

What’s included

135 : Lectures
11h 9m : Duration

$14.99/24.99

Level 1, Section 1 - An introduction to Excel

Lectures	Duration
1. Creating new blank workbooks- 4m	4m
2. Entering data- 9m	9m
3. An introduction to fonts and highlighting- 4m	4m
4. Saving and closing your workbook- 5m	5m
5. Practice Activity Number 1 - The Solution- 2m	2m

Level 1, Section 2 - Create worksheets and workbooks

Lectures	Duration
1. Creating new workbooks using templates- 6m	6m
2. Menus and toolbars- 7m	7m
3. Managing multiple workbooks - Excel 2013 and 2016- 4m	4m
4. Managing multiple workbooks - Excel 2007 and 2010- 7m	7m
5. Importing files and Opening non-native files directly in Excel- 8m	8m
6. Adding worksheets to existing workbooks- 4m	4m
7. Copying and moving worksheets, and changing spreadsheet order- 5m	5m

Level 1, Section 3: Configure worksheets and workbooks to save

Lectures	Duration
1. Saving workbooks in alternate file formats- 7m	7m
2. Maintaining backward compatibility- 6m	6m
3. Saving files to remote locations- 3m	3m

Level 1, Section 4: Basic formulas

Lectures	Duration
1. Using basic operators- 6m	6m
2. Order of operations- 6m	6m
3. How to enter numbers and dates in Excel- 3m	3m
4. Referencing cell ranges in formulas- 10m	10m
5. Practice Activity Number 2 - Solution- 6m	6m

Level 2, Section 1: Navigate through Excel worksheets and workbooks

Lectures	Duration
1. Searching for data within a workbook- 5m	5m
2. Hyperlinks- 5m	5m
3. Using Go To and Using Name Box- 5m	5m
4. Hot Keys- 4m	4m

Level 2, Section 2: Format worksheets and workbooks

Lectures	Duration
1. Changing worksheet tab colour- 5m	5m
2. Inserting and deleting columns and rows- 8m	8m
3. Undo and Redo- 4m	4m
4. File Management tips- 4m	4m
5. Adjusting row height and column width- 5m	5m
6. Hiding columns and rows- 4m	4m
7. Selecting multiple ranges- 4m	4m

Level 2, Section 3: Customise options and views for worksheets and workbooks

Lectures	Duration
1. Hiding worksheets- 4m	4m
2. Customising the Quick Access toolbar- 3m	3m
3. Customising the Ribbon- 5m	5m
4. Assigning shortcut keys- 3m	3m
5. Recording simple macros- 5m	5m
6. Managing macro security- 8m	8m
7. Changing workbook views- 4m	4m
8. Using zoom- 3m	3m
9. Adding values to workbook properties- 5m	5m
10. Displaying formulas- 3m	3m
11. Freezing panes- 5m	5m
12. Splitting the window- 3m	3m

Level 2, Section 4: Configure Excel worksheets and workbooks to print

Lectures	Duration
1. Printing individual worksheets- 3m	3m
2. Printing an entire workbook and printing a selection- 2m	2m
3. Setting a print area- 4m	4m
4. Page setup, Part 1 (first two tabs)- 6m	6m
5. Page setup, Part 2 (Repeating headers and footers)- 3m	3m
6. Adding dynamic text to headers and footers- 3m	3m
7. Inserting watermarks- 3m	3m
8. Page setup, Part 3 (Headings etc.)- 7m	7m
9. Configuring workbooks to print- 3m	3m
10. Inspecting your workbook prior to distribution- 4m	4m

Level 2, Section 5: Utilise cell ranges and references in formulas and functions

Lectures	Duration
1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)- 9m	9m
2. Practice Activity - multiplication table- 3m	3m
3. Answer - multiplication table- 3m	3m

Level 3, Section 1: Insert data in cells and ranges

Lectures	Duration
1. Appending data to Excel worksheets- 3m	3m
2. Setting data validation- 11m	11m
3. Finding and replacing data- 7m	7m
4. Copying and pasting data, including Paste Special- 5m	5m
5. Cutting and moving cell data- 3m	3m
6. Using AutoFill tool, and Expanding data across columns- 5m	5m

Level 3, Section 2: Format cells and ranges

Lectures	Duration
1. Modifying cell alignment and indentation- 5m	5m
2. Wrapping text within cells- 5m	5m
3. Merging cells and Shrink to Fit- 7m	7m
4. Changing font and font styles- 4m	4m
5. Applying highlighting- 2m	2m
6. Applying Number format- 8m	8m
7. Applying borders- 6m	6m
8. Applying cell styles- 3m	3m
9. Using Format Painter- 3m	3m
10. Changing text to WordArt- 2m	2m

Level 3, Section 3: Highlight and filter cells and ranges in Excel

Lectures	Duration
1. Applying conditional formatting - highlighting- 12m	12m
2. Applying conditional formatting - Bars, Scales and Sets- 10m	10m
3. Transposing columns and rows, and #####s- 3m	3m
4. Inserting sparklines, and how to define a range- 5m	5m
5. Customising Sparklines- 7m	7m

Level 3, Section 4: Summarise data with Excel functions

Lectures	Duration
1. Doing calculations without formulas- 3m	3m
2. Utilising the SUM function- 5m	5m
3. Formula syntax - SUM function- 7m	7m
4. Utilising the COUNT function- 7m	7m
5. Utilising the AVERAGE and other averaging functions- 8m	8m
6. Utilising the MIN and MAX functions- 3m	3m
7. Creating named ranges- 8m	8m
8. Getting help with functions- 3m	3m

Level 4, Section 1: Create a table

Lectures	Duration
1. Moving between tables and ranges- 5m	5m
2. Adding and removing cells within tables- 4m	4m
3. Formulas in tables- 6m	6m
4. Defining titles- 4m	4m

Level 4, Section 2: Modify a table

Lectures	Duration
1. Inserting total rows- 4m	4m
2. Adding and removing styles and Banding rows and columns- 6m	6m

Level 4, Section 3: Filtering, Sorting and Grouping

Lectures	Duration
1. Setting up a filter and Filtering records- 6m	6m
2. More advanced filtering options- 12m	12m
3. Using sort options- 5m	5m
4. Sorting data on multiple columns; changing sort order- 4m	4m
5. Removing duplicates- 4m	4m
6. Inserting subtotals- 4m	4m
7. Creating outlines; collapsing groups of data in outlines- 6m	6m
8. Utilising the SUBTOTAL function- 7m	7m

Level 4, Section 4: Utilise conditional logic in functions

Lectures	Duration
1. Utilising the IF function- 8m	8m
2. Utilising the SUMIF function- 6m	6m
3. Utilising the COUNTIF function- 4m	4m
4. Utilising the AVERAGEIF function- 4m	4m
5. Nested IFs and Evaluate Formulas- 6m	6m
6. The CHOOSE function- 3m	3m

Level 5, Section 1: Create a chart in Excel

Lectures	Duration
1. Creating charts and graphs- 6m	6m
2. Adding and removing additional data series- 4m	4m
3. Exploring the Column charts- 6m	6m
4. Line, bar and area charts- 4m	4m
5. Pie charts- 3m	3m
6. Other graph types- 8m	8m
7. Switching between rows and columns in source data- 3m	3m

Level 5, Section 2: Format a chart in Excel

Lectures	Duration
1. Adding legends- 7m	7m
2. Positioning and Resizing charts and graphs, inc- 5m	5m
3. Modifying chart and graph parameters - Excel 2007 and 2010- 6m	6m
4. Modifying chart and graph parameters - Excel 2013 and 2016- 6m	6m
5. Applying chart layouts and styles- 4m	4m

Level 5, Section 3: Insert and format an object

Lectures	Duration
1. Inserting text boxes and positioning objects- 4m	4m
2. Inserting SmartArt- 5m	5m
3. Inserting ClipArt and images- 3m	3m
4. Inserting Screenshots- 3m	3m
5. Adding borders to objects- 5m	5m
6. Inserting shapes- 5m	5m
7. Adding styles and effects to objects- 4m	4m
8. Changing workbook themes- 4m	4m
9. Modifying object properties, including adding alternate text- 5m	5m

Level 5, Section 4: create and modify images by using the Image Editor

Lectures	Duration
1. Making corrections to an image- 3m	3m
2. Using picture colour tools- 2m	2m
3. Send to front and back, and transparent colour- 2m	2m
4. Changing artistic effects on an image- 3m	3m
5. Crop picture- 4m	4m

Level 5, Section 5: Format and modify text with functions

Lectures	Duration
1. Utilising the CONCATENATE function- 5m	5m
2. Utilising the RIGHT, LEFT and MID functions- 7m	7m
3. Utilising the TRIM function- 3m	3m
4. Utilising the UPPER and LOWER functions- 3m	3m