Training Video Course

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.49rating
Students
91
Duration
11:09:00 h
$16.49
$14.99

Curriculum for 77-420 Video Course

Name of Video Time
Play Video: Creating new blank workbooks
1. Creating new blank workbooks
4:00
Play Video: Entering data
2. Entering data
9:00
Play Video: An introduction to fonts and highlighting
3. An introduction to fonts and highlighting
4:00
Play Video: Saving and closing your workbook
4. Saving and closing your workbook
5:00
Play Video: Practice Activity Number 1 - The Solution
5. Practice Activity Number 1 - The Solution
2:00
Name of Video Time
Play Video: Creating new workbooks using templates
1. Creating new workbooks using templates
6:00
Play Video: Menus and toolbars
2. Menus and toolbars
7:00
Play Video: Managing multiple workbooks - Excel 2013 and 2016
3. Managing multiple workbooks - Excel 2013 and 2016
4:00
Play Video: Managing multiple workbooks - Excel 2007 and 2010
4. Managing multiple workbooks - Excel 2007 and 2010
7:00
Play Video: Importing files and Opening non-native files directly in Excel
5. Importing files and Opening non-native files directly in Excel
8:00
Play Video: Adding worksheets to existing workbooks
6. Adding worksheets to existing workbooks
4:00
Play Video: Copying and moving worksheets, and changing spreadsheet order
7. Copying and moving worksheets, and changing spreadsheet order
5:00
Name of Video Time
Play Video: Saving workbooks in alternate file formats
1. Saving workbooks in alternate file formats
7:00
Play Video: Maintaining backward compatibility
2. Maintaining backward compatibility
6:00
Play Video: Saving files to remote locations
3. Saving files to remote locations
3:00
Name of Video Time
Play Video: Using basic operators
1. Using basic operators
6:00
Play Video: Order of operations
2. Order of operations
6:00
Play Video: How to enter numbers and dates in Excel
3. How to enter numbers and dates in Excel
3:00
Play Video: Referencing cell ranges in formulas
4. Referencing cell ranges in formulas
10:00
Play Video: Practice Activity Number 2 - Solution
5. Practice Activity Number 2 - Solution
6:00
Name of Video Time
Play Video: Searching for data within a workbook
1. Searching for data within a workbook
5:00
Play Video: Hyperlinks
2. Hyperlinks
5:00
Play Video: Using Go To and Using Name Box
3. Using Go To and Using Name Box
5:00
Play Video: Hot Keys
4. Hot Keys
4:00
Name of Video Time
Play Video: Changing worksheet tab colour
1. Changing worksheet tab colour
5:00
Play Video: Inserting and deleting columns and rows
2. Inserting and deleting columns and rows
8:00
Play Video: Undo and Redo
3. Undo and Redo
4:00
Play Video: File Management tips
4. File Management tips
4:00
Play Video: Adjusting row height and column width
5. Adjusting row height and column width
5:00
Play Video: Hiding columns and rows
6. Hiding columns and rows
4:00
Play Video: Selecting multiple ranges
7. Selecting multiple ranges
4:00
Name of Video Time
Play Video: Hiding worksheets
1. Hiding worksheets
4:00
Play Video: Customising the Quick Access toolbar
2. Customising the Quick Access toolbar
3:00
Play Video: Customising the Ribbon
3. Customising the Ribbon
5:00
Play Video: Assigning shortcut keys
4. Assigning shortcut keys
3:00
Play Video: Recording simple macros
5. Recording simple macros
5:00
Play Video: Managing macro security
6. Managing macro security
8:00
Play Video: Changing workbook views
7. Changing workbook views
4:00
Play Video: Using zoom
8. Using zoom
3:00
Play Video: Adding values to workbook properties
9. Adding values to workbook properties
5:00
Play Video: Displaying formulas
10. Displaying formulas
3:00
Play Video: Freezing panes
11. Freezing panes
5:00
Play Video: Splitting the window
12. Splitting the window
3:00
Name of Video Time
Play Video: Printing individual worksheets
1. Printing individual worksheets
3:00
Play Video: Printing an entire workbook and printing a selection
2. Printing an entire workbook and printing a selection
2:00
Play Video: Setting a print area
3. Setting a print area
4:00
Play Video: Page setup, Part 1 (first two tabs)
4. Page setup, Part 1 (first two tabs)
6:00
Play Video: Page setup, Part 2 (Repeating headers and footers)
5. Page setup, Part 2 (Repeating headers and footers)
3:00
Play Video: Adding dynamic text to headers and footers
6. Adding dynamic text to headers and footers
3:00
Play Video: Inserting watermarks
7. Inserting watermarks
3:00
Play Video: Page setup, Part 3 (Headings etc.)
8. Page setup, Part 3 (Headings etc.)
7:00
Play Video: Configuring workbooks to print
9. Configuring workbooks to print
3:00
Play Video: Inspecting your workbook prior to distribution
10. Inspecting your workbook prior to distribution
4:00
Name of Video Time
Play Video: Copying and pasting basics, and Utilising references (relative, mixed, absolute)
1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)
9:00
Play Video: Practice Activity - multiplication table
2. Practice Activity - multiplication table
3:00
Play Video: Answer - multiplication table
3. Answer - multiplication table
3:00
Name of Video Time
Play Video: Appending data to Excel worksheets
1. Appending data to Excel worksheets
3:00
Play Video: Setting data validation
2. Setting data validation
11:00
Play Video: Finding and replacing data
3. Finding and replacing data
7:00
Play Video: Copying and pasting data, including Paste Special
4. Copying and pasting data, including Paste Special
5:00
Play Video: Cutting and moving cell data
5. Cutting and moving cell data
3:00
Play Video: Using AutoFill tool, and Expanding data across columns
6. Using AutoFill tool, and Expanding data across columns
5:00
Name of Video Time
Play Video: Modifying cell alignment and indentation
1. Modifying cell alignment and indentation
5:00
Play Video: Wrapping text within cells
2. Wrapping text within cells
5:00
Play Video: Merging cells and Shrink to Fit
3. Merging cells and Shrink to Fit
7:00
Play Video: Changing font and font styles
4. Changing font and font styles
4:00
Play Video: Applying highlighting
5. Applying highlighting
2:00
Play Video: Applying Number format
6. Applying Number format
8:00
Play Video: Applying borders
7. Applying borders
6:00
Play Video: Applying cell styles
8. Applying cell styles
3:00
Play Video: Using Format Painter
9. Using Format Painter
3:00
Play Video: Changing text to WordArt
10. Changing text to WordArt
2:00
Name of Video Time
Play Video: Applying conditional formatting - highlighting
1. Applying conditional formatting - highlighting
12:00
Play Video: Applying conditional formatting - Bars, Scales and Sets
2. Applying conditional formatting - Bars, Scales and Sets
10:00
Play Video: Transposing columns and rows, and #####s
3. Transposing columns and rows, and #####s
3:00
Play Video: Inserting sparklines, and how to define a range
4. Inserting sparklines, and how to define a range
5:00
Play Video: Customising Sparklines
5. Customising Sparklines
7:00
Name of Video Time
Play Video: Doing calculations without formulas
1. Doing calculations without formulas
3:00
Play Video: Utilising the SUM function
2. Utilising the SUM function
5:00
Play Video: Formula syntax - SUM function
3. Formula syntax - SUM function
7:00
Play Video: Utilising the COUNT function
4. Utilising the COUNT function
7:00
Play Video: Utilising the AVERAGE and other averaging functions
5. Utilising the AVERAGE and other averaging functions
8:00
Play Video: Utilising the MIN and MAX functions
6. Utilising the MIN and MAX functions
3:00
Play Video: Creating named ranges
7. Creating named ranges
8:00
Play Video: Getting help with functions
8. Getting help with functions
3:00
Name of Video Time
Play Video: Moving between tables and ranges
1. Moving between tables and ranges
5:00
Play Video: Adding and removing cells within tables
2. Adding and removing cells within tables
4:00
Play Video: Formulas in tables
3. Formulas in tables
6:00
Play Video: Defining titles
4. Defining titles
4:00
Name of Video Time
Play Video: Inserting total rows
1. Inserting total rows
4:00
Play Video: Adding and removing styles and Banding rows and columns
2. Adding and removing styles and Banding rows and columns
6:00
Name of Video Time
Play Video: Setting up a filter and Filtering records
1. Setting up a filter and Filtering records
6:00
Play Video: More advanced filtering options
2. More advanced filtering options
12:00
Play Video: Using sort options
3. Using sort options
5:00
Play Video: Sorting data on multiple columns; changing sort order
4. Sorting data on multiple columns; changing sort order
4:00
Play Video: Removing duplicates
5. Removing duplicates
4:00
Play Video: Inserting subtotals
6. Inserting subtotals
4:00
Play Video: Creating outlines; collapsing groups of data in outlines
7. Creating outlines; collapsing groups of data in outlines
6:00
Play Video: Utilising the SUBTOTAL function
8. Utilising the SUBTOTAL function
7:00
Name of Video Time
Play Video: Utilising the IF function
1. Utilising the IF function
8:00
Play Video: Utilising the SUMIF function
2. Utilising the SUMIF function
6:00
Play Video: Utilising the COUNTIF function
3. Utilising the COUNTIF function
4:00
Play Video: Utilising the AVERAGEIF function
4. Utilising the AVERAGEIF function
4:00
Play Video: Nested IFs and Evaluate Formulas
5. Nested IFs and Evaluate Formulas
6:00
Play Video: The CHOOSE function
6. The CHOOSE function
3:00
Name of Video Time
Play Video: Creating charts and graphs
1. Creating charts and graphs
6:00
Play Video: Adding and removing additional data series
2. Adding and removing additional data series
4:00
Play Video: Exploring the Column charts
3. Exploring the Column charts
6:00
Play Video: Line, bar and area charts
4. Line, bar and area charts
4:00
Play Video: Pie charts
5. Pie charts
3:00
Play Video: Other graph types
6. Other graph types
8:00
Play Video: Switching between rows and columns in source data
7. Switching between rows and columns in source data
3:00
Name of Video Time
Play Video: Adding legends
1. Adding legends
7:00
Play Video: Positioning and Resizing charts and graphs, inc. moving charts into chart sheets
2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets
5:00
Play Video: Modifying chart and graph parameters - Excel 2007 and 2010
3. Modifying chart and graph parameters - Excel 2007 and 2010
6:00
Play Video: Modifying chart and graph parameters - Excel 2013 and 2016
4. Modifying chart and graph parameters - Excel 2013 and 2016
6:00
Play Video: Applying chart layouts and styles
5. Applying chart layouts and styles
4:00
Name of Video Time
Play Video: Inserting text boxes and positioning objects
1. Inserting text boxes and positioning objects
4:00
Play Video: Inserting SmartArt
2. Inserting SmartArt
5:00
Play Video: Inserting ClipArt and images
3. Inserting ClipArt and images
3:00
Play Video: Inserting Screenshots
4. Inserting Screenshots
3:00
Play Video: Adding borders to objects
5. Adding borders to objects
5:00
Play Video: Inserting shapes
6. Inserting shapes
5:00
Play Video: Adding styles and effects to objects
7. Adding styles and effects to objects
4:00
Play Video: Changing workbook themes
8. Changing workbook themes
4:00
Play Video: Modifying object properties, including adding alternate text
9. Modifying object properties, including adding alternate text
5:00
Name of Video Time
Play Video: Making corrections to an image
1. Making corrections to an image
3:00
Play Video: Using picture colour tools
2. Using picture colour tools
2:00
Play Video: Send to front and back, and transparent colour
3. Send to front and back, and transparent colour
2:00
Play Video: Changing artistic effects on an image
4. Changing artistic effects on an image
3:00
Play Video: Crop picture
5. Crop picture
4:00
Name of Video Time
Play Video: Utilising the CONCATENATE function
1. Utilising the CONCATENATE function
5:00
Play Video: Utilising the RIGHT, LEFT and MID functions
2. Utilising the RIGHT, LEFT and MID functions
7:00
Play Video: Utilising the TRIM function
3. Utilising the TRIM function
3:00
Play Video: Utilising the UPPER and LOWER functions
4. Utilising the UPPER and LOWER functions
3:00

Download Microsoft Excel 77-420 Exam Questions & Answers

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

Microsoft 77-420 Premium Bundle
$69.97
$49.99

77-420 Premium Bundle

  • Premium File: 30 Questions & Answers. Last update: Sep 20, 2021
  • Training Course: 135 Video Lectures
  • Study Guide: 473 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
Get Unlimited Access to ALL Premium Files

77-420 Premium Bundle

Microsoft 77-420 Premium Bundle
  • Premium File: 30 Questions & Answers. Last update: Sep 20, 2021
  • Training Course: 135 Video Lectures
  • Study Guide: 473 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$69.97
$49.99
Get Unlimited Access to ALL Premium Files

Free 77-420 Exam Questions & 77-420 Dumps

File Name Size Votes
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

Comments (0)

Add Comment

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.

Add Comment

Purchase Individually

77-420  Premium File
77-420
Premium File
30 Q&A
$43.99 $39.99
77-420  Training Course
77-420
Training Course
30 Lectures
$16.49 $14.99
77-420  Study Guide
77-420
Study Guide
30 Pages
$16.49 $14.99

Microsoft Training Courses

Technology Literacy for Educators Training Course
62-193
Technology Literacy for Educators
$14.99
Excel 2013 Training Course
77-420
Excel 2013
$14.99
Excel 2016: Core Data Analysis, Manipulation, and Presentation Training Course
77-727
Excel 2016: Core Data Analysis, Manipulation, and Presentation
$14.99
SharePoint 2010 Training Course
77-886
SharePoint 2010
$14.99
Windows Operating System Fundamentals Training Course
98-349
Windows Operating System Fundamentals
$14.99
Software Development Fundamentals Training Course
98-361
Software Development Fundamentals
$14.99
Database Fundamentals Training Course
98-364
Database Fundamentals
$14.99
Windows Server Administration Fundamentals Training Course
98-365
Windows Server Administration Fundamentals
$14.99
Networking Fundamentals Training Course
98-366
Networking Fundamentals
$14.99
Security Fundamentals Training Course
98-367
Security Fundamentals
$14.99
Introduction to Programming Using Python Training Course
98-381
Introduction to Programming Using Python
$14.99
Microsoft Azure AI Fundamentals Training Course
AI-900
Microsoft Azure AI Fundamentals
$14.99
Microsoft Azure Administrator Training Course
AZ-104
Microsoft Azure Administrator
$14.99
Configuring and Operating Windows Virtual Desktop on Microsoft Azure Training Course
AZ-140
Configuring and Operating Windows Virtual Desktop on Microsoft Azure
$14.99
Developing Solutions for Microsoft Azure Training Course
AZ-204
Developing Solutions for Microsoft Azure
$14.99
Microsoft Azure Architect Technologies Training Course
AZ-303
Microsoft Azure Architect Technologies
$14.99
Microsoft Azure Architect Design Training Course
AZ-304
Microsoft Azure Architect Design
$14.99
Microsoft Azure DevOps Solutions Training Course
AZ-400
Microsoft Azure DevOps Solutions
$14.99
Microsoft Azure Security Technologies Training Course
AZ-500
Microsoft Azure Security Technologies
$14.99
Microsoft Azure Fundamentals Training Course
AZ-900
Microsoft Azure Fundamentals
$14.99
Analyzing Data with Microsoft Power BI Training Course
DA-100
Analyzing Data with Microsoft Power BI
$14.99
Designing and Implementing a Data Science Solution on Azure Training Course
DP-100
Designing and Implementing a Data Science Solution on Azure
$14.99
Data Engineering on Microsoft Azure Training Course
DP-203
Data Engineering on Microsoft Azure
$14.99
Microsoft Azure Data Fundamentals Training Course
DP-900
Microsoft Azure Data Fundamentals
$14.99
Microsoft Dynamics 365 for Sales Training Course
MB-210
Microsoft Dynamics 365 for Sales
$14.99
Microsoft Dynamics 365 for Customer Service Training Course
MB-230
Microsoft Dynamics 365 for Customer Service
$14.99
Microsoft Dynamics 365 for Field Service Training Course
MB-240
Microsoft Dynamics 365 for Field Service
$14.99
Microsoft Dynamics 365: Core Finance and Operations Training Course
MB-300
Microsoft Dynamics 365: Core Finance and Operations
$14.99
Microsoft Dynamics 365 Finance Training Course
MB-310
Microsoft Dynamics 365 Finance
$14.99
Microsoft Dynamics CRM 2016 Customization and Configuration Training Course
MB2-712
Microsoft Dynamics CRM 2016 Customization and Configuration
$14.99
Windows 10 Training Course
MD-100
Windows 10
$14.99
Managing Modern Desktops Training Course
MD-101
Managing Modern Desktops
$14.99
Microsoft Excel (Excel and Excel 2019) Training Course
MO-200
Microsoft Excel (Excel and Excel 2019)
$14.99
Microsoft 365 Identity and Services Training Course
MS-100
Microsoft 365 Identity and Services
$14.99
Microsoft 365 Mobility and Security Training Course
MS-101
Microsoft 365 Mobility and Security
$14.99
Microsoft 365 Messaging Training Course
MS-203
Microsoft 365 Messaging
$14.99
Microsoft 365 Security Administration Training Course
MS-500
Microsoft 365 Security Administration
$14.99
Managing Microsoft Teams Training Course
MS-700
Managing Microsoft Teams
$14.99
Microsoft 365 Fundamentals Training Course
MS-900
Microsoft 365 Fundamentals
$14.99
Microsoft Power Platform App Maker Training Course
PL-100
Microsoft Power Platform App Maker
$14.99
Microsoft Power Platform Functional Consultant Training Course
PL-200
Microsoft Power Platform Functional Consultant
$14.99
Microsoft Power Platform Fundamentals Training Course
PL-900
Microsoft Power Platform Fundamentals
$14.99
Microsoft Security, Compliance, and Identity Fundamentals Training Course
SC-900
Microsoft Security, Compliance, and Identity Fundamentals
$14.99

Microsoft Certifications

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.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

UP

LIMITED OFFER: GET 30% Discount

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 30% Discount Code

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.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.