- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft Excel 2019 Training
Microsoft Excel is the go-to spreadsheet application, no matter if you’re using it personally or professionally. Whether your knowledge of Microsoft Excel is beginner’s level or advanced, this Microsoft Excel 2019 Training online course will help take your abilities to a new height – covering topics from basic to intermediate and even advanced.
Included In This Course
Included In This Course
5 Training Hours
58 On-demand Videos
Closed Captions
3 Topics
54 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 Microsoft Excel 2019 Training online course
Our online Excel training course covers Microsoft Excel 2019 which is the most popular spreadsheet application for both personal and professional 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 2019 training course because it covers basic, intermediate, and advanced topics.
This course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. In addition, it will help students understand how to manipulate data within a spreadsheet, validate, and present information using the built-in structure and functions of Microsoft Excel.
What you will learn in this online Excel training course Video-based lessons
This course includes six hours of training and 58 videos. Throughout this online Excel training course, students will learn how to save files, entering and formatting data, how to work with formulas, inserting functions, how to use function, customizing charts, and more!
- This training is your one-stop source for all things Excel—from the basics to advanced features. Brush up on everything you need to know about this powerful software!
- Are you new to Excel? Don’t worry! With this tutorial, you’ll quickly become an expert in all the fundamental elements of spreadsheets.
- Master Excel Skills & Become An Expert User by creating custom charts
- Excel will revolutionize your workflow, allowing you to automate and streamline processes like never before.
- Master the art of writing potent and agile formulas that will make your work in Excel much easier. Create dynamic reports by mastering one of the most popular tools, PivotTables
- Unleash the full potential of Excel with Macros and revolutionize how you complete your everyday tasks.
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 2019 Course Content
Module 1: Beginner
1.0 Intro
1.1 The Ribbon
1.2 Saving Files
1.3 Entering and Formatting Data
1.4 Printing from Excel & Using Page Layout View
1.5 Formulas Explained
1.6 Working with Formulas and Absolute References
1.7 Specifying and Using Named Range
1.8 Correct a Formula Error
1.9 What is a Function
1.10 Insert Function & Formula Builder
1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
1.12 Create and Customize Charts
Module 2: Intermediate
2.0 Recap
2.1 Navigating and editing in two or more worksheets
2.2 View options - Split screen, view multiple windows
2.3 Moving or copying worksheets to another workbook
2.4 Create a link between two worksheets and workbooks
2.5 Creating summary worksheets
2.6 Freezing Cells
2.7 Add a hyperlink to another document
2.8 Filters
2.9 Grouping and ungrouping data
2.10 Creating and customizing all different kinds of charts
2.11 Adding graphics and using page layout to create visually appealing pages
2.12 Using Sparkline formatting
2.13 Converting tabular data to an Excel table
2.14 Using Structured References
2.15 Applying Data Validation to cells
2.16 Comments - Add, review, edit
2.17 Locating errors
Module 3: Advanced
3.1 Recap
3.2 Conditional (IF) functions
3.3 Nested condition formulas
3.4 Date and Time functions
3.5 Logical functions
3.6 Informational functions
3.7 VLOOKUP & HLOOKUP
3.8 Custom drop down lists
3.9 Create outline of data
3.10 Convert text to columns
3.11 Protecting the integrity of the data
3.12 What is it, how we use it and how to create a new rule
3.13 Clear conditional formatting & Themes
3.14 What is a Pivot Table and why do we want one
3.15 Create and modify data in a Pivot Table
3.16 Formatting and deleting a Pivot Table
3.17 Create and modify Pivot Charts
3.18 Customize Pivot Charts
3.19 Pivot Charts and Data Analysis
3.20 What is it and what do we use it for
3.21 Scenarios
3.22 Goal Seek
3.23 Running preinstalled Macros
3.24 Recording and assigning a new Macro
3.25 Save a Workbook to be Macro enabled
3.26 Create a simple Macro with Visual Basics for Applications (VBA)
3.27 Outro
$49.00
OR
Subscribe To All-Access
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 2019 Training
Microsoft Excel 2019 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
Learn Microsoft Outlook and improve your productivity with our comprehensive online course. Get certified with ITU Online! Enroll now.
Become an expert with our Outlook 2013 course. Microsoft Outlook 2013 provides its more than 500 million Office users with an amazing collection of business and personal email management tools. With the introduction of Outlook 2013, these global individuals now have access to a range of experiences that better cover their needs in life – whether at work, home or school.
$49.00
Master Microsoft Word with our online training course. Learn valuable skills and boost your resume. Enroll now and get certified!
Whether you are a beginner or expert user of Microsoft Office Word 2013, this Word 2013 Training course will equip you with the essential knowledge needed to effectively use its features. Not only can Microsoft Word 2013 help organize your work, but it also allows for efficient document writing and editing. Start on the path to mastering this word-processing program today!
I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.