77-420: Excel 2013 Exam – Complete Certification Training Course & Exam Dumps

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.

109 Students Enrolled 135 Lectures 11:09:00 Hours

Curriculum For This Course

Level 1, Section 1 - An introduction to Excel

5Lectures

Time 00:24:00

Level 1, Section 2 - Create worksheets and workbooks

7Lectures

Time 00:41:00

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

3Lectures

Time 00:16:00

Level 1, Section 4: Basic formulas

5Lectures

Time 00:31:00

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

4Lectures

Time 00:19:00

Level 2, Section 2: Format worksheets and workbooks

7Lectures

Time 00:34:00

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

12Lectures

Time 00:51:00

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

10Lectures

Time 00:38:00

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

3Lectures

Time 00:15:00

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

6Lectures

Time 00:34:00

Level 3, Section 2: Format cells and ranges

10Lectures

Time 00:45:00

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

5Lectures

Time 00:37:00

Level 3, Section 4: Summarise data with Excel functions

8Lectures

Time 00:44:00

Level 4, Section 1: Create a table

4Lectures

Time 00:19:00

Level 4, Section 2: Modify a table

2Lectures

Time 00:10:00

Level 4, Section 3: Filtering, Sorting and Grouping

8Lectures

Time 00:48:00

Level 4, Section 4: Utilise conditional logic in functions

6Lectures

Time 00:31:00

Level 5, Section 1: Create a chart in Excel

7Lectures

Time 00:34:00

Level 5, Section 2: Format a chart in Excel

5Lectures

Time 00:28:00

Level 5, Section 3: Insert and format an object

9Lectures

Time 00:38:00

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

5Lectures

Time 00:14:00

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

4Lectures

Time 00:18:00

Level 1, Section 1 - An introduction to Excel
	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

Level 1, Section 2 - Create worksheets and workbooks
	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

Level 1, Section 3: Configure worksheets and workbooks to save
	1. Saving workbooks in alternate file formats	7:00
	2. Maintaining backward compatibility	6:00
	3. Saving files to remote locations	3:00

Level 1, Section 4: Basic formulas
	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

Level 2, Section 1: Navigate through Excel worksheets and workbooks
	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

Level 2, Section 2: Format worksheets and workbooks
	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

Level 2, Section 3: Customise options and views for worksheets and workbooks
	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

Level 2, Section 4: Configure Excel worksheets and workbooks to print
	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

Level 2, Section 5: Utilise cell ranges and references in formulas and functions
	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

Level 3, Section 1: Insert data in cells and ranges
	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

Level 3, Section 2: Format cells and ranges
	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

Level 3, Section 3: Highlight and filter cells and ranges in Excel
	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

Level 3, Section 4: Summarise data with Excel functions
	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

Level 4, Section 1: Create a table
	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

Level 4, Section 2: Modify a table
	1. Inserting total rows	4:00
	2. Adding and removing styles and Banding rows and columns	6:00

Level 4, Section 3: Filtering, Sorting and Grouping
	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

Level 4, Section 4: Utilise conditional logic in functions
	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

Level 5, Section 1: Create a chart in Excel
	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

Level 5, Section 2: Format a chart in Excel
	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

Level 5, Section 3: Insert and format an object
	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

Level 5, Section 4: create and modify images by using the Image Editor
	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

Level 5, Section 5: Format and modify text with functions
	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