We may earn an affiliate commission when you visit our partners.
Pluralsight logo

Excel 2019 Essentials

Bill Kulterman

In this course, Excel 2019 Essentials, you’ll learn the basics of working with Excel 2019. You’ll learn how to work with the Excel interface and begin the process of putting data into Excel and manipulating that data to gain results.

Read more

In this course, Excel 2019 Essentials, you’ll learn the basics of working with Excel 2019. You’ll learn how to work with the Excel interface and begin the process of putting data into Excel and manipulating that data to gain results.

Knowing the basics of Excel 2019 can help make you a more well rounded professional. In this course, Excel 2019 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns, and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to begin creating your own spreadsheets (and begin preparation for the Microsoft Office exams.)

Enroll now

What's inside

Syllabus

Getting to Know Excel 2019
Backstage View
Working with Worksheets and Data
Working with Rows and Columns
Read more
Formatting
Totaling Values
Saving a File

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Explores core skills in data manipulation, which is standard in data-driven industries
Develops foundational knowledge in spreadsheet modeling and analysis
In step with the Microsoft Office certification exams in this domain
Builds data manipulation skills for beginners

Save this course

Save Excel 2019 Essentials to your list so you can find it easily later:
Save

Career center

Learners who complete Excel 2019 Essentials will develop knowledge and skills that may be useful to these careers:
Data Analyst
A Data Analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. They use this information to make recommendations to businesses on how to improve their operations. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to import and export data, create and use formulas, and perform statistical analysis. This course can also help you develop the critical thinking and problem-solving skills that are essential for success in this field.
Financial Analyst
A Financial Analyst is responsible for analyzing financial data to make recommendations on investments. They use this information to help businesses make informed decisions about their financial future. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create financial models, perform financial analysis, and create charts and graphs. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Business Analyst
A Business Analyst is responsible for understanding the needs of a business and translating those needs into technical requirements. They work with stakeholders to gather requirements, analyze data, and develop solutions. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to organize and analyze data, create charts and graphs, and perform calculations. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Management Consultant
A Management Consultant is responsible for helping businesses improve their operations. They work with clients to identify problems, develop solutions, and implement those solutions. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to analyze data, create presentations, and develop financial models. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Market Researcher
A Market Researcher is responsible for collecting and analyzing data on consumer behavior. They use this information to help businesses develop products and services that meet the needs of their customers. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to design surveys, collect data, and analyze results. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Quality Assurance Analyst
A Quality Assurance Analyst is responsible for testing software to ensure that it meets the required quality standards. They work with developers to identify and fix bugs. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create test plans, track defects, and analyze data. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Project Manager
A Project Manager is responsible for planning, executing, and closing out projects. They work with teams to ensure that projects are completed on time, on budget, and to the required quality standards. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create project plans, track progress, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Sales Manager
A Sales Manager is responsible for leading and motivating a sales team. They work with sales representatives to develop sales strategies, track progress, and close deals. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create sales forecasts, track sales performance, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Product Manager
A Product Manager is responsible for developing and managing a product from concept to launch. They work with engineers, designers, and marketers to bring a product to market and ensure that it meets the needs of customers. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create product roadmaps, track progress, and analyze data. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Operations Manager
An Operations Manager is responsible for overseeing the day-to-day operations of a business. They work with employees to ensure that the business is running smoothly and efficiently. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to track inventory, create schedules, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Supply Chain Manager
A Supply Chain Manager is responsible for managing the flow of goods and services from suppliers to customers. They work with suppliers, manufacturers, and distributors to ensure that products are delivered to customers on time, on budget, and to the required quality standards. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create supply chain models, track inventory, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Teacher
A Teacher is responsible for educating students in a variety of subjects. They work with students to develop their knowledge and skills, and to prepare them for further education or employment. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create lesson plans, track student progress, and manage your classroom. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Writer
A Writer is responsible for writing and editing content for a variety of purposes, including articles, blog posts, website content, and marketing materials. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to organize your writing projects, track your progress, and manage your time. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Web Developer
A Web Developer is responsible for designing and developing websites. They work with clients to gather requirements, create mockups, and develop and test websites. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create prototypes, track progress, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Technical Writer
A Technical Writer is responsible for writing and editing technical documentation. They work with engineers and other technical experts to create user guides, manuals, and other documents that explain how to use products and services. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create tables, charts, and graphs. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.

Reading list

We've selected eight books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Excel 2019 Essentials.
Practical, step-by-step guide to using Microsoft Excel 2019. It covers all the basics, from creating and formatting spreadsheets to using formulas and functions. In addition, it provides more advanced tips and techniques for working with data in Excel.
Comprehensive reference guide to Microsoft Excel 2019. It covers everything from basic concepts to advanced techniques. It is an excellent resource for both beginners and experienced users.
Beginner-friendly guide to Microsoft Excel 2019. It covers all the basics, from creating and formatting spreadsheets to using formulas and functions. It great option for those who are new to Excel or who need a refresher.
Guide to using Visual Basic for Applications (VBA) to automate tasks in Microsoft Excel 2019. It covers all the basics, from recording macros to writing custom functions. It valuable resource for those who want to take their Excel skills to the next level.
Guide to using Microsoft Excel 2019 for data analysis and business modeling. It covers all the basics, from importing data to creating charts and graphs. It valuable resource for those who want to use Excel to make better decisions.
Guide to using PivotTables and PivotCharts in Microsoft Excel 2019. It covers all the basics, from creating a PivotTable to formatting the PivotTable. It valuable resource for those who want to use Excel to analyze data more effectively.
Guide to using macros and VBA in Microsoft Excel 2019. It covers all the basics, from recording a macro to writing a custom function. It valuable resource for those who want to take their Excel skills to the next level.
Guide to using formulas and functions in Microsoft Excel 2019. It covers all the basics, from entering a formula to using the most common functions. It valuable resource for those who want to use Excel to perform calculations more efficiently.

Share

Help others find this course page by sharing it with your friends and followers:
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser