OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Pluralsight logo

Excel 2016 for Power Users

Diane McSorley

Go beyond the basics in this Excel 2016 for Power Users course.

Read more

Go beyond the basics in this Excel 2016 for Power Users course.

Go beyond the basics in this Excel 2016 for Power Users course. Busy business professionals will learn how to advance their Excel 2016 skills by learning conditional formatting, functions, tables, graphics, and printing.

Enroll now

What's inside

Syllabus

Conditional Formatting
Functions
Tables
Graphics
Read more
Printing
Review

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Examines conditional formatting, functions, tables, graphics, and printing
Teaches skills useful for business professionals
Taught by Diane McSorley, who are certified Microsoft Office Master Instructor
Develops Excel skills necessary for workplace success
Does not include the latest updates of Excel

Save this course

Save Excel 2016 for Power Users to your list so you can find it easily later:
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 2016 for Power Users with these activities:
Learn how to use conditional formatting
Enhance knowledge on conditional formatting in Excel in preparation for the course.
Browse courses on Conditional Formatting
Show steps
  • Locate a tutorial on conditional formatting in Excel 2016.
  • Follow the tutorial and practice using conditional formatting on a worksheet.
  • Experiment with different formatting options to see how they affect the appearance of your data.
Create a table in Excel and perform calculations
Reinforce the concept of making calculations by creating a table in advance of taking the course.
Browse courses on Tables
Show steps
  • Open up a new workbook in Excel.
  • Create a table with at least 5 columns and 5 rows of data.
  • Perform a calculation on one of the columns, such as finding the sum or average.
Read Everything You Always Wanted to Know About Microsoft Excel
Review foundational concepts and terms found in Excel in advance of taking this course.
View Excel VBA Programming For Dummies 5th Edition... on Amazon
Show steps
  • Purchase and read the book in preparation for the course.
  • Review key terms and definitions.
  • Complete the practice exercises found in the book.
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Excel Functions Tutorial
Enhance your understanding of Excel functions by following guided tutorials that provide step-by-step instructions and examples.
Browse courses on Functions
Show steps
  • Find a reputable online tutorial or course on Excel functions.
  • Follow the tutorial and complete the exercises.
  • Apply the functions you learned to your own projects.
Create a spreadsheet that tracks your expenses
Apply Excel's functionality to create a spreadsheet to track expenses
Browse courses on Functions
Show steps
  • Create a new workbook in Excel.
  • Design a spreadsheet with columns for date, expense category, amount, and notes.
  • Enter your expenses into the spreadsheet.
  • Use formulas to calculate the total amount spent in each category and the grand total.
  • Format the spreadsheet to make it easy to read and understand.
Attend a study session with other students
Engage in peer learning activities to improve understanding
Show steps
  • Find a study partner or group.
  • Meet up regularly to discuss the course material.
  • Quiz each other on the key concepts.
  • Work together on practice problems.
Attend an Excel workshop
Enhance understanding of course materials through guided workshops
Browse courses on Excel 2016
Show steps
  • Find an Excel workshop that is offered by a local community college or training center.
  • Register for the workshop and attend all sessions.
  • Participate in the exercises and discussions.
  • Ask questions to the instructor and other participants.
Conditional Formatting Practice
Reinforce your understanding of conditional formatting by completing exercises and problems.
Browse courses on Conditional Formatting
Show steps
  • Find practice problems online or in a textbook.
  • Solve the problems using conditional formatting.
  • Check your answers against the provided solutions.
Compile a cheat sheet of Excel shortcuts
Reinforce retention of information gained during the course
Browse courses on Excel
Show steps
  • Create a new document in your preferred note-taking application.
  • List all of the Excel keyboard shortcuts that you find useful.
  • Review the cheat sheet regularly to help you remember the shortcuts.
Create a Data Visualization
Solidify your knowledge of graphics by creating a data visualization that visually represents a data set.
Browse courses on Graphics
Show steps
  • Choose a data set that you are interested in.
  • Import the data into Excel.
  • Create a chart or graph that represents the data.
  • Format the chart or graph to make it visually appealing.
  • Write a brief description of the data visualization.
Volunteer at a local organization that uses Excel
Apply understanding of Excel to real-world use cases
Browse courses on Excel
Show steps
  • Find an organization that uses Excel in their daily operations, such as a non-profit or a small business.
  • Contact the organization and inquire about volunteer opportunities.
  • Volunteer your time to help the organization with their Excel tasks.
  • Use your Excel skills to make a positive impact on the organization.

Career center

Learners who complete Excel 2016 for Power Users will develop knowledge and skills that may be useful to these careers:
Business Analyst
Business Analysts use Excel to analyze data, identify trends, and make recommendations for business improvements. This course can help Business Analysts build a strong foundation in Excel, which can help them to be more effective in their role. By taking this course, Business Analysts can develop the skills they need to help businesses make better decisions.
See salaries and explore the career path for Business Analyst
Financial Analyst
Financial Analysts use Excel to build financial models, analyze data, and make investment recommendations. This course can help Financial Analysts improve their Excel skills, which can lead to more accurate and insightful analysis. By taking this course, Financial Analysts can increase their ability to make sound investment decisions that can benefit their clients.
See salaries and explore the career path for Financial Analyst
Data Analyst
Data Analysts use data to provide valuable insights for businesses. They may use Excel to collect, clean, and analyze data. This course can help Data Analysts maximize their Excel skills and in turn, improve their analysis. By taking this course, Data Analysts can gain confidence in their ability to provide accurate and insightful data-driven recommendations.
See salaries and explore the career path for Data Analyst
Project Manager
Project Managers use Excel to track project progress, manage budgets, and communicate with stakeholders. This course can help Project Managers improve their Excel skills, which can lead to more efficient and effective project management. By taking this course, Project Managers can develop the skills they need to successfully manage projects and deliver results.
See salaries and explore the career path for Project Manager
Operations Manager
Operations Managers use Excel to track data, analyze performance, and make operational improvements. This course can help Operations Managers build a strong foundation in Excel, which can help them to be more effective in their role. By taking this course, Operations Managers can develop the skills they need to help businesses run more efficiently.
See salaries and explore the career path for Operations Manager
Marketing Analyst
Marketing Analysts use Excel to analyze marketing data, identify trends, and make recommendations for marketing campaigns. This course can help Marketing Analysts improve their Excel skills, which can lead to more effective marketing campaigns. By taking this course, Marketing Analysts can develop the skills they need to help businesses increase sales and build brand awareness.
See salaries and explore the career path for Marketing Analyst
Sales Manager
Sales Managers use Excel to track sales data, manage teams, and forecast sales. This course can help Sales Managers improve their Excel skills, which can lead to more effective sales management. By taking this course, Sales Managers can develop the skills they need to help their teams achieve sales goals.
See salaries and explore the career path for Sales Manager
Accountant
Accountants use Excel to manage financial data, prepare financial statements, and file taxes. This course can help Accountants improve their Excel skills, which can lead to more accurate and efficient accounting practices. By taking this course, Accountants can develop the skills they need to ensure that their clients' finances are in order.
See salaries and explore the career path for Accountant
Auditor
Auditors use Excel to review financial records, identify risks, and make recommendations for improvements. This course can help Auditors improve their Excel skills, which can lead to more thorough and accurate audits. By taking this course, Auditors can develop the skills they need to help businesses protect their assets and ensure compliance with regulations.
See salaries and explore the career path for Auditor
Consultant
Consultants use Excel to analyze data, identify problems, and make recommendations for solutions. This course can help Consultants improve their Excel skills, which can lead to more effective consulting services. By taking this course, Consultants can develop the skills they need to help businesses improve their operations and achieve their goals.
See salaries and explore the career path for Consultant
Data Scientist
Data Scientists use Excel to clean and analyze data, build models, and make predictions. This course may be useful for Data Scientists who want to improve their Excel skills, which can lead to more accurate and insightful analysis. By taking this course, Data Scientists can develop the skills they need to help businesses make better decisions.
See salaries and explore the career path for Data Scientist
Software Engineer
Software Engineers may use Excel to manage project data, track bugs, and communicate with team members. This course may be useful for Software Engineers who want to improve their Excel skills, which can lead to more efficient and effective software development. By taking this course, Software Engineers can develop the skills they need to help their teams deliver high-quality software products.
See salaries and explore the career path for Software Engineer
Web Developer
Web Developers may use Excel to track project data, manage tasks, and communicate with team members. This course may be useful for Web Developers who want to improve their Excel skills, which can lead to more efficient and effective web development. By taking this course, Web Developers can develop the skills they need to help their teams deliver high-quality web products.
See salaries and explore the career path for Web Developer
Graphic designer
Graphic Designers may use Excel to create and manage budgets, track project milestones, and communicate with clients. This course may be useful for Graphic Designers who want to improve their Excel skills, which can lead to more efficient and effective project management. By taking this course, Graphic Designers can develop the skills they need to help their clients achieve their marketing and advertising goals.
See salaries and explore the career path for Graphic designer
Writer
Writers may use Excel to manage their writing projects, track their progress, and communicate with editors. This course may be useful for Writers who want to improve their Excel skills, which can lead to more efficient and effective writing. By taking this course, Writers can develop the skills they need to help their clients achieve their writing goals.
See salaries and explore the career path for Writer

Reading list

We've selected ten 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 2016 for Power Users.
Cover image
Intermediate Futures And Options: An Active...
Save
Teaches how to use VBA to automate Excel tasks. It valuable resource for anyone who wants to learn how to write VBA code.
Intermediate Futures and Options: An Active...
Paperback
$$$
Cover image
Master Your Data with Power Query in Excel and...
Save
Teaches how to use Power Query and Power Pivot to analyze data in Excel. It valuable resource for anyone who wants to learn how to use these powerful tools.
Master Your Data with Power Query in Excel and...
Paperback
$$
Master Your Data with Power Query in Excel and...
Kindle Edition
$$
Cover image
Excel 2013: The Missing Manual
Save
Provides a comprehensive guide to Excel 2016, covering everything from basic to advanced features. It valuable resource for anyone who wants to learn more about Excel 2016.
Excel 2013: The Missing Manual
Paperback
$$
Excel 2013: The Missing Manual
Kindle Edition
$$
Cover image
The New Psychology of Leadership
Save
Provides an in-depth look at the inner workings of Excel 2016. It valuable resource for anyone who wants to learn how to use Excel 2016 more efficiently.
The New Psychology of Leadership: Identity,...
Paperback
$$$
Cover image
Power Excel 2016 with Mrexcel
Save
Provides a comprehensive guide to Excel 2016, covering everything from basic to advanced features. It valuable resource for anyone who wants to learn more about Excel 2016.
Power Excel with MrExcel - 2017 Edition: Master...
Paperback
$$
Cover image
Learn Excel 2016 Essential Skills with the Smart...
Save
Provides a comprehensive guide to Excel 2016, covering everything from basic to advanced features. It valuable resource for anyone who wants to learn more about Excel 2016.
Learn Excel 2016 Essential Skills with The Smart...
Kindle Edition
$
Learn Excel 2016 Essential Skills for Mac OS X with...
Kindle Edition
$$
Cover image
Excel 2016 VBA and Macros
Save
Teaches how to use VBA to automate Excel tasks. It valuable resource for anyone who wants to learn how to write VBA code.
Excel 2016 VBA and Macros (MrExcel Library)
Paperback
$$
Excel 2016 VBA and Macros (MrExcel Library)
Kindle Edition
$$
Cover image
Microsoft Excel Data Analysis and Business Modeling...
Save
Teaches how to use Excel 2016 to perform business analysis and financial modeling. It valuable resource for anyone who wants to learn how to use Excel 2016 for these purposes.
Microsoft Excel Data Analysis and Business Modeling...
Paperback
$$
Microsoft Excel Data Analysis and Business Modeling...
Kindle Edition
$$
Cover image
Statistical Analysis with Excel For Dummies
Save
Teaches how to use Excel 2016 to perform statistical and data analysis. It valuable resource for anyone who wants to learn how to use Excel 2016 for these purposes.
Statistical Analysis with Excel For Dummies (For...
Paperback
$$
Statistical Analysis with Excel For Dummies, 4th...
Paperback
$$
Statistical Analysis with Excel For Dummies
Paperback
$$
Statistical Analysis with Excel For Dummies
Paperback
$$
Statistical Analysis with Excel For Dummies by...
Paperback
$$
Statistical Analysis with Excel For Dummies
Kindle Edition
$$
Cover image
MOS 2016 Study Guide for Microsoft Excel Expert
Save
Provides a comprehensive guide to Excel 2016, covering everything from basic to advanced features. It valuable resource for anyone who wants to learn more about Excel 2016.
MOS 2016 Study Guide for Microsoft Excel Expert...
Paperback
$$
MOS 2016 Study Guide for Microsoft Excel Expert...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Excel 2016 for Power Users.
Word 2016 for Power Users
Most relevant
Microsoft Excel: Data Visualization, Excel Charts & Graphs
Business Intelligence Workflow with Excel 2019
Excel Power Tools for Data Analysis
Excel 2021 Power Users
Excel 2019 Power Users
Excel Crash Course: Master Excel for Financial Analysis
Microsoft Excel - Excel from Beginner to Advanced
Monitoring, Troubleshooting, and Optimizing SharePoint...
Course image
Time
198 hours
Level
Intermediate
Via
Pluralsight
Instructor
Diane McSorley
Language
English
This course belongs to a collection called Using Microsoft Office 2016. It's comprised of 15 courses:
  1. What's New in Office 2016
  2. Microsoft Word (2016): Essentials
  3. Excel 2016 for Windows and Mac: Essentials
  4. Using Office PowerPoint (2016)
  5. Using Outlook (2016)
  6. OneNote 2016
  7. Microsoft Access (2016)
  8. Project 2016 for Business Professionals
  9. Using Publisher 2016
  10. Using Visio (2016)
  11. Using Office Sway (2016)
  12. Using Office Delve 365 (2016)
  13. Using Skype for Business
  14. Word 2016 for Power Users
  15. Excel 2016 for Power Users (viewing)
Good to know
Examines conditional formatting, functions, tables, graphics, and printing
Teaches skills useful for business professionals
Taught by Diane McSorley, who are certified Microsoft Office Master Instructor
Develops Excel skills necessary for workplace success
Does not include the latest updates of Excel
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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