Practice Exams:

View All

77-420: Excel 2013

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The 77-420 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft 77-420 test with flying colors.

Rating

4.49

Students

Duration

11:09:00 h

$16.49

$14.99

Curriculum for 77-420 Video Course

Level 1, Section 1 - An introduction to Excel

5 Lectures

Time 00:24:00

Level 1, Section 2 - Create worksheets and workbooks

7 Lectures

Time 00:41:00

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

3 Lectures

Time 00:16:00

Level 1, Section 4: Basic formulas

5 Lectures

Time 00:31:00

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

4 Lectures

Time 00:19:00

Level 2, Section 2: Format worksheets and workbooks

7 Lectures

Time 00:34:00

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

12 Lectures

Time 00:51:00

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

10 Lectures

Time 00:38:00

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

3 Lectures

Time 00:15:00

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

6 Lectures

Time 00:34:00

Level 3, Section 2: Format cells and ranges

10 Lectures

Time 00:45:00

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

5 Lectures

Time 00:37:00

Level 3, Section 4: Summarise data with Excel functions

8 Lectures

Time 00:44:00

Level 4, Section 1: Create a table

4 Lectures

Time 00:19:00

Level 4, Section 2: Modify a table

2 Lectures

Time 00:10:00

Level 4, Section 3: Filtering, Sorting and Grouping

8 Lectures

Time 00:48:00

Level 4, Section 4: Utilise conditional logic in functions

6 Lectures

Time 00:31:00

Level 5, Section 1: Create a chart in Excel

7 Lectures

Time 00:34:00

Level 5, Section 2: Format a chart in Excel

5 Lectures

Time 00:28:00

Level 5, Section 3: Insert and format an object

9 Lectures

Time 00:38:00

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

5 Lectures

Time 00:14:00

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

4 Lectures

Time 00:18:00

Name of Video	Time
1. Creating new blank workbooks	4:00
2. Entering data	9:00
3. An introduction to fonts and highlighting	4:00
4. Saving and closing your workbook	5:00
5. Practice Activity Number 1 - The Solution	2:00

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

Name of Video	Time
1. Saving workbooks in alternate file formats	7:00
2. Maintaining backward compatibility	6:00
3. Saving files to remote locations	3:00

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

Name of Video	Time
1. Searching for data within a workbook	5:00
2. Hyperlinks	5:00
3. Using Go To and Using Name Box	5:00
4. Hot Keys	4:00

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

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

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

Name of Video	Time
1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)	9:00
2. Practice Activity - multiplication table	3:00
3. Answer - multiplication table	3:00

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

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

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

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

Name of Video	Time
1. Moving between tables and ranges	5:00
2. Adding and removing cells within tables	4:00
3. Formulas in tables	6:00
4. Defining titles	4:00

Name of Video	Time
1. Inserting total rows	4:00
2. Adding and removing styles and Banding rows and columns	6:00

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

Name of Video	Time
1. Utilising the IF function	8:00
2. Utilising the SUMIF function	6:00
3. Utilising the COUNTIF function	4:00
4. Utilising the AVERAGEIF function	4:00
5. Nested IFs and Evaluate Formulas	6:00
6. The CHOOSE function	3:00

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

Name of Video	Time
1. Adding legends	7:00
2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets	5:00
3. Modifying chart and graph parameters - Excel 2007 and 2010	6:00
4. Modifying chart and graph parameters - Excel 2013 and 2016	6:00
5. Applying chart layouts and styles	4:00

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

Name of Video	Time
1. Making corrections to an image	3:00
2. Using picture colour tools	2:00
3. Send to front and back, and transparent colour	2:00
4. Changing artistic effects on an image	3:00
5. Crop picture	4:00

Name of Video	Time
1. Utilising the CONCATENATE function	5:00
2. Utilising the RIGHT, LEFT and MID functions	7:00
3. Utilising the TRIM function	3:00
4. Utilising the UPPER and LOWER functions	3:00