Course Information
Course Name: Microsoft Excel 2019 Online Course
Total Video Hours: 5 Hrs 37 Min
Total Videos: 58
Delivery Mode: Online, On-Demand
Skill Level: Beginner to Advanced
Instructor: Lindsay Hurley
Microsoft Excel 2019 Online Course is structured to support users across multiple skill levels. The training addresses everyday spreadsheet tasks, advanced analytical workflows, and automation features commonly required in business, finance, administration, and data-focused roles. Instruction emphasizes hands-on application, logical structure, and consistent formatting practices that align with modern workplace standards.
Included in This Course
5+ hours of structured Excel 2019 video training
58 topic-focused lessons covering beginner to advanced skills
Step-by-step guidance on formulas, functions, and references
Chart creation and data visualization techniques
Spreadsheet organization and workbook management practices
Data validation, conditional formatting, and error handling
Pivot table and pivot chart data analysis workflows
Scenario analysis, goal seek, and automation tools
Introduction to macros and Visual Basic for Applications (VBA)
Productivity-focused Excel spreadsheet management techniques
Microsoft Excel 2019 Course Outline
Module 1: Beginner
Module 2: Intermediate
Module 3: Advanced
Microsoft Excel 2019
Microsoft Excel 2019 Online Course addresses the increasing demand for structured spreadsheet skills in modern professional environments. Excel remains a core productivity application across industries, supporting data organization, reporting, financial modeling, and analytical decision-making. This course presents a logical progression from basic spreadsheet concepts to advanced analytical and automation techniques, ensuring practical skill development aligned with workplace expectations.
Spreadsheet fundamentals form the foundation of effective Excel usage. Early sections of the course focus on understanding the Excel interface, including the ribbon, file management, and data entry practices. Proper formatting techniques are emphasized to ensure clarity, consistency, and professional presentation. These foundational skills support efficient workbook creation and reduce errors during data manipulation and reporting tasks.
Formulas and cell references represent a critical component of spreadsheet accuracy. The course explains how formulas function within Excel 2019, including relative and absolute references. Learners gain clarity on how calculations update dynamically and how structured references support scalable worksheet design. Common formula errors are addressed to help users identify and correct calculation issues efficiently.
Functions extend Excel’s computational capabilities beyond basic arithmetic. The course introduces essential functions such as AUTOSUM, COUNT, and AVERAGE, providing practical examples of how these tools support data summarization and reporting. Understanding function syntax and the Formula Builder ensures users can apply calculations accurately across a wide range of business scenarios.
Visual data representation enhances interpretation and communication. Chart creation and customization are covered to demonstrate how Excel 2019 supports graphical reporting. Learners gain insight into selecting appropriate chart types, adjusting formatting elements, and aligning visuals with data narratives. These charting techniques support presentations, reports, and executive summaries.
Intermediate Excel functionality focuses on managing larger and more complex workbooks. Navigating multiple worksheets, linking data between workbooks, and creating summary sheets improve efficiency when handling interconnected datasets. View options such as split screens and multiple windows support comparative analysis and reduce navigation time during detailed reviews.
Data organization and filtering techniques are essential for effective spreadsheet management. The course explains how filters, grouping, and ungrouping streamline data exploration. Excel tables and structured references are introduced to support dynamic data ranges and consistent formulas, ensuring scalability as datasets expand.
Data validation and error identification play a vital role in maintaining spreadsheet integrity. The course demonstrates how validation rules control data entry, reducing inaccuracies and enforcing consistency. Error location tools assist users in identifying issues within complex formulas and datasets, supporting reliable reporting outcomes.
Advanced Excel 2019 capabilities focus on analytical decision-making and automation. Conditional functions such as IF statements and nested logic are explained to support rule-based calculations. Date, time, logical, and informational functions expand analytical depth, enabling users to extract meaningful insights from structured data.
Lookup functions such as VLOOKUP and HLOOKUP are addressed as essential tools for data retrieval across tables. These functions support reporting workflows that require matching values across datasets. Custom dropdown lists further enhance data accuracy by standardizing input options within worksheets.
Pivot tables represent one of Excel’s most powerful analytical tools. The course explains what pivot tables are, why they are used, and how they transform raw data into summarized insights. Learners gain experience creating, modifying, formatting, and deleting pivot tables to support flexible data analysis.
Pivot charts extend analytical capabilities by visualizing pivot table data. Customization techniques demonstrate how charts adapt to evolving datasets and analytical perspectives. These skills support trend identification, performance tracking, and comparative analysis within professional reporting contexts.
Scenario analysis tools such as Goal Seek provide decision-support capabilities within Excel 2019. The course explains how scenarios evaluate variable outcomes and how Goal Seek identifies required inputs to achieve desired results. These tools are particularly valuable for financial modeling, forecasting, and operational planning.
Automation through macros increases productivity by reducing repetitive tasks. The course introduces preinstalled macros, macro recording, and macro-enabled workbook management. Learners gain exposure to Visual Basic for Applications (VBA), demonstrating how simple macros are created and assigned to streamline workflows.
Protecting data integrity is addressed through worksheet and workbook protection techniques. These features ensure sensitive information remains secure while allowing controlled access for collaboration. Understanding protection options supports compliance and governance requirements in professional environments.
Microsoft Excel 2019 Online Course is designed to support career advancement by strengthening spreadsheet proficiency across functional roles. Instruction provided by Lindsay Hurley ensures clarity, logical progression, and practical application. The course structure accommodates learners seeking foundational knowledge as well as professionals refining advanced Excel skills for data analysis, reporting, and automation.
FAQs
Who should take the Microsoft Excel 2019 Online Course?
This course is suitable for beginners, professionals, and advanced users who require practical Excel 2019 skills for work or career development.
Does the course cover both basic and advanced Excel features?
Yes, the course progresses from beginner topics through intermediate and advanced Excel 2019 functionality.
Are pivot tables and pivot charts included in the training?
Yes, pivot table creation, modification, formatting, and pivot chart analysis are fully covered.
Does the course explain Excel formulas and functions in detail?
Yes, formulas, functions, conditional logic, and lookup functions are explained with practical examples.
Is macro creation covered in this course?
Yes, the course includes macro recording, macro-enabled workbooks, and an introduction to VBA.
How long does it take to complete the course?
The total video duration is 5 hours and 37 minutes, allowing flexible self-paced completion.
.jpg)
