77-420: Excel 2013

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.

$13.74 / $24.99

Level 1, Section 1 - An introduction to Excel

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

Level 1, Section 2 - Create worksheets and workbooks

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

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

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

Level 1, Section 4: Basic formulas

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

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

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

Level 2, Section 2: Format worksheets and workbooks

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

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

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

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

  • 1. Printing individual worksheets
    3m
  • 2. Printing an entire workbook and printing a selection
    2m
  • 3. Setting a print area
    4m
  • 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 footers
    3m
  • 7. Inserting watermarks
    3m
  • 8. Page setup, Part 3 (Headings etc.)
    7m
  • 9. Configuring workbooks to print
    3m
  • 10. Inspecting your workbook prior to distribution
    4m

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 table
    3m
  • 3. Answer - multiplication table
    3m

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

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

Level 3, Section 2: Format cells and ranges

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

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

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

Level 3, Section 4: Summarise data with Excel functions

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

Level 4, Section 1: Create a table

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

Level 4, Section 2: Modify a table

  • 1. Inserting total rows
    4m
  • 2. Adding and removing styles and Banding rows and columns
    6m

Level 4, Section 3: Filtering, Sorting and Grouping

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

Level 4, Section 4: Utilise conditional logic in functions

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

Level 5, Section 1: Create a chart in Excel

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

Level 5, Section 2: Format a chart in Excel

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

Level 5, Section 3: Insert and format an object

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

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

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

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

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