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.
Curriculum for 77-420 Certification Video Course
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 |
100% Latest & Updated Microsoft Excel 77-420 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
77-420 Premium Bundle
Free 77-420 Exam Questions & 77-420 Dumps
File Name | Size | Votes |
---|---|---|
File Name microsoft.examlabs.77-420.v2022-05-01.by.leonardo.12q.vce |
Size 2.37 MB |
Votes 1 |
File Name microsoft.selftestengine.77-420.v2021-06-16.by.tamar.12q.vce |
Size 2.37 MB |
Votes 1 |
File Name microsoft.selftestengine.77-420.v2021-05-04.by.arthur.12q.vce |
Size 2.37 MB |
Votes 2 |
Microsoft 77-420 Training Course
Want verified and proven knowledge for Excel 2013? Believe it's easy when you have ExamSnap's Excel 2013 certification video training course by your side which along with our Microsoft 77-420 Exam Dumps & Practice Test questions provide a complete solution to pass your exam Read More.
Prepared by Top Experts, the top IT Trainers ensure that when it comes to your IT exam prep and you can count on ExamSnap Excel 2013 certification video training course that goes in line with the corresponding Microsoft 77-420 exam dumps, study guide, and practice test questions & answers.
Comments (0)
Please post your comments about 77-420 Exams. Don't share your email address asking for 77-420 braindumps or 77-420 exam pdf files.
Purchase Individually
Microsoft Training Courses
Only Registered Members can View Training Courses
Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.
LIMITED OFFER: GET 30% Discount
This is ONE TIME OFFER
A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.
Download Free Demo of VCE Exam Simulator
Experience Avanset VCE Exam Simulator for yourself.
Simply submit your e-mail address below to get started with our interactive software demo of your free trial.