We may earn an affiliate commission when you visit our partners.
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.
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).
Register for this course and see more details by visiting:
OpenCourser.com/course/f3lzx4/excel
What's inside
Syllabus
Formatting
Working with Data
Power Query
Text Functions
Read more
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
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
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Excel 2019 Pro with these
activities:
Read 'Excel 2019 Bible'
Show steps
Expand knowledge and gain insights by reviewing a comprehensive reference book on Excel.
View
Microsoft Excel 365 Bible
on Amazon
Show steps
-
Acquire a copy of 'Excel 2019 Bible'
-
Read through the chapters relevant to the course material
-
Take notes and highlight important concepts
Review Functions and Pivot Tables in Excel
Show steps
This activity will help you refresh your understanding of functions and pivot tables, which are fundamental skills for this course.
Browse courses on
Functions
Show steps
-
Review the syntax and usage of common functions, such as SUM, AVERAGE, and COUNT
-
Create a pivot table to summarize and analyze data
Try out spreadsheet data management operations
Show steps
Reinforce knowledge of basic spreadsheet data manipulation and formatting to strengthen foundational understanding.
Browse courses on
Data Analysis Tools
Show steps
-
Create a new spreadsheet in your favorite program
-
Import some data from the web or a file
-
Practice sorting, filtering, and formatting the data
-
Use formulas and functions to perform basic calculations
13 other activities
Expand to see all activities and additional details
Show all 16 activities
Complete Excel Practice Exercises
Show steps
Solving Excel practice exercises will help you apply your knowledge of functions, pivot tables, and other techniques to real-world scenarios.
Show steps
-
Find a collection of Excel practice exercises online or in a workbook
-
Solve the exercises, checking your answers against the provided solutions
Follow Excel tutorial on conditional formatting
Show steps
Improve proficiency in using conditional formatting to enhance visual representation of data.
Browse courses on
Conditional Formatting
Show steps
-
Find a tutorial on conditional formatting in Excel
-
Follow the steps in the tutorial to create a conditional formatting rule
-
Apply the rule to your own data
Create formulas using Excel functions
Show steps
Enhance proficiency in using Excel functions to perform complex calculations and automate tasks.
Browse courses on
Functions
Show steps
-
Review the different types of functions available in Excel
-
Practice using functions to perform basic calculations
-
Use functions to create more complex formulas
Practice Excel formulas
Show steps
Continuously practice writing and applying formulas will help you improve your proficiency in Excel.
Browse courses on
Advanced Excel Functions
Show steps
-
Download or set up a practice workbook
-
Practice writing formulas in a spreadsheet
-
Review your work and correct errors
Follow Excel Advanced Techniques Tutorials
Show steps
Watching tutorials can provide you with additional guidance and examples on how to use advanced Excel techniques.
Show steps
-
Search for tutorials on advanced Excel techniques, such as macros or conditional formatting
-
Follow the tutorials step-by-step and practice the techniques you learn
Assist peers with Excel questions
Show steps
Solidify understanding by explaining concepts and providing guidance to others seeking help with Excel.
Browse courses on
Form Controls
Show steps
-
Identify a peer or colleague who is struggling with Excel
-
Offer assistance and explain concepts clearly
-
Provide guidance and support
Create an Excel Workbook to Analyze Your Own Data
Show steps
Creating your own Excel workbook will allow you to apply your skills to a practical problem and enhance your understanding of data analysis.
Show steps
-
Gather a dataset that is relevant to your interests or work
-
Import the data into Excel and clean it
-
Use Excel techniques to analyze the data and extract insights
Develop an advanced spreadsheet model
Show steps
Test and apply knowledge of advanced Excel features by creating a comprehensive spreadsheet model that solves a real-world problem or task.
Browse courses on
Charts
Show steps
-
Identify a problem or task that can be solved using an advanced spreadsheet model
-
Design the model, including the layout, formulas, and functions to be used
-
Develop and test the model
-
Refine and document the model
Participate in an Excel Competition or Hackathon
Show steps
Participating in competitions will challenge you to apply your Excel skills under pressure and learn from others.
Show steps
-
Find an Excel competition or hackathon that aligns with your interests
-
Register for the competition and prepare your skills
-
Compete in the event and try your best
Organize a study group focused on advanced Excel
Show steps
Deepen understanding through collaborative learning and exchange of knowledge with peers.
Show steps
-
Identify a group of peers who are interested in forming a study group
-
Establish a regular meeting schedule
-
Decide on topics to cover each session
-
Meet regularly to discuss the material
Mentor a Beginner in Excel
Show steps
Mentoring others will help you reinforce your understanding of Excel techniques and develop your communication skills.
Show steps
-
Find a beginner who is interested in learning Excel
-
Meet with them regularly to help them learn Excel concepts and techniques
Build an Excel dashboard for data visualization
Show steps
Apply and integrate skills in a practical project to create a data visualization tool that enhances decision-making.
Browse courses on
Charts
Show steps
-
Identify a dataset that needs better visualization
-
Design the dashboard layout and choose appropriate charts and graphs
-
Create the dashboard using Excel features
-
Test and refine the dashboard
Contribute to an Open-Source Excel Project
Show steps
Contributing to an open-source project will expose you to real-world Excel development practices and enhance your programming skills.
Show steps
-
Find an open-source Excel project that interests you
-
Review the project's documentation and codebase
-
Make a contribution to the project, such as fixing a bug or adding a new feature
Read 'Excel 2019 Bible'
Show steps
Expand knowledge and gain insights by reviewing a comprehensive reference book on Excel.
View
Microsoft Excel 365 Bible
on Amazon
Show steps
Show steps
Show steps
- Acquire a copy of 'Excel 2019 Bible'
- Read through the chapters relevant to the course material
- Take notes and highlight important concepts
Review Functions and Pivot Tables in Excel
Show steps
This activity will help you refresh your understanding of functions and pivot tables, which are fundamental skills for this course.
Browse courses on
Functions
Show steps
Show steps
Show steps
- Review the syntax and usage of common functions, such as SUM, AVERAGE, and COUNT
- Create a pivot table to summarize and analyze data
Try out spreadsheet data management operations
Show steps
Reinforce knowledge of basic spreadsheet data manipulation and formatting to strengthen foundational understanding.
Browse courses on
Data Analysis Tools
Show steps
Show steps
Show steps
- Create a new spreadsheet in your favorite program
- Import some data from the web or a file
- Practice sorting, filtering, and formatting the data
- Use formulas and functions to perform basic calculations
13 other activities
Expand to see all activities and additional details
Show all 16 activities
Complete Excel Practice Exercises
Show steps
Solving Excel practice exercises will help you apply your knowledge of functions, pivot tables, and other techniques to real-world scenarios.
Show steps
Show steps
Show steps
- Find a collection of Excel practice exercises online or in a workbook
- Solve the exercises, checking your answers against the provided solutions
Follow Excel tutorial on conditional formatting
Show steps
Improve proficiency in using conditional formatting to enhance visual representation of data.
Browse courses on
Conditional Formatting
Show steps
Show steps
Show steps
- Find a tutorial on conditional formatting in Excel
- Follow the steps in the tutorial to create a conditional formatting rule
- Apply the rule to your own data
Create formulas using Excel functions
Show steps
Enhance proficiency in using Excel functions to perform complex calculations and automate tasks.
Browse courses on
Functions
Show steps
Show steps
Show steps
- Review the different types of functions available in Excel
- Practice using functions to perform basic calculations
- Use functions to create more complex formulas
Practice Excel formulas
Show steps
Continuously practice writing and applying formulas will help you improve your proficiency in Excel.
Browse courses on
Advanced Excel Functions
Show steps
Show steps
Show steps
- Download or set up a practice workbook
- Practice writing formulas in a spreadsheet
- Review your work and correct errors
Follow Excel Advanced Techniques Tutorials
Show steps
Watching tutorials can provide you with additional guidance and examples on how to use advanced Excel techniques.
Show steps
Show steps
Show steps
- Search for tutorials on advanced Excel techniques, such as macros or conditional formatting
- Follow the tutorials step-by-step and practice the techniques you learn
Assist peers with Excel questions
Show steps
Solidify understanding by explaining concepts and providing guidance to others seeking help with Excel.
Browse courses on
Form Controls
Show steps
Show steps
Show steps
- Identify a peer or colleague who is struggling with Excel
- Offer assistance and explain concepts clearly
- Provide guidance and support
Create an Excel Workbook to Analyze Your Own Data
Show steps
Creating your own Excel workbook will allow you to apply your skills to a practical problem and enhance your understanding of data analysis.
Show steps
Show steps
Show steps
- Gather a dataset that is relevant to your interests or work
- Import the data into Excel and clean it
- Use Excel techniques to analyze the data and extract insights
Develop an advanced spreadsheet model
Show steps
Test and apply knowledge of advanced Excel features by creating a comprehensive spreadsheet model that solves a real-world problem or task.
Browse courses on
Charts
Show steps
Show steps
Show steps
- Identify a problem or task that can be solved using an advanced spreadsheet model
- Design the model, including the layout, formulas, and functions to be used
- Develop and test the model
- Refine and document the model
Participate in an Excel Competition or Hackathon
Show steps
Participating in competitions will challenge you to apply your Excel skills under pressure and learn from others.
Show steps
Show steps
Show steps
- Find an Excel competition or hackathon that aligns with your interests
- Register for the competition and prepare your skills
- Compete in the event and try your best
Organize a study group focused on advanced Excel
Show steps
Deepen understanding through collaborative learning and exchange of knowledge with peers.
Show steps
Show steps
Show steps
- Identify a group of peers who are interested in forming a study group
- Establish a regular meeting schedule
- Decide on topics to cover each session
- Meet regularly to discuss the material
Mentor a Beginner in Excel
Show steps
Mentoring others will help you reinforce your understanding of Excel techniques and develop your communication skills.
Show steps
Show steps
Show steps
- Find a beginner who is interested in learning Excel
- Meet with them regularly to help them learn Excel concepts and techniques
Build an Excel dashboard for data visualization
Show steps
Apply and integrate skills in a practical project to create a data visualization tool that enhances decision-making.
Browse courses on
Charts
Show steps
Show steps
Show steps
- Identify a dataset that needs better visualization
- Design the dashboard layout and choose appropriate charts and graphs
- Create the dashboard using Excel features
- Test and refine the dashboard
Contribute to an Open-Source Excel Project
Show steps
Contributing to an open-source project will expose you to real-world Excel development practices and enhance your programming skills.
Show steps
Show steps
Show steps
- Find an open-source Excel project that interests you
- Review the project's documentation and codebase
- Make a contribution to the project, such as fixing a bug or adding a new feature
Career center
Learners who complete Excel 2019 Pro will develop knowledge and skills
that may be useful to these careers:
Business Intelligence Analyst
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
For more career information including salaries, visit:
OpenCourser.com/course/f3lzx4/excel
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 Excel 2019 for developers. It covers all the basics of Excel, as well as more advanced topics such as working with XML and using the Excel object model.
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.
Save
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/f3lzx4/excel
Share
Similar courses
Here are nine courses similar to
Excel 2019 Pro.
Excel 365 Pro
OpenCourser.com/course/we239c/excel
Excel 365 Pro
Most relevant
Excel 2021 Pro
OpenCourser.com/course/6vpvfp/excel
Excel 2021 Pro
Most relevant
Excel 2019 Power Users
OpenCourser.com/course/ncsrxi/excel
Excel 2019 Power Users
Most relevant
Formatting Excel Objects
OpenCourser.com/course/5m6gbp/formatting
Formatting Excel Objects
Most relevant
Recording and Managing Excel 2016 Macros
OpenCourser.com/course/ec8noh/recording
Recording and Managing Excel 2016 Macros
Most relevant
Outlook 2019 Essentials
OpenCourser.com/course/c04inl/outlook
Outlook 2019 Essentials
Most relevant
Access 2019 Pro
OpenCourser.com/course/wjpa5y/access
Access 2019 Pro
Most relevant
Excel for Everyone: Data Analysis Fundamentals
OpenCourser.com/course/gygo4n/excel
Excel for Everyone: Data Analysis Fundamentals
Most relevant
Mastering Data Analysis in Excel
OpenCourser.com/course/yy8f86/mastering
Mastering Data Analysis in Excel
Most relevant
Time
321 hours
Level
Advanced
Via
Pluralsight
Instructor
Bill Kulterman
Language
English
Good to know
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
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