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.
$14.99 / $24.99
Level 1, Section 1 - An introduction to Excel
-
1. Creating new blank workbooks4m
-
2. Entering data9m
-
3. An introduction to fonts and highlighting4m
-
4. Saving and closing your workbook5m
-
5. Practice Activity Number 1 - The Solution2m
Level 1, Section 2 - Create worksheets and workbooks
-
1. Creating new workbooks using templates6m
-
2. Menus and toolbars7m
-
3. Managing multiple workbooks - Excel 2013 and 20164m
-
4. Managing multiple workbooks - Excel 2007 and 20107m
-
5. Importing files and Opening non-native files directly in Excel8m
-
6. Adding worksheets to existing workbooks4m
-
7. Copying and moving worksheets, and changing spreadsheet order5m
Level 1, Section 3: Configure worksheets and workbooks to save
-
1. Saving workbooks in alternate file formats7m
-
2. Maintaining backward compatibility6m
-
3. Saving files to remote locations3m
Level 1, Section 4: Basic formulas
-
1. Using basic operators6m
-
2. Order of operations6m
-
3. How to enter numbers and dates in Excel3m
-
4. Referencing cell ranges in formulas10m
-
5. Practice Activity Number 2 - Solution6m
Level 2, Section 1: Navigate through Excel worksheets and workbooks
-
1. Searching for data within a workbook5m
-
2. Hyperlinks5m
-
3. Using Go To and Using Name Box5m
-
4. Hot Keys4m
Level 2, Section 2: Format worksheets and workbooks
-
1. Changing worksheet tab colour5m
-
2. Inserting and deleting columns and rows8m
-
3. Undo and Redo4m
-
4. File Management tips4m
-
5. Adjusting row height and column width5m
-
6. Hiding columns and rows4m
-
7. Selecting multiple ranges4m
Level 2, Section 3: Customise options and views for worksheets and workbooks
-
1. Hiding worksheets4m
-
2. Customising the Quick Access toolbar3m
-
3. Customising the Ribbon5m
-
4. Assigning shortcut keys3m
-
5. Recording simple macros5m
-
6. Managing macro security8m
-
7. Changing workbook views4m
-
8. Using zoom3m
-
9. Adding values to workbook properties5m
-
10. Displaying formulas3m
-
11. Freezing panes5m
-
12. Splitting the window3m
Level 2, Section 4: Configure Excel worksheets and workbooks to print
-
1. Printing individual worksheets3m
-
2. Printing an entire workbook and printing a selection2m
-
3. Setting a print area4m
-
4. Page setup, Part 1 (first two tabs)6m
-
5. Page setup, Part 2 (Repeating headers and footers)3m
-
6. Adding dynamic text to headers and footers3m
-
7. Inserting watermarks3m
-
8. Page setup, Part 3 (Headings etc.)7m
-
9. Configuring workbooks to print3m
-
10. Inspecting your workbook prior to distribution4m
Level 2, Section 5: Utilise cell ranges and references in formulas and functions
-
1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)9m
-
2. Practice Activity - multiplication table3m
-
3. Answer - multiplication table3m
Level 3, Section 1: Insert data in cells and ranges
-
1. Appending data to Excel worksheets3m
-
2. Setting data validation11m
-
3. Finding and replacing data7m
-
4. Copying and pasting data, including Paste Special5m
-
5. Cutting and moving cell data3m
-
6. Using AutoFill tool, and Expanding data across columns5m
Level 3, Section 2: Format cells and ranges
-
1. Modifying cell alignment and indentation5m
-
2. Wrapping text within cells5m
-
3. Merging cells and Shrink to Fit7m
-
4. Changing font and font styles4m
-
5. Applying highlighting2m
-
6. Applying Number format8m
-
7. Applying borders6m
-
8. Applying cell styles3m
-
9. Using Format Painter3m
-
10. Changing text to WordArt2m
Level 3, Section 3: Highlight and filter cells and ranges in Excel
-
1. Applying conditional formatting - highlighting12m
-
2. Applying conditional formatting - Bars, Scales and Sets10m
-
3. Transposing columns and rows, and #####s3m
-
4. Inserting sparklines, and how to define a range5m
-
5. Customising Sparklines7m
Level 3, Section 4: Summarise data with Excel functions
-
1. Doing calculations without formulas3m
-
2. Utilising the SUM function5m
-
3. Formula syntax - SUM function7m
-
4. Utilising the COUNT function7m
-
5. Utilising the AVERAGE and other averaging functions8m
-
6. Utilising the MIN and MAX functions3m
-
7. Creating named ranges8m
-
8. Getting help with functions3m
Level 4, Section 1: Create a table
-
1. Moving between tables and ranges5m
-
2. Adding and removing cells within tables4m
-
3. Formulas in tables6m
-
4. Defining titles4m
Level 4, Section 2: Modify a table
-
1. Inserting total rows4m
-
2. Adding and removing styles and Banding rows and columns6m
Level 4, Section 3: Filtering, Sorting and Grouping
-
1. Setting up a filter and Filtering records6m
-
2. More advanced filtering options12m
-
3. Using sort options5m
-
4. Sorting data on multiple columns; changing sort order4m
-
5. Removing duplicates4m
-
6. Inserting subtotals4m
-
7. Creating outlines; collapsing groups of data in outlines6m
-
8. Utilising the SUBTOTAL function7m
Level 4, Section 4: Utilise conditional logic in functions
-
1. Utilising the IF function8m
-
2. Utilising the SUMIF function6m
-
3. Utilising the COUNTIF function4m
-
4. Utilising the AVERAGEIF function4m
-
5. Nested IFs and Evaluate Formulas6m
-
6. The CHOOSE function3m
Level 5, Section 1: Create a chart in Excel
-
1. Creating charts and graphs6m
-
2. Adding and removing additional data series4m
-
3. Exploring the Column charts6m
-
4. Line, bar and area charts4m
-
5. Pie charts3m
-
6. Other graph types8m
-
7. Switching between rows and columns in source data3m
Level 5, Section 2: Format a chart in Excel
-
1. Adding legends7m
-
2. Positioning and Resizing charts and graphs, inc5m
-
3. Modifying chart and graph parameters - Excel 2007 and 20106m
-
4. Modifying chart and graph parameters - Excel 2013 and 20166m
-
5. Applying chart layouts and styles4m
Level 5, Section 3: Insert and format an object
-
1. Inserting text boxes and positioning objects4m
-
2. Inserting SmartArt5m
-
3. Inserting ClipArt and images3m
-
4. Inserting Screenshots3m
-
5. Adding borders to objects5m
-
6. Inserting shapes5m
-
7. Adding styles and effects to objects4m
-
8. Changing workbook themes4m
-
9. Modifying object properties, including adding alternate text5m
Level 5, Section 4: create and modify images by using the Image Editor
-
1. Making corrections to an image3m
-
2. Using picture colour tools2m
-
3. Send to front and back, and transparent colour2m
-
4. Changing artistic effects on an image3m
-
5. Crop picture4m
Level 5, Section 5: Format and modify text with functions
-
1. Utilising the CONCATENATE function5m
-
2. Utilising the RIGHT, LEFT and MID functions7m
-
3. Utilising the TRIM function3m
-
4. Utilising the UPPER and LOWER functions3m
