Microsoft Excel 2019 Training

Course Level: Beginner
Duration: 5 Hrs 37 Min
Total Videos: 58 On-demand Videos

Master the intricacies of Microsoft Excel 2019 with our comprehensive training course. Ideal for beginners to advanced users seeking to enhance their skills for professional or academic purposes, this course covers everything from basic data entry to complex data analysis tools, empowering you with the knowledge to excel in various career opportunities.

Get Access To Every Vision Training Course

Learning Objectives

01

Understand the basics of Excel, including navigating the Ribbon, saving files, and entering and formatting data.

02

Gain proficiency in using Excel formulas, correcting errors, and understanding the functionalities of different functions.

03

Learn to insert functions, create charts, and customize these charts to suit your needs.

04

Develop skills in navigating and editing multiple worksheets, creating links between worksheets, and adding hyperlinks to documents.

05

Master the use of view options, filters, and grouping data for efficient data management in Excel.

06

Learn to create and customize visually appealing pages, convert tabular data to Excel tables, and apply data validation to cells.

07

Understand advanced Excel functions such as conditional functions, VLOOKUP, HLOOKUP, and create custom drop-down lists.

08

Learn to create and manipulate data in Pivot Tables and Charts, run preinstalled Macros, and create a simple Macro with Visual Basics for Applications (VBA).

Course Description

Unleash your potential with our comprehensive Microsoft Excel 2019 Training Course, designed to transform you from a novice to a proficient user of one of the world’s most popular spreadsheet applications. This course covers a wide range of Excel’s functionalities, from beginner-level topics such as data entry and formatting, to advanced functionalities like pivot tables, macros, and conditional formatting. Whether you are a professional seeking to enhance your data management skills, a student aiming to boost your academic performance, or an individual interested in gaining a competitive edge in the job market, this course provides practical knowledge and skills with real-world applications.

The course begins with an introduction to Excel’s interface, guiding you through the process of creating, managing, and customizing worksheets, and effectively applying formulas and functions. As you progress, the course delves into more advanced topics, providing you with insights into data validation, conditional formatting, and data analysis tools. By the end of the course, you will have a well-rounded understanding of Excel’s capabilities and will be able to create visually appealing reports, manage and analyze large datasets, and automate routine tasks, thereby increasing your productivity and efficiency.

Enrolling in our Microsoft Excel 2019 Training Course will not only equip you with essential Excel skills but also open up a plethora of career opportunities across various industries. Job roles such as Data Analyst, Business Analyst, Financial Analyst, Project Manager, and many more highly value proficiency in Excel for tasks such as data management, financial modeling, and reporting. Mastering Microsoft Excel 2019 can significantly enhance your career prospects and make you a valuable asset to any organization. Don’t miss out on this opportunity to elevate your skills and career prospects. Enroll today and take the first step towards becoming an Excel expert!

Who Benefits From This Course

  • Individuals seeking to enhance their office productivity skills
  • Business professionals who handle data analysis and reporting
  • Administrative professionals responsible for data management
  • Job seekers aiming to improve their resume with technical skills
  • Entrepreneurs and small business owners who manage their own financial data
  • Students aspiring for a career in data analysis or management
  • Educators needing to track and analyze student data
  • Researchers who work with large datasets
  • Financial analysts who deal with complex financial data
  • Project managers requiring to track and present project data

Frequently Asked Questions

What are the potential career opportunities after mastering Microsoft Excel 2019?
Proficiency in Microsoft Excel 2019 can open up a wide range of career opportunities across various industries. Potential job titles include:
  • Data Analyst
  • Financial Analyst
  • Business Analyst
  • Project Manager
  • Administrative Assistant
  • Accountant
  • Marketing Analyst
These roles leverage Excel skills for data management, financial modeling, reporting, and more, making you a valuable asset to any organization.
What are the key functionalities covered in the Microsoft Excel 2019 training?
This course covers a vast range of Excel's most valuable functionalities, which include but are not limited to:
  • Data entry and formatting
  • Complex formulas
  • Data analysis tools
  • Data validation
  • Conditional formatting
  • Pivot tables
  • Macros
These functionalities ensure you have a well-rounded understanding of Excel's capabilities.
How can proficiency in Excel enhance my analytical skills?
Excel is a powerful tool for data analysis. It allows you to manipulate, analyze, and visualize data, which is crucial for making data-driven decisions. By mastering Excel, you can manage large datasets, leverage formulas to calculate statistics, use conditional formatting to highlight data trends and patterns, create pivot tables for data summarization, and generate charts and graphs for data visualization. These skills not only enhance your analytical capabilities but also improve your problem-solving and decision-making skills, making you a valuable asset in any data-driven role.
Who can benefit from the Microsoft Excel 2019 Training Course?
This course is designed for a wide range of learners. Whether you are a beginner looking to gain a solid foundation in Excel, a professional aiming to enhance your data management skills, a student seeking to improve your proficiency for academic projects, a business analyst, a data scientist, or anyone interested in automating tasks, this course offers valuable insights and practical knowledge for everyone.
Why is Microsoft Excel 2019 considered a valuable skill in the job market?
Microsoft Excel is one of the most widely used spreadsheet applications in the world. It is integral to many business operations, particularly those involving data management, financial modeling, and reporting. Employers across various industries highly value Excel proficiency due to its critical role in data analysis and decision-making. By mastering Excel, you can increase your productivity, enhance your analytical skills, and gain a competitive edge in the job market.

Included In This Course

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

Vision What's Possible

Vision Your Best Career
365
Price: $139 / YEAR

Gain unlimited access to our comprehensive IT training library featuring top certifications like CompTIA, Cisco, Microsoft, AWS, and more. Explore expert-led courses in cybersecurity, networking, cloud computing, project management, and soft skills development—all designed to help you build real-world, job-ready skills. With the 365 Training Pass, you can start learning today and accelerate your path to a successful IT career.

Sign Up for my 365 access pass today
  • 855-488-5327
  • customerservice@visiontrainingsystems.com

Navigate With Us