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

Excel 2019 Pro

Bill Kulterman

In this course, you’ll learn the most advanced aspects of working with Excel 2019. Explore how to perform all sorts of useful functions, pivot tables, macros, form controls, and much more in this massive deep dive into the world of Excel 2019.

Read more

In this course, you’ll learn the most advanced aspects of working with Excel 2019. Explore how to perform all sorts of useful functions, pivot tables, macros, form controls, and much more in this massive deep dive into the world of Excel 2019.

Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll learn how to format and work with data. Then, you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros, and form controls. When you’re finished with this course, you'll have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams).

Enroll now

What's inside

Syllabus

Formatting
Working with Data
Power Query
Text Functions
Read more
Logical and Statistical Functions
Expanded Functions
Error Checking
Conditional Formatting
Charts
Pivot Tables
Advanced Options
Finalizing a Workbook
Macros
Form Controls

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Strong fit with a particular audience, either based on learner's experience level, field, or interests
Teaches skills, knowledge, and/or tools that are highly relevant to industry
Develops professional skills or deep expertise in a particular topic or set of topics
Offers a comprehensive study of one aspect of history, the arts, or the human condition
Builds a strong foundation for beginners
May require costly barriers to entry, such as subscriptions or exam fees

Save this course

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

Career center

Learners who complete Excel 2019 Pro will develop knowledge and skills that may be useful to these careers:
Business Intelligence Analyst
A Business Intelligence Analyst identifies patterns and trends to help businesses make better decisions. With the skills you learn in Excel 2019 Pro, you'll be able to analyze data, create reports, and present your findings in a clear and concise way. This course will help you build a solid foundation in the tools and techniques used by Business Intelligence Analysts, and it will prepare you for the Microsoft Office exams.
Financial Analyst
A Financial Analyst helps businesses make informed decisions about their finances. In this role, you'll use Excel 2019 to analyze financial data, create models, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Financial Analysts, and it will help you prepare for the Microsoft Office exams.
Data Analyst
A Data Analyst collects, analyzes, and interprets data to help businesses make better decisions. In this role, you'll use Excel 2019 to clean and prepare data, perform analysis, and create visualizations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Data Analysts, and it will help you prepare for the Microsoft Office exams.
Market Research Analyst
A Market Research Analyst conducts research to help businesses understand their customers and make better decisions. In this role, you'll use Excel 2019 to analyze survey data, create reports, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Market Research Analysts, and it will help you prepare for the Microsoft Office exams.
Operations Research Analyst
An Operations Research Analyst uses mathematical models to help businesses improve their operations. In this role, you'll use Excel 2019 to build and analyze models, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Operations Research Analysts, and it will help you prepare for the Microsoft Office exams.
Quantitative Analyst
A Quantitative Analyst uses mathematical and statistical models to analyze financial data and make investment decisions. In this role, you'll use Excel 2019 to build and analyze models, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Quantitative Analysts, and it will help you prepare for the Microsoft Office exams.
Risk Analyst
A Risk Analyst identifies and assesses risks to help businesses make better decisions. In this role, you'll use Excel 2019 to analyze data, create reports, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Risk Analysts, and it will help you prepare for the Microsoft Office exams.
Actuary
An Actuary uses mathematical and statistical models to assess risk and determine insurance premiums. In this role, you'll use Excel 2019 to build and analyze models, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Actuaries, and it will help you prepare for the Microsoft Office exams.
Auditor
An Auditor examines financial records to ensure accuracy and compliance with regulations. In this role, you'll use Excel 2019 to analyze data, create reports, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Auditors, and it will help you prepare for the Microsoft Office exams.
Consultant
A Consultant provides advice and expertise to businesses on a variety of topics. In this role, you'll use Excel 2019 to analyze data, create reports, and make recommendations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Consultants, and it will help you prepare for the Microsoft Office exams.
Data Scientist
A Data Scientist uses machine learning and other advanced techniques to analyze data and extract insights. In this role, you'll use Excel 2019 to clean and prepare data, perform analysis, and create visualizations. The skills you learn in Excel 2019 Pro will give you a strong foundation in the tools and techniques used by Data Scientists, but it may not be enough to prepare you for the more advanced techniques used in this field.
Software Engineer
A Software Engineer designs, develops, and tests software applications. In this role, you may use Excel 2019 to create prototypes, track bugs, and manage projects. The skills you learn in Excel 2019 Pro will give you a basic understanding of the tools and techniques used by Software Engineers, but it may not be enough to prepare you for the more advanced techniques used in this field.
Database Administrator
A Database Administrator manages and maintains databases. In this role, you may use Excel 2019 to create queries, generate reports, and manage users. The skills you learn in Excel 2019 Pro will give you a basic understanding of the tools and techniques used by Database Administrators, but it may not be enough to prepare you for the more advanced techniques used in this field.
Web Developer
A Web Developer designs and develops websites. In this role, you may use Excel 2019 to create prototypes, track bugs, and manage projects. The skills you learn in Excel 2019 Pro will give you a basic understanding of the tools and techniques used by Web Developers, but it may not be enough to prepare you for the more advanced techniques used in this field.
Project Manager
A Project Manager plans, executes, and closes projects. In this role, you may use Excel 2019 to create timelines, track budgets, and manage resources. The skills you learn in Excel 2019 Pro will give you a basic understanding of the tools and techniques used by Project Managers, but it may not be enough to prepare you for the more advanced techniques used in this field.

Reading list

We've selected nine 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 Pro.
Comprehensive guide to VBA programming in Excel 2019. It covers all the basics of VBA, as well as more advanced topics such as object-oriented programming and working with databases.
Provides a comprehensive guide to using macros and VBA in Excel 2019. It covers all the basics of macros and VBA, as well as more advanced topics such as creating user forms and working with objects.
Provides a step-by-step guide to using Excel 2019 for data analysis and business modeling. It covers all the basics of data analysis, as well as more advanced topics such as regression analysis and forecasting.
Provides a comprehensive guide to using Excel 2019 for web development purposes. It covers all the basics of Excel, as well as more advanced topics such as working with HTML and CSS.
Provides a comprehensive guide to using pivot tables and charts in Excel 2019. It covers all the basics of pivot tables and charts, as well as more advanced topics such as creating dynamic reports and using slicers.
Provides a comprehensive guide to using Excel 2019 for accounting purposes. It covers all the basics of Excel, as well as more advanced topics such as financial reporting and auditing.
Provides a comprehensive guide to using Excel 2019 for students. It covers all the basics of Excel, as well as more advanced topics such as data analysis and presentation skills.
Provides a collection of tips and tricks for using Excel 2019. It covers a wide range of topics, from basic tips to more advanced techniques.

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