We may earn an affiliate commission when you visit our partners.
Bill Kulterman
In Excel 2019 Power Users you’ll learn more advanced aspects of working with Excel 2019. Through this course you’ll learn how to format your data, work with workbooks and worksheets, print, begin work with tables, and use a few advanced functions.
Read more
In Excel 2019 Power Users you’ll learn more advanced aspects of working with Excel 2019. Through this course you’ll learn how to format your data, work with workbooks and worksheets, print, begin work with tables, and use a few advanced functions.
Read more
In Excel 2019 Power Users you’ll learn more advanced aspects of working with Excel 2019. Through this course you’ll learn how to format your data, work with workbooks and worksheets, print, begin work with tables, and use a few advanced functions.
Learn more advanced aspects of Excel 2019. In this course, Excel 2019 Power Users, you will take your knowledge to the next level. First, you will learn how to format cells with borders, styles, shapes, and more. Next, you’ll discover how to work with workbooks, worksheets, and data. Then you’ll see more about printing workbooks (in whole or parts). Finally, you’ll explore a few advanced functions. When you’re finished with this course, you will 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/ncsrxi/excel
What's inside
Syllabus
Formatting Data
Working with Workbooks and Worksheets
Working with Data
Printing a Workbook
Read more
Syllabus
Formatting Data
Working with Workbooks and Worksheets
Working with Data
Printing a Workbook
Read more
Working with Tables
Working with Advanced Function
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Develops advanced Excel skills which can help prepare you for the Microsoft Office exams
For students with foundational Excel knowledge looking to enhance their skills
Delivers practical knowledge and skills in data formatting and working with workbooks and worksheets
Provides instruction on printing, working with tables, and utilizing advanced functions
Requires prior knowledge of Excel, which may limit accessibility
Save this course
Save Excel 2019 Power Users 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 Power Users with these
activities:
Find a Mentor in the Advanced Excel Field
Show steps
Finding a mentor can provide you with guidance and support as you develop your advanced Excel skills.
Browse courses on
Mentorship
Show steps
-
Identify potential mentors in your network or through online platforms.
-
Reach out to potential mentors and express your interest in their guidance.
-
Establish a mentoring relationship and set clear goals.
-
Meet regularly with your mentor for guidance and support.
Read and summarize: Essential Excel Skills for Business Analysis
Show steps
This book provides a deep dive into advanced Excel skills that build on the foundation of Excel 2019 Power Users. Reading this book will strengthen your grasp of Excel functions.
View
Excel VBA Programming For Dummies 5th Edition...
on Amazon
Show steps
-
Purchase and read Essential Excel Skills for Business Analysis.
-
Summarize each chapter in your own words.
-
Identify and list key takeaways from each chapter.
Join a Study Group for Advanced Excel Users
Show steps
Joining a study group will provide you with opportunities to discuss and practice advanced Excel skills with your peers.
Show steps
-
Find or create a study group for advanced Excel users.
-
Meet regularly to discuss course material and work on projects together.
-
Share your knowledge and expertise with other members of the group.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Complete Data Analysis Drills
Show steps
These drills will provide practice with advanced data analysis functions in Excel. This will reinforce the concepts learned in Excel 2019 Power Users.
Browse courses on
Data Analysis
Show steps
-
Find and access data analysis drills online or in textbooks.
-
Complete at least 10 drills.
-
Review your answers and identify areas for improvement.
Start a Personal Excel Project
Show steps
Starting a personal Excel project will provide you with an opportunity to explore your interests and apply your advanced Excel skills in a meaningful way.
Show steps
-
Identify your interests and brainstorm project ideas.
-
Choose a project that aligns with your goals and skill level.
-
Plan and outline your project.
-
Implement your project and track your progress.
-
Evaluate your project and identify areas for improvement.
Develop an Excel-Based Data Analysis Tool
Show steps
Developing an Excel-based data analysis tool will allow you to apply your advanced Excel skills to solve a real-world problem.
Show steps
-
Identify a business problem that can be solved using Excel.
-
Design and develop an Excel-based tool to solve the problem.
-
Test and refine your tool to ensure accuracy and efficiency.
-
Present your tool to stakeholders and get feedback.
Create a Video Tutorial on Advanced Excel Functions
Show steps
Creating a video tutorial will help you solidify your understanding of advanced Excel functions and improve your communication skills.
Browse courses on
Excel Functions
Show steps
-
Choose a specific advanced Excel function to focus on.
-
Write a script for your video tutorial.
-
Record and edit your video.
-
Publish your video on a platform like YouTube or LinkedIn Learning.
Participate in an Excel Skills Competition
Show steps
Participating in a competition will push you to master advanced Excel skills and demonstrate your proficiency.
Browse courses on
Competition
Show steps
-
Find an Excel skills competition to participate in.
-
Prepare for the competition by practicing your skills.
-
Compete in the competition and give your best effort.
-
Reflect on your performance and identify areas for improvement.
Find a Mentor in the Advanced Excel Field
Show steps
Finding a mentor can provide you with guidance and support as you develop your advanced Excel skills.
Browse courses on
Mentorship
Show steps
Show steps
Show steps
- Identify potential mentors in your network or through online platforms.
- Reach out to potential mentors and express your interest in their guidance.
- Establish a mentoring relationship and set clear goals.
- Meet regularly with your mentor for guidance and support.
Read and summarize: Essential Excel Skills for Business Analysis
Show steps
This book provides a deep dive into advanced Excel skills that build on the foundation of Excel 2019 Power Users. Reading this book will strengthen your grasp of Excel functions.
View
Excel VBA Programming For Dummies 5th Edition...
on Amazon
Show steps
Show steps
Show steps
- Purchase and read Essential Excel Skills for Business Analysis.
- Summarize each chapter in your own words.
- Identify and list key takeaways from each chapter.
Join a Study Group for Advanced Excel Users
Show steps
Joining a study group will provide you with opportunities to discuss and practice advanced Excel skills with your peers.
Show steps
Show steps
Show steps
- Find or create a study group for advanced Excel users.
- Meet regularly to discuss course material and work on projects together.
- Share your knowledge and expertise with other members of the group.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Complete Data Analysis Drills
Show steps
These drills will provide practice with advanced data analysis functions in Excel. This will reinforce the concepts learned in Excel 2019 Power Users.
Browse courses on
Data Analysis
Show steps
Show steps
Show steps
- Find and access data analysis drills online or in textbooks.
- Complete at least 10 drills.
- Review your answers and identify areas for improvement.
Start a Personal Excel Project
Show steps
Starting a personal Excel project will provide you with an opportunity to explore your interests and apply your advanced Excel skills in a meaningful way.
Show steps
Show steps
Show steps
- Identify your interests and brainstorm project ideas.
- Choose a project that aligns with your goals and skill level.
- Plan and outline your project.
- Implement your project and track your progress.
- Evaluate your project and identify areas for improvement.
Develop an Excel-Based Data Analysis Tool
Show steps
Developing an Excel-based data analysis tool will allow you to apply your advanced Excel skills to solve a real-world problem.
Show steps
Show steps
Show steps
- Identify a business problem that can be solved using Excel.
- Design and develop an Excel-based tool to solve the problem.
- Test and refine your tool to ensure accuracy and efficiency.
- Present your tool to stakeholders and get feedback.
Create a Video Tutorial on Advanced Excel Functions
Show steps
Creating a video tutorial will help you solidify your understanding of advanced Excel functions and improve your communication skills.
Browse courses on
Excel Functions
Show steps
Show steps
Show steps
- Choose a specific advanced Excel function to focus on.
- Write a script for your video tutorial.
- Record and edit your video.
- Publish your video on a platform like YouTube or LinkedIn Learning.
Participate in an Excel Skills Competition
Show steps
Participating in a competition will push you to master advanced Excel skills and demonstrate your proficiency.
Browse courses on
Competition
Show steps
Show steps
Show steps
- Find an Excel skills competition to participate in.
- Prepare for the competition by practicing your skills.
- Compete in the competition and give your best effort.
- Reflect on your performance and identify areas for improvement.
Career center
Learners who complete Excel 2019 Power Users will develop knowledge and skills
that may be useful to these careers:
Financial Analyst
Financial Analyst
Financial Analysts use their knowledge of financial data to make investment recommendations. This course can help Financial Analysts by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Financial Analysts who want to be able to effectively communicate their findings to stakeholders.
Data Engineer
Data Engineer
Data Engineers use their knowledge of data engineering to solve problems. This course can help Data Engineers by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Data Engineers who want to be able to effectively communicate their findings to stakeholders.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts use their knowledge of business intelligence to solve problems. This course can help Business Intelligence Analysts by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Business Intelligence Analysts who want to be able to effectively communicate their findings to stakeholders.
Market Researcher
Market Researcher
Market Researchers use their knowledge of market data to identify and solve problems. This course can help Market Researchers by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Market Researchers who want to be able to effectively communicate their findings to stakeholders.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use their knowledge of mathematics and statistics to solve problems. This course can help Operations Research Analysts by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Operations Research Analysts who want to be able to effectively communicate their findings to stakeholders.
Statistician
Statistician
Statisticians use their knowledge of statistics to collect, analyze, and interpret data. This course can help Statisticians by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Statisticians who want to be able to effectively communicate their findings to stakeholders.
Data Scientist
Data Scientist
Data Scientists use their knowledge of data science to solve problems. This course can help Data Scientists by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Data Scientists who want to be able to effectively communicate their findings to stakeholders.
Data Analyst
Data Analyst
Data Analysts use their knowledge of data analysis to transform raw data into insights that can help businesses make better decisions. This course can help Data Analysts by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Data Analysts who want to be able to effectively communicate their findings to stakeholders.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers use their knowledge of machine learning to solve problems. This course can help Machine Learning Engineers by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Machine Learning Engineers who want to be able to effectively communicate their findings to stakeholders.
Business Analyst
Business Analyst
Business Analysts use their knowledge of business processes to identify and solve problems. This course can help Business Analysts by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Business Analysts who want to be able to effectively communicate their findings to stakeholders.
Systems Analyst
Systems Analyst
Systems Analysts use their knowledge of systems analysis to solve problems. This course can help Systems Analysts by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Systems Analysts who want to be able to effectively communicate their findings to stakeholders.
Software Engineer
Software Engineer
Software Engineers use their knowledge of software engineering to solve problems. This course can help Software Engineers by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Software Engineers who want to be able to effectively communicate their findings to stakeholders.
Database Administrator
Database Administrator
Database Administrators use their knowledge of database administration to solve problems. This course can help Database Administrators by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Database Administrators who want to be able to effectively communicate their findings to stakeholders.
Web Developer
Web Developer
Web Developers use their knowledge of web development to solve problems. This course can help Web Developers by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Web Developers who want to be able to effectively communicate their findings to stakeholders.
Project Manager
Project Manager
Project Managers use their knowledge of project management to solve problems. This course can help Project Managers by providing them with the skills they need to format and analyze data, as well as work with advanced functions. These skills are essential for Project Managers who want to be able to effectively communicate their findings to stakeholders.
For more career information including salaries, visit:
OpenCourser.com/course/ncsrxi/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 Power Users.
Save
Provides a comprehensive overview of Excel 2019, covering a wide range of topics from basic to advanced. It would be a valuable reference for anyone looking to learn more about Excel 2019.
Provides a solid foundation in data analysis and business modeling using Excel 2019. It covers a wide range of topics, from data cleaning and preparation to statistical analysis and forecasting.
Provides a comprehensive overview of formulas and functions in Excel 2019. It covers a wide range of topics, from basic to advanced functions.
Provides a comprehensive overview of macros and VBA in Excel 2019. It covers a wide range of topics, from basic to advanced VBA programming.
Good choice for those who want to learn how to use VBA to automate tasks in Excel 2019. It provides a comprehensive overview of VBA, from basic to advanced topics.
Provides a comprehensive guide to creating pivot tables and charts in Excel 2019. It covers a wide range of topics, from data preparation to data analysis.
Provides a comprehensive guide to using Power BI in Excel 2019. It covers a wide range of topics, from data modeling to data visualization.
Provides a comprehensive guide to using Power Query in Excel 2019. It covers a wide range of topics, from data import to data transformation.
Provides a comprehensive guide to creating dashboards and reports in Excel 2019. It covers a wide range of topics, from data visualization to data analysis.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/ncsrxi/excel
Share
Similar courses
Here are nine courses similar to
Excel 2019 Power Users.
Excel 2021 Power Users
OpenCourser.com/course/j3xia7/excel
Excel 2021 Power Users
Most relevant
Excel 2019 Pro
OpenCourser.com/course/f3lzx4/excel
Excel 2019 Pro
Most relevant
Formatting Excel Objects
OpenCourser.com/course/5m6gbp/formatting
Formatting Excel Objects
Most relevant
Excel 2019 Essentials
OpenCourser.com/course/j8rj2e/excel
Excel 2019 Essentials
Most relevant
Formatting Excel 2016 Worksheets and Cells
OpenCourser.com/course/yzl4f0/formatting
Formatting Excel 2016 Worksheets and Cells
Most relevant
Excel for Everyone: Data Management
OpenCourser.com/course/0eh2rj/excel
Excel for Everyone: Data Management
Most relevant
Distributing Excel Workbooks
OpenCourser.com/course/dgatop/distributing
Distributing Excel Workbooks
Most relevant
Excel for Everyone: Data Analysis Fundamentals
OpenCourser.com/course/gygo4n/excel
Excel for Everyone: Data Analysis Fundamentals
Most relevant
Microsoft Excel - Excel with The Ultimate Excel Course
OpenCourser.com/course/yrcow5/microsoft
Microsoft Excel - Excel with The Ultimate Excel Course
Most relevant
Time
207 hours
Level
Intermediate
Via
Pluralsight
Instructor
Bill Kulterman
Language
English
Good to know
Develops advanced Excel skills which can help prepare you for the Microsoft Office exams
For students with foundational Excel knowledge looking to enhance their skills
Delivers practical knowledge and skills in data formatting and working with workbooks and worksheets
Provides instruction on printing, working with tables, and utilizing advanced functions
Requires prior knowledge of Excel, which may limit accessibility
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