Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft Excel 2016 Training
In this course you will learn how to use Microsoft Excel 2016 more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel. This Microsoft Excel 2016 training course covers basic, intermediate and advanced competency levels.
Included In This Course
Included In This Course
9 Hrs 5 Min
32 On-demand Videos
Closed Captions
3 Topics
148 Prep Questions
Certificate of Completion
Course Description
Note: Even though this course is based on an older version, it is still a worthwhile resource for online learning and training.
About our online Microsoft Excel 2016 Training course
Our comprehensive Microsoft Excel 2016 video tutorials training course for beginner to advanced will equip you with the most current and actionable tips and strategies for using this renowned software platform. Packed with hours of video content full of useful knowledge, but free from unnecessary filler content, the course is regularly updated so that your skills stay up-to-date with any changes in Microsoft Excel. Enroll today and unlock its powerful potential!
Are you ready to begin your Microsoft Excel journey? Start off by receiving an overview of the course and understanding how to launch it. Then, open up a world of possibilities with mastering worksheet basics and acquire some novice Excel tactics!
Once you have a comprehensive understanding of the fundamentals, enter and manipulate columns and rows, select cells & ranges, use formulas and shortcuts to copy/move data. Additionally comprehend how fill handles work in naming ranges, formatting worksheets contents plus working on table filters. As your excel knowledge expands learn about function (like accounting functions or AVERAGE function) & what-if analysis; how to find & fix errors while protecting your workbooks and working across multiple sheets or creating charts!
Upon completion of our Learn Microsoft Excel course, you will have the knowledge and skills to:
- Mastering Excel is essential for productivity and efficiency. Learn the best practices to maximize your use of this powerful program.
- Gaining an understanding of worksheet fundamentals and mastering keyboard shortcuts can take your productivity to the next level.
- Discover the power of manipulating columns and rows.
- Discover the procedures for entering and altering diverse data types such as text, numbers, dates, and symbols.
- Enhance your skills in Excel by mastering the art of selecting cells and ranges, as well as discovering foundational formulas, financial functions, basic stats functions, and more.
- Streamline your workflow by leveraging the fill handle – you’ll save yourself precious time in terms of copying and moving files!
- Designate names to specific cells or groups of cells and unlock the power of SUM, as well as numerous other functions.
- Master the art of formatting your Excel worksheets like an expert!
- Master the art of transforming a massive Excel file for printing and take your skills to the next level.
- Master data handling by creating tables, pivot tables and charts while actively safeguarding your work.
About Microsoft Excel
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 course because it covers basic, intermediate, and advanced competency levels.
Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built-in structure and functions of Microsoft Excel.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
Your Training Instructor
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.
Subscribe To All-Access
Lock In $14.99 / Month Forever
Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.
$49.00 $14.99 Monthly
OR
$49.00
Microsoft Excel 2016 Training
Microsoft Excel 2016 Training
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
Become an Outlook expert with our Microsoft Outlook Online Course. Learn valuable skills and boost your productivity today!
With this Microsoft Outlook 2016 training course, you will learn the four major components of Outlook including contacts, email, calendars, and tasks. You will also learn about the OneNote application that provides a cross-platform and cross-application note taking tool. This course covers all the bases, including Basic Outlook 2016, Intermediate Outlook 2016 and Advanced Outlook 2016.
$49.00
Master Microsoft Office 365 with our 70-347: Enabling Office 365 Services course and advance your career in cloud computing today!
This Microsoft 70-347: Enabling Office 365 Services course is the perfect choice for IT professionals seeking to assess, plan, deploy and manage Office 365 services and their corresponding dependencies, needs and technical resources.
$49.00
Learn Microsoft Excel with our online course. Master spreadsheets, charts, and data analysis with interactive lessons and practical exercises.
In this Excel 2010 Course you will learn the basic, intermediate, and advanced features with Microsoft Office’s Excel 2010 training. You will learn how to use this spreadsheet program to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts.
Mary Beth helped me. She was wonderful.