Excel 2019

Unlock Your Data Potential with Excel 2019

Excel 2019

Unlock Your Data Potential with Excel 2019

Step into a world where data transforms into powerful insights with our Excel 2019 course. Unravel the secrets of this indispensable tool and elevate your skills from novice to master, empowered to manipulate data with precision. Whether you're streamlining workflows or creating dynamic visualizations, this course is your key to achieving professional excellence and personal growth. Our expert-guided journey invites you to explore Excel's infinite possibilities--enhancing productivity, fostering informed decision-making, and unlocking the mastery behind every cell. Don't just navigate spreadsheets; command them with confidence and creativity. Be the catalyst for your career advancement and life transformation. Embrace the future of data management today--where every click counts and every formula inspires. This is not just learning; it's Excel enlightenment.

Add to Cart

OVERVIEW

CURRICULUM

Lesson 1. Navigating the World of Microsoft Excel: From Basics to Mastery

Microsoft Excel empowers users to efficiently manage, calculate, and visualize data, offering seamless integration with other Microsoft Office tools like Word and Outlook. Understanding basic navigation and the ribbon interface enhances productivity, making Excel a versatile tool for both personal and professional use.

Lesson 2. Entering Data with Precision in Excel

Excel distinguishes between a worksheet and a workbook, allowing users to organize multiple sheets within a single file, enabling seamless data connections and enhanced calculations. Entering and formatting data properly, including overriding default settings, ensures accurate representations of text, values, and formulas which are crucial for effective Excel usage.

Lesson 3. Excel Beyond Basics: Mastering Cell Formatting and Styling

Excel simplifies data presentation by automatically formatting strings and numbers and providing template options for consistent numeric display. Users can leverage cell, font, and alignment styles to enhance visual appeal and structure, including custom formats for specific needs.

Lesson 4. Excel Editing Essentials

Editing Excel cells involves replacing values and adjusting formats, which may be necessary to keep data accurate and relevant; Excel's formulas automatically update to reflect changes and can reference external sheets and workbooks for comprehensive data management. Teams can enhance collaboration by leaving comments, protecting cells, and managing specific edit permissions, ensuring data integrity and controlled access.

Lesson 5. Excel Formula Fundamentals

Using Excel's function lookup assists in identifying and leveraging various built-in functions, such as COUNT and ROUND, with proper parameter syntax, helping users to avoid errors in spreadsheets. This becomes crucial when embedding multiple functions within a single cell to perform complex calculations.

Lesson 6. Excel's What-If Tools: A Quick Overview

What-If Analysis in Excel simplifies the exploration of potential results by allowing dynamic adjustments without programming skills. Utilizing Scenarios, Goal Seek, and Data Tables can vastly improve your ability to foresee financial impacts and make informed decisions.

Lesson 7. Mastering Excel's Graphic Features

Lesson Summary 2

Lesson 8. Crafting Compelling Charts in Excel

With Excel's charting tools, users can transform static data into dynamic visualizations, choosing from diverse types like pie, bar, or line charts. These tools simplify data analysis by providing recommendations and easy data integration, while allowing extensive customization.

Lesson 9. Mastering Excel's Data Validation: Create Efficient Dropdowns

By configuring dropdown lists in Excel, users can choose from predefined data, reducing errors and improving efficiency in data entry tasks, with options to utilize either internal or external data sources. The data validation tool provides flexibility, enabling custom instructions and error messages to guide users in maintaining accurate and compliant data input.

Lesson 10. Dynamic Data Analysis with Pivot Tables

A pivot table turns static data into an adaptable analysis tool, providing diverse insights and answers by restructuring the dataset. Excel's SUM function complements this by enabling straightforward calculation of totals, enhancing the depth of data examination.

Lesson 11. Harness the Power of Templates and Macros in Excel

Microsoft Excel 2019 comes equipped with diverse templates for swift handling of common tasks and calculations, thus speeding up the workflow significantly. Paired with cleverly created macros, it turns the often redundant manual operations into efficient automated actions, albeit with cautious usage due to potential security concerns.

Lesson 12. Direct Database Connections: Excel Meets Access

With Excel, users can convert data from CSV files or databases for integration into spreadsheets, supporting diverse analytical needs. This tutorial guides through data transfer techniques from Microsoft Access to Excel, emphasizing on CSV exports and dynamic database queries.

Lesson 13. Excel Essentials: Sort and Filter Data

Excel's sorting feature simplifies data organization by allowing users to order data in ascending or descending sequence, while conditional formatting emphasizes specific cell values to improve data visibility, saving time during data evaluation tasks.

Lesson 14. Date, Time, and Text Functions

Master Excel with versatile functions like IF for conditional logic, NOW for current timestamps, and CONCAT for text processing, enhancing productivity and precision. These functions simplify complex tasks, allowing users to focus on data-driven decision-making.

Lesson 15. Mastering VBA: Unlocking Excel's Potential

VBA integrates seamlessly into Microsoft Office, allowing users to enhance Excel spreadsheets with custom functionalities and automation. To start using VBA, enable the 'Developer' tab, which provides access to coding tools and controls like buttons that can execute programmed macros.

In This Course

12 Hours average completion time
1.2 CEUs
15 Lessons
23 Exams & Assignments
1134 Discussions
20 Videos
16 Reference Files
Mobile Friendly
Last Updated April 2024

Description

Excel 2019 is the latest iteration of the popular spreadsheet software developed by Microsoft. Excel allows users to create rich, stylized spreadsheets used for storing, organizing, sorting, calculating, and charting data. With Excel, you can create visually appealing content that represents your data. Before you start using Excel though, you should first learn what all the features Excel offers are and how to use them, so that your spreadsheets are built correctly the first time.

In this course, you're going to learn how to...

Create spreadsheets
Format cells, rows, columns, and entire worksheets so they fit and match your data
Enter data into a spreadsheet
Use formulas and functions for math, accounting, and totaling
Create formulas and functions
Calculate data
Create charts and diagrams for your data
Create data lists and forms
Create and use pivot tables and pivot charts
Work with Excel templates
Share and protect your worksheets and workbooks
Use What-If Analysis to determine possible outcomes
And much more!

The first few lessons explain how to use Excel core features such as formatting rules and techniques. We then move on to formulas. Formulas are the foundation for most basic and complex spreadsheets that store data. Formulas allow you to automatically calculate results based on any number of variables including information stored in your rows, columns and cells. Once we learn how to use formulas, we'll move on to scenarios, pivot tables and what-if charts. These advanced tools allow you to track your reports and create projections for your business.

Nowadays, your Excel spreadsheet should include at least one chart, so we have step-by-step tutorials on charting, graphics, and using images. All these added components help make spreadsheets more visually appealing. We also review ways to use common functions as well as sort and filter data, so you can view large data sets in chronological, alphabetical or numerical order.

The final lesson introduces you to Visual Basic for Applications (VBA). VBA is a powerful language used to make macros. We will show you how to create simple recorded macros as well as how to edit macros for more complex applications.

With clear and concise step-by-step directions, beautifully illustrated lessons with screenshots, and HD Video tutorials, this Excel 2019 online course will teach you everything you need to know to become an Excel power user.

Note: You do not need access to Excel software in order to successfully complete this course, although it is strongly recommended in order to follow along with the course examples.

Skills You'll Develop

Efficiently manage and visualize complex data
Streamline data entry with Excel templates
Integrate Excel with databases and external data
Create dynamic and visually appealing spreadsheets
Enhance data accuracy with validation tools
Design compelling charts and diagrams
Automate tasks with Excel VBA and macros
Sort
filter
and organize large datasets efficiently
Utilize Excel's What-If Analysis for projections
Master Excel formulas and functions
Perform advanced data analysis using pivot tables

Skills You'll Develop

Efficiently manage and visualize complex data
Streamline data entry with Excel templates
Integrate Excel with databases and external data
Create dynamic and visually appealing spreadsheets
Enhance data accuracy with validation tools
Design compelling charts and diagrams
Automate tasks with Excel VBA and macros
Sort
filter
and organize large datasets efficiently
Utilize Excel's What-If Analysis for projections
Master Excel formulas and functions
Perform advanced data analysis using pivot tables

More About This Course

Efficient Data Management: Organize and visualize with ease.
Create Insightful Charts: Turn static data into interactive visuals.
Precision Data Entry Skills: Ensure accurate and clean data entries.
Direct Database Connectivity: Seamlessly integrate and analyze data.
Become a VBA Expert: Unlock advanced automation capabilities.
Excel Mastery from Basics to Advanced: Learn Excel's full potential fast.
Optimize Data Validation: Minimize errors, streamline data entry.
Master Formulas and Functions: Simplify complex calculations effortlessly.
Automate with Macros and Templates: Save time with automation tools.
Utilize Pivot Tables Effectively: Transform data into actionable insights.
What-If Analysis Proficiency: Dynamically explore future scenarios.
Advanced Cell Formatting: Enhance data's visual and structural appeal.

What You'll Achieve

Recognize and describe the basic components of Microsoft Excel's interface, including rows, columns, cells, and ribbon tabs.
Demonstrate the ability to create, save, and navigate an Excel spreadsheet, while utilizing basic features such as the Quick Access Toolbar and menu ribbon.
Define the difference between a worksheet and a workbook in Excel by providing examples of each.
Demonstrate how to perform basic mathematical operations using Excel formulas, including referencing cells for dynamic calculations.
Define the process of formatting numeric data in Excel by using specific number templates to control the display of decimals and currency symbols.
Demonstrate how to apply various cell styles in Excel, including font changes, text alignment, and cell colorization, to enhance the spreadsheet's visual appeal.
Define and demonstrate the process of referencing both internal worksheets and external workbooks in Excel by correctly applying the appropriate syntax.
Recognize and apply Excel's protection features to restrict access, edit ranges, and safeguard workbook integrity, ensuring data security in collaborative environments.
Recognize and utilize the SUM, AVERAGE, and COUNT functions in Excel to perform data calculations within various ranges of cells.
Demonstrate the ability to create and utilize Excel formulas using both relative and absolute cell references and properly manage order of operations using parentheses.
Analyze various financial outcomes using Excel's Scenario Manager by creating at least two different scenarios with provided data sets.
Utilize Excel's Goal Seek function to determine necessary variable adjustments to achieve a specific financial target, such as desired monthly payments.
Identify the steps required to insert an image from local storage or online into an Excel spreadsheet using the 'Insert' tab's 'Illustrations' menu.

Discover More Skills Like These

Microsoft Office Courses

Start Learning Today!

Choose from plans starting at just $16/month (billed annually)

What Others Are Saying

"Extraordinarily Helpful"

★★★★★

This course was very informative and I learned so much and I am lot more comfortable using Microsoft Excel.

Rachel S.

"Extraordinarily Helpful"

★★★★★

I thought I knew a lot about Excel until taking this course. I learned so many fun and new things. I can't wait to get creating!

Erica J.

"Extraordinarily Helpful"

★★★★★

I felt this course was very helpful for me. Not knowing anything about excel before starting the course, I feel I have a much better understanding of its functions and capabilities now. I also feel a much greater confidence in applying knowledge of this program within my skills and experience.

Tess H.

"Extraordinarily Helpful"

★★★★★

I thought this course was beneficial. I never used Excel for much more than adding and subtracting. However, I have a great new understanding of the possibilities of this program now. I have done a cool project using Excel since starting this class and am interested in going further. Thank you.

Daryl S.

Related Courses