Excel 2013 Video Course

77-420: Excel 2013

Your Microsoft 77-420 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 77-420 certification test. Ace your Microsoft 77-420 at the first attempt and obtain the Excel 2013 credential with ease.

# of Students
136
# of Lectures
135
Course Length
11 h
Course Rating
5.0
Price $32.99
Today $29.99

Curriculum for 77-420 Video Course

Level 1, Section 1 - An introduction to Excel

  Video Name 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
  Video Name 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
  Video Name Time
  1. Saving workbooks in alternate file formats 7:00
  2. Maintaining backward compatibility 6:00
  3. Saving files to remote locations 3:00
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name Time
  1. Inserting total rows 4:00
  2. Adding and removing styles and Banding rows and columns 6:00
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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
  Video Name 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

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
5.0
Rating: 5.0
Overall Rating: Good.

Similar 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.

  • 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

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address