Certification training

77-42077-420: Excel 2013

Prepare for your Microsoft exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

135Lectures
11h 9mDuration
MicrosoftVendor
77-420: Excel 2013 course cover Best seller
Microsoft certification training 77-420 135 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

22 sections, 135 lessons, and lecture-level duration details.

01 Creating new blank workbooks 4m
02 Entering data 9m
03 An introduction to fonts and highlighting 4m
04 Saving and closing your workbook 5m
05 Practice Activity Number 1 - The Solution 2m

01 Creating new workbooks using templates 6m
02 Menus and toolbars 7m
03 Managing multiple workbooks - Excel 2013 and 2016 4m
04 Managing multiple workbooks - Excel 2007 and 2010 7m
05 Importing files and Opening non-native files directly in Excel 8m
06 Adding worksheets to existing workbooks 4m
07 Copying and moving worksheets, and changing spreadsheet order 5m

01 Saving workbooks in alternate file formats 7m
02 Maintaining backward compatibility 6m
03 Saving files to remote locations 3m

01 Using basic operators 6m
02 Order of operations 6m
03 How to enter numbers and dates in Excel 3m
04 Referencing cell ranges in formulas 10m
05 Practice Activity Number 2 - Solution 6m

01 Searching for data within a workbook 5m
02 Hyperlinks 5m
03 Using Go To and Using Name Box 5m
04 Hot Keys 4m

01 Changing worksheet tab colour 5m
02 Inserting and deleting columns and rows 8m
03 Undo and Redo 4m
04 File Management tips 4m
05 Adjusting row height and column width 5m
06 Hiding columns and rows 4m
07 Selecting multiple ranges 4m

01 Hiding worksheets 4m
02 Customising the Quick Access toolbar 3m
03 Customising the Ribbon 5m
04 Assigning shortcut keys 3m
05 Recording simple macros 5m
06 Managing macro security 8m
07 Changing workbook views 4m
08 Using zoom 3m
09 Adding values to workbook properties 5m
10 Displaying formulas 3m
11 Freezing panes 5m
12 Splitting the window 3m

01 Printing individual worksheets 3m
02 Printing an entire workbook and printing a selection 2m
03 Setting a print area 4m
04 Page setup, Part 1 (first two tabs) 6m
05 Page setup, Part 2 (Repeating headers and footers) 3m
06 Adding dynamic text to headers and footers 3m
07 Inserting watermarks 3m
08 Page setup, Part 3 (Headings etc.) 7m
09 Configuring workbooks to print 3m
10 Inspecting your workbook prior to distribution 4m

01 Copying and pasting basics, and Utilising references (relative, mixed, absolute) 9m
02 Practice Activity - multiplication table 3m
03 Answer - multiplication table 3m

01 Appending data to Excel worksheets 3m
02 Setting data validation 11m
03 Finding and replacing data 7m
04 Copying and pasting data, including Paste Special 5m
05 Cutting and moving cell data 3m
06 Using AutoFill tool, and Expanding data across columns 5m

01 Modifying cell alignment and indentation 5m
02 Wrapping text within cells 5m
03 Merging cells and Shrink to Fit 7m
04 Changing font and font styles 4m
05 Applying highlighting 2m
06 Applying Number format 8m
07 Applying borders 6m
08 Applying cell styles 3m
09 Using Format Painter 3m
10 Changing text to WordArt 2m

01 Applying conditional formatting - highlighting 12m
02 Applying conditional formatting - Bars, Scales and Sets 10m
03 Transposing columns and rows, and #####s 3m
04 Inserting sparklines, and how to define a range 5m
05 Customising Sparklines 7m

01 Doing calculations without formulas 3m
02 Utilising the SUM function 5m
03 Formula syntax - SUM function 7m
04 Utilising the COUNT function 7m
05 Utilising the AVERAGE and other averaging functions 8m
06 Utilising the MIN and MAX functions 3m
07 Creating named ranges 8m
08 Getting help with functions 3m

01 Moving between tables and ranges 5m
02 Adding and removing cells within tables 4m
03 Formulas in tables 6m
04 Defining titles 4m

01 Inserting total rows 4m
02 Adding and removing styles and Banding rows and columns 6m

01 Setting up a filter and Filtering records 6m
02 More advanced filtering options 12m
03 Using sort options 5m
04 Sorting data on multiple columns; changing sort order 4m
05 Removing duplicates 4m
06 Inserting subtotals 4m
07 Creating outlines; collapsing groups of data in outlines 6m
08 Utilising the SUBTOTAL function 7m

01 Utilising the IF function 8m
02 Utilising the SUMIF function 6m
03 Utilising the COUNTIF function 4m
04 Utilising the AVERAGEIF function 4m
05 Nested IFs and Evaluate Formulas 6m
06 The CHOOSE function 3m

01 Creating charts and graphs 6m
02 Adding and removing additional data series 4m
03 Exploring the Column charts 6m
04 Line, bar and area charts 4m
05 Pie charts 3m
06 Other graph types 8m
07 Switching between rows and columns in source data 3m

01 Adding legends 7m
02 Positioning and Resizing charts and graphs, inc 5m
03 Modifying chart and graph parameters - Excel 2007 and 2010 6m
04 Modifying chart and graph parameters - Excel 2013 and 2016 6m
05 Applying chart layouts and styles 4m

01 Inserting text boxes and positioning objects 4m
02 Inserting SmartArt 5m
03 Inserting ClipArt and images 3m
04 Inserting Screenshots 3m
05 Adding borders to objects 5m
06 Inserting shapes 5m
07 Adding styles and effects to objects 4m
08 Changing workbook themes 4m
09 Modifying object properties, including adding alternate text 5m

01 Making corrections to an image 3m
02 Using picture colour tools 2m
03 Send to front and back, and transparent colour 2m
04 Changing artistic effects on an image 3m
05 Crop picture 4m

01 Utilising the CONCATENATE function 5m
02 Utilising the RIGHT, LEFT and MID functions 7m
03 Utilising the TRIM function 3m
04 Utilising the UPPER and LOWER functions 3m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.