Microsoft Excel 2013 And 2016 Training Bundle - ITU Online

Microsoft Excel 2013 and 2016 Training Bundle

Even if you have limited experience with Excel, this Microsoft Excel 2016 training bundle will prove to be invaluable. You’ll gain the tools and skills required to use it more proficiently, no matter whether you are utilizing Excel 2013 or 2016. Through this course, learn how to manage data within a spreadsheet and produce compelling visuals using the in-built functions of Microsoft Excel.

Included In This Course

Included In This Course

Total Hours
15 Training Hours
Microsoft Excel 2013 and 2016 Training Bundle
71 On-demand Videos
Closed Caption

Closed Captions

Course Topics
6  Topics
Prep Questions
206 Prep Questions
Microsoft Excel 2013 and 2016 Training Bundle

Certificate of Completion

Course Description

This Microsoft Excel 2016 training bundle includes 6 certification courses on Microsoft Excel. Students get the full curriculum for Microsoft Excel Basic, Intermediate & Advanced for both the 2013 and 2016 versions of the software. Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training. This Microsoft Excel training bundle will help arm you with the knowledge to use it more effectively whether you are using Excel 2013 or Excel 2016. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft Excel 2016 Course Content

Excel 2016 Basic

  •    Tabs And Ribbons Part1

  •    Tabs And Ribbons Part2

  •    Cells Part1

  •    Cells Part2

  •    Cells Part3

  •    Cells Part4

  •    Calculations Part1

  •    Calculations Part2

  •    Calculations Part3

  •    Printing Part1

  •    Printing Part2

Excel 2016 Intermediate

  •    Menus And Keyboard Shortcuts Part1

  •    Menus And Keyboard Shortcuts Part2

  •    Menus And Keyboard Shortcuts Part3

  •    Tabs Part1

  •    Tabs Part2

  •    Formulas And Calculations Part1

  •    Formulas And Calculations Part2

  •    Formulas And Calculations Part3

  •    Formulas And Calculations Part4

  •    Importing Data Part1

  •    Importing Data Part2

  •    Invoices

Excel 2016 Advanced

  •    Advanced Invoice Part1

  •    Advanced Invoice Part2

  •    Advanced Invoice Part3

  •    Advanced Invoice Part4

  •    Number Crunching

  •    Creating A Pivot Table From Scratch

  •    Smaller Excel Components Part1

  •    Smaller Excel Components Part2

  •    Smaller Excel Components Part3

Microsoft Excel 2013 Course Content

Excel 2013 Basic

  •    Intro To Excel Overview Of Screen

  •    Ribbon Elements

  •    Entering Data And Editing Font Attributes

  •    Number Formats

  •    Formatting Cells

  •    Printing

  •    Formulas - Part 1

  •    Formulas - Part 2

  •    Rearranging Data

  •    More Formulas - Part 1

  •    More Formulas - Part 2 Review And Sort

  •    More Formulas - Part 3 Concatenate

  •    Chart - Part 1

  •    Chart - Part 2

  •    Chart - Part 3

  •    Summary

Excel 2013 Intermediate

  •    Introduction

  •    Review

  •    Formulas Across Worksheets - Part 1

  •    Formulas Across Worksheets - Part 2

  •    Conditional Formatting

  •    Data Validation

  •    Names Ranges

  •    CSV Files

  •    Text To Column

  •    Grouping Data

  •    More Charts Beyond Building Blocks

  •    Working With Windows - Part 1

  •    Working With Windows - Part 2

  •    Headers Footers And Protecting Data

Excel 2013 Advanced

  •    Pivot Tables - Part 1

  •    Pivot Tables - Part 2

  •    Sparklines

  •    Trancing Formulas

  •    What If Scenario

  •    External Data Sources

  •    Customizing Menus And Options - Part 1

  •    Customizing Menus And Options - Part 2

  •    Macros

Add a review
Currently, we are not accepting new reviews
4.8
Based on 80 reviews
1-5 of 80 reviews
  1. AA
  2. K
  3. BO
  4. A

    Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

  5. A

Your Training Instructor

Josh Schofer

Josh Schofer

Cybersecurity | Cloud Trainer

Josh has 15 plus years in account management and client support with over 5 years specifically in the healthcare industry. Josh provides hands-on leadership to the healthcare team at NetDirector by focusing on client success and innovative solutions. As the Healthcare Operations Manager, Josh ensures that each client implementation is completed as efficiently as possible with the greatest impact to the client. He holds a Bachelor of Arts degree from the University of South Florida.

Microsoft Excel 2013 and 2016 Training Bundle
 

$49.00

OR

Subscribe To All-Access
Lock In $14.99 / Month Forever

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft Excel 2013 and 2016 Training Bundle

default-course image
Microsoft Excel 2013 and 2016 Training Bundle
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Master Adobe InDesign and take your design skills to the next level with ITU Online’s comprehensive training course.

In this course we’ll review InDesigns graphic creation capabilities, how to import graphics and how to properly organize them for a project.

Add To Cart

$49.00

Master Microsoft Word and Excel Bundle – Save Big on the Most Essential Office Applications. Enroll Today and Boost Your Skills!
Add To Cart

$49.00

Become a Windows 7 Desktop Support Technician with ITU’s Microsoft 70-685 Pro online course.

In this Microsoft 70-685 course you will learn how to identify the cause of and resolve desktop application issues, identify the cause of and resolve networking issues, manage and maintain systems that run the Windows 7 client, support mobile users, and identify the cause of and resolve security issues.

Add To Cart