77-420: Excel 2013 Certification Video Training Course
The complete solution to prepare for for your exam with 77-420: Excel 2013 certification video training course. The 77-420: Excel 2013 certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft Excel 77-420 exam dumps, study guide & practice test questions and answers.
77-420: Excel 2013 Certification Video Training Course Exam Curriculum
Level 1, Section 1 - An introduction to Excel
-
1. Creating new blank workbooks4:00
-
2. Entering data9:00
-
3. An introduction to fonts and highlighting4:00
-
4. Saving and closing your workbook5:00
-
5. Practice Activity Number 1 - The Solution2:00
Level 1, Section 2 - Create worksheets and workbooks
-
1. Creating new workbooks using templates6:00
-
2. Menus and toolbars7:00
-
3. Managing multiple workbooks - Excel 2013 and 20164:00
-
4. Managing multiple workbooks - Excel 2007 and 20107:00
-
5. Importing files and Opening non-native files directly in Excel8:00
-
6. Adding worksheets to existing workbooks4:00
-
7. Copying and moving worksheets, and changing spreadsheet order5:00
Level 1, Section 3: Configure worksheets and workbooks to save
-
1. Saving workbooks in alternate file formats7:00
-
2. Maintaining backward compatibility6:00
-
3. Saving files to remote locations3:00
Level 1, Section 4: Basic formulas
-
1. Using basic operators6:00
-
2. Order of operations6:00
-
3. How to enter numbers and dates in Excel3:00
-
4. Referencing cell ranges in formulas10:00
-
5. Practice Activity Number 2 - Solution6:00
Level 2, Section 1: Navigate through Excel worksheets and workbooks
-
1. Searching for data within a workbook5:00
-
2. Hyperlinks5:00
-
3. Using Go To and Using Name Box5:00
-
4. Hot Keys4:00
Level 2, Section 2: Format worksheets and workbooks
-
1. Changing worksheet tab colour5:00
-
2. Inserting and deleting columns and rows8:00
-
3. Undo and Redo4:00
-
4. File Management tips4:00
-
5. Adjusting row height and column width5:00
-
6. Hiding columns and rows4:00
-
7. Selecting multiple ranges4:00
Level 2, Section 3: Customise options and views for worksheets and workbooks
-
1. Hiding worksheets4:00
-
2. Customising the Quick Access toolbar3:00
-
3. Customising the Ribbon5:00
-
4. Assigning shortcut keys3:00
-
5. Recording simple macros5:00
-
6. Managing macro security8:00
-
7. Changing workbook views4:00
-
8. Using zoom3:00
-
9. Adding values to workbook properties5:00
-
10. Displaying formulas3:00
-
11. Freezing panes5:00
-
12. Splitting the window3:00
Level 2, Section 4: Configure Excel worksheets and workbooks to print
-
1. Printing individual worksheets3:00
-
2. Printing an entire workbook and printing a selection2:00
-
3. Setting a print area4: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 footers3:00
-
7. Inserting watermarks3:00
-
8. Page setup, Part 3 (Headings etc.)7:00
-
9. Configuring workbooks to print3:00
-
10. Inspecting your workbook prior to distribution4: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 table3:00
-
3. Answer - multiplication table3:00
Level 3, Section 1: Insert data in cells and ranges
-
1. Appending data to Excel worksheets3:00
-
2. Setting data validation11:00
-
3. Finding and replacing data7:00
-
4. Copying and pasting data, including Paste Special5:00
-
5. Cutting and moving cell data3:00
-
6. Using AutoFill tool, and Expanding data across columns5:00
Level 3, Section 2: Format cells and ranges
-
1. Modifying cell alignment and indentation5:00
-
2. Wrapping text within cells5:00
-
3. Merging cells and Shrink to Fit7:00
-
4. Changing font and font styles4:00
-
5. Applying highlighting2:00
-
6. Applying Number format8:00
-
7. Applying borders6:00
-
8. Applying cell styles3:00
-
9. Using Format Painter3:00
-
10. Changing text to WordArt2:00
Level 3, Section 3: Highlight and filter cells and ranges in Excel
-
1. Applying conditional formatting - highlighting12:00
-
2. Applying conditional formatting - Bars, Scales and Sets10:00
-
3. Transposing columns and rows, and #####s3:00
-
4. Inserting sparklines, and how to define a range5:00
-
5. Customising Sparklines7:00
Level 3, Section 4: Summarise data with Excel functions
-
1. Doing calculations without formulas3:00
-
2. Utilising the SUM function5:00
-
3. Formula syntax - SUM function7:00
-
4. Utilising the COUNT function7:00
-
5. Utilising the AVERAGE and other averaging functions8:00
-
6. Utilising the MIN and MAX functions3:00
-
7. Creating named ranges8:00
-
8. Getting help with functions3:00
Level 4, Section 1: Create a table
-
1. Moving between tables and ranges5:00
-
2. Adding and removing cells within tables4:00
-
3. Formulas in tables6:00
-
4. Defining titles4:00
Level 4, Section 2: Modify a table
-
1. Inserting total rows4:00
-
2. Adding and removing styles and Banding rows and columns6:00
Level 4, Section 3: Filtering, Sorting and Grouping
-
1. Setting up a filter and Filtering records6:00
-
2. More advanced filtering options12:00
-
3. Using sort options5:00
-
4. Sorting data on multiple columns; changing sort order4:00
-
5. Removing duplicates4:00
-
6. Inserting subtotals4:00
-
7. Creating outlines; collapsing groups of data in outlines6:00
-
8. Utilising the SUBTOTAL function7:00
Level 4, Section 4: Utilise conditional logic in functions
-
1. Utilising the IF function8:00
-
2. Utilising the SUMIF function6:00
-
3. Utilising the COUNTIF function4:00
-
4. Utilising the AVERAGEIF function4:00
-
5. Nested IFs and Evaluate Formulas6:00
-
6. The CHOOSE function3:00
Level 5, Section 1: Create a chart in Excel
-
1. Creating charts and graphs6:00
-
2. Adding and removing additional data series4:00
-
3. Exploring the Column charts6:00
-
4. Line, bar and area charts4:00
-
5. Pie charts3:00
-
6. Other graph types8:00
-
7. Switching between rows and columns in source data3:00
Level 5, Section 2: Format a chart in Excel
-
1. Adding legends7:00
-
2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets5:00
-
3. Modifying chart and graph parameters - Excel 2007 and 20106:00
-
4. Modifying chart and graph parameters - Excel 2013 and 20166:00
-
5. Applying chart layouts and styles4:00
Level 5, Section 3: Insert and format an object
-
1. Inserting text boxes and positioning objects4:00
-
2. Inserting SmartArt5:00
-
3. Inserting ClipArt and images3:00
-
4. Inserting Screenshots3:00
-
5. Adding borders to objects5:00
-
6. Inserting shapes5:00
-
7. Adding styles and effects to objects4:00
-
8. Changing workbook themes4:00
-
9. Modifying object properties, including adding alternate text5:00
Level 5, Section 4: create and modify images by using the Image Editor
-
1. Making corrections to an image3:00
-
2. Using picture colour tools2:00
-
3. Send to front and back, and transparent colour2:00
-
4. Changing artistic effects on an image3:00
-
5. Crop picture4:00
Level 5, Section 5: Format and modify text with functions
-
1. Utilising the CONCATENATE function5:00
-
2. Utilising the RIGHT, LEFT and MID functions7:00
-
3. Utilising the TRIM function3:00
-
4. Utilising the UPPER and LOWER functions3:00
About 77-420: Excel 2013 Certification Video Training Course
77-420: Excel 2013 certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's 77-420: Excel 2013 video training course for passing certification exams is the only solution which you need.
Pass Microsoft Excel 77-420 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
77-420 Premium Bundle
- Premium File 30 Questions & Answers. Last update: Apr 21, 2024
- Training Course 135 Lectures
- Study Guide 473 Pages
Free 77-420 Exam Questions & Microsoft 77-420 Dumps | ||
---|---|---|
Microsoft.certkiller.77-420.v2024-02-06.by.ellis.16q.ete |
Views: 181
Downloads: 154
|
Size: 3.63 KB
|
Microsoft.testkings.77-420.v2020-02-13.by.marko.14q.ete |
Views: 1657
Downloads: 2110
|
Size: 3.01 MB
|
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online 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
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
IT Certification Tutorials
- Top Career Opportunities for Financial Certified Professionals
- Top Project Management Certifications to Improve Your CV
- Top 10 Computer Job Titles That Will Rule the Future
- Discontinuation of ITIL v3 in 2022 And New Technological Era
- GAQM CSM-001 Certified Scrum Master - Chapter 04 - Meetings in Scrum Part 3
- Python Institute PCAP - Modules; Packages and Object Oriented Programming in Python Part 3
- PMI PMP Project Management Professional - Introducing Project Risk Management Part 3
- CompTIA CASP+ CAS-004 - Chapter 01 - Understanding Risk Management Part 3
- DA-100 Microsoft Power BI - Part 2 Level 2 - Getting Multiple files
- CompTIA CASP+ CAS-004 - Chapter 04 - Implementing Security for Systems; Applications; and Storage Part 3
- IIBA CBAP - Tasks of Business Analysis Planning and Monitoring
- MB-210 Microsoft Dynamics 365 - Create and Manage Product and Product Catalog Part 2
- Salesforce Certified Platform App Builder - 5 - Business Logic and Process Automation Part 3
- Amazon AWS Certified Data Analytics Specialty - Domain 4: Analysis
- Google Professional Cloud Network Engineer - Designing; Planning; and Prototyping a GCP Network Part 3