We may earn an affiliate commission when you visit our partners.
Bob Flisser
If you're new to Excel or need a refresher, this course will get you up to speed so you can be proficient quickly.
Learn the fundamentals of using and creating Excel spreadsheets, including entering and editing data, managing lists, writing formulas and using functions, formatting sheets, and printing your work.
Register for this course and see more details by visiting:
OpenCourser.com/course/fjr71z/excel
What's inside
Syllabus
Getting Acquainted with Excel
Data Entry Techniques
Managing Lists with Excel 2016
Calculating with Formulas and Functions
Read more
Syllabus
Getting Acquainted with Excel
Data Entry Techniques
Managing Lists with Excel 2016
Calculating with Formulas and Functions
Read more
Formatting Worksheets
Printing Worksheets
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Provides foundational Excel skills for complete beginners
Builds a foundation for learners interested in deeper Excel study
Covers core Excel functions used across industries
Instructed by Bob Flisser, recognized for expertise in Excel training
Save this course
Save Excel 2016 for Windows and Mac: Essentials 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 2016 for Windows and Mac: Essentials with these
activities:
Data Entry and Analysis Support
Show steps
Gain practical experience by volunteering your Excel skills to assist organizations or individuals.
Browse courses on
Data Entry
Show steps
-
Identify organizations or projects seeking volunteers for data-related tasks
-
Offer your services and demonstrate your Excel proficiency
-
Collaborate on data entry, analysis, or spreadsheet-based projects
Excel Fundamentals Refresher
Show steps
Brush up on essential spreadsheet skills for optimal performance in this course.
Browse courses on
Excel
Show steps
-
Review basic spreadsheet concepts and terminology
-
Create and format a simple spreadsheet
-
Enter and edit data in cells
-
Apply basic formulas and functions
Excel Peer Mentoring
Show steps
Enhance your understanding by mentoring other students and reinforcing your Excel knowledge.
Show steps
-
Identify opportunities to assist peers with Excel-related tasks
-
Provide guidance and support on specific Excel concepts and techniques
-
Collaborate on projects or assignments to share knowledge and expertise
One other activity
Expand to see all activities and additional details
Show all four activities
Advanced Excel Features Tutorial
Show steps
Expand your Excel knowledge and master advanced techniques to enhance your proficiency.
Browse courses on
Advanced Excel Functions
Show steps
-
Identify suitable Excel functions for data manipulation and analysis
-
Apply advanced formatting options for data presentation
-
Create and utilize pivot tables for data summarization
-
Explore macros for automating repetitive tasks
Data Entry and Analysis Support
Show steps
Gain practical experience by volunteering your Excel skills to assist organizations or individuals.
Browse courses on
Data Entry
Show steps
Show steps
Show steps
- Identify organizations or projects seeking volunteers for data-related tasks
- Offer your services and demonstrate your Excel proficiency
- Collaborate on data entry, analysis, or spreadsheet-based projects
Excel Fundamentals Refresher
Show steps
Brush up on essential spreadsheet skills for optimal performance in this course.
Browse courses on
Excel
Show steps
Show steps
Show steps
- Review basic spreadsheet concepts and terminology
- Create and format a simple spreadsheet
- Enter and edit data in cells
- Apply basic formulas and functions
Excel Peer Mentoring
Show steps
Enhance your understanding by mentoring other students and reinforcing your Excel knowledge.
Show steps
Show steps
Show steps
- Identify opportunities to assist peers with Excel-related tasks
- Provide guidance and support on specific Excel concepts and techniques
- Collaborate on projects or assignments to share knowledge and expertise
One other activity
Expand to see all activities and additional details
Show all four activities
Advanced Excel Features Tutorial
Show steps
Expand your Excel knowledge and master advanced techniques to enhance your proficiency.
Browse courses on
Advanced Excel Functions
Show steps
Show steps
Show steps
- Identify suitable Excel functions for data manipulation and analysis
- Apply advanced formatting options for data presentation
- Create and utilize pivot tables for data summarization
- Explore macros for automating repetitive tasks
Career center
Learners who complete Excel 2016 for Windows and Mac: Essentials will develop knowledge and skills
that may be useful to these careers:
Financial Analyst
Financial Analyst
Financial Analysts use Excel extensively to analyze financial data and make recommendations. This course will provide you with the skills needed to build sound Excel models and analyze financial information. The course covers a range of topics, from data entry and management to formula writing and formatting. As an added bonus, the course also provides guidance on printing worksheets, which is a crucial skill for any financial analyst.
Data Analyst
Data Analyst
Data Analysts use Excel to clean, organize, and analyze data. This course will help you develop the skills necessary to perform these essential tasks. The course covers a wide range of topics, from data entry and management to formula writing and formatting. Furthermore, the course also provides guidance on printing worksheets, which is a skill often used by data analysts when sharing their findings.
Business Analyst
Business Analyst
Business Analysts use Excel to create financial models, analyze data, and make recommendations. This course will provide you with the skills needed to perform these tasks effectively. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a crucial skill for presenting findings to stakeholders.
Accountant
Accountant
Accountants use Excel to manage financial data and prepare financial statements. This course will teach you the basics of using Excel for accounting purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. By the end of the course, you will be able to use Excel to perform basic accounting tasks.
Marketing Manager
Marketing Manager
Marketing Managers use Excel to track data and measure the effectiveness of marketing campaigns. This course will provide you with the skills needed to use Excel for marketing purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by marketing managers when presenting their findings.
Project Manager
Project Manager
Project Managers use Excel to track progress and manage resources. This course will provide you with the skills needed to use Excel for project management purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by project managers when sharing their plans and progress.
Operations Manager
Operations Manager
Operations Managers use Excel to track data and improve efficiency. This course will provide you with the skills needed to use Excel for operations management purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by operations managers when sharing their findings.
Sales Manager
Sales Manager
Sales Managers use Excel to track data and manage sales teams. This course will provide you with the skills needed to use Excel for sales management purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by sales managers when sharing their findings.
Customer Service Manager
Customer Service Manager
Customer Service Managers use Excel to track data and manage customer service teams. This course will provide you with the skills needed to use Excel for customer service management purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by customer service managers when sharing their findings.
Human Resources Manager
Human Resources Manager
Human Resources Managers use Excel to track data and manage human resources teams. This course will provide you with the skills needed to use Excel for human resources management purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by human resources managers when sharing their findings.
Office Manager
Office Manager
Office Managers use Excel to track data and manage office operations. This course will provide you with the skills needed to use Excel for office management purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by office managers when sharing their findings.
Executive Assistant
Executive Assistant
Executive Assistants use Excel to track data and manage their executive's schedules. This course will provide you with the skills needed to use Excel for executive assistant purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by executive assistants when sharing their findings.
Administrative Assistant
Administrative Assistant
Administrative Assistants use Excel to track data and manage their day-to-day tasks. This course will provide you with the skills needed to use Excel for administrative assistant purposes. The course covers a range of topics, from data entry and management to formula writing and formatting. Additionally, the course also provides guidance on printing worksheets, which is a skill often used by administrative assistants when sharing their findings.
Receptionist
Receptionist
Receptionists use Excel to track data and manage their day-to-day tasks. This course may provide you with some useful skills for using Excel in a receptionist role, such as data entry and management. However, the course does not cover some of the more advanced skills that are often used by receptionists, such as formula writing and formatting.
Data Entry Clerk
Data Entry Clerk
Data Entry Clerks use Excel to enter data into spreadsheets. This course will provide you with the basic skills needed to use Excel for data entry purposes. The course covers a range of topics, from data entry and management to formula writing and formatting.
For more career information including salaries, visit:
OpenCourser.com/course/fjr71z/excel
Reading list
We've selected 13 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 Windows and Mac: Essentials.
Save
Comprehensive guide to Excel 2016, covering everything from basic to advanced topics. It valuable resource for anyone who wants to learn more about Excel.
Beginner-friendly guide to Excel 2016. It covers all the basics, from creating and editing spreadsheets to using formulas and functions.
Step-by-step guide to Excel 2016. It provides clear and concise instructions on how to use all the features of Excel.
Guide to using VBA to automate tasks in Excel. It valuable resource for anyone who wants to learn more about VBA.
Guide to using Excel for data analysis. It covers topics such as data cleaning, data visualization, and statistical analysis.
Guide to creating dashboards and reports in Excel. It covers topics such as data visualization, dashboard design, and report writing.
Beginner-friendly guide to using macros in Excel. It covers topics such as recording macros, writing macros, and using macros to automate tasks.
Guide to using pivot tables in Excel. It covers topics such as creating pivot tables, using pivot tables to analyze data, and formatting pivot tables.
Guide to using charts and graphs in Excel. It covers topics such as creating charts and graphs, using charts and graphs to visualize data, and formatting charts and graphs.
Guide to using functions and formulas in Excel. It covers topics such as creating functions and formulas, using functions and formulas to calculate data, and formatting functions and formulas.
Save
Guide to using conditional formatting and data validation in Excel. It covers topics such as creating conditional formatting rules, using conditional formatting to highlight data, and using data validation to ensure that data is valid.
Guide to securing and auditing workbooks in Excel. It covers topics such as protecting workbooks with passwords, using digital signatures to verify the authenticity of workbooks, and using the audit trail to track changes to workbooks.
Guide to programming in VBA in Excel. It covers topics such as creating and using macros, using object-oriented programming techniques, and using VBA to automate tasks.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/fjr71z/excel
Share
Similar courses
Here are nine courses similar to
Excel 2016 for Windows and Mac: Essentials.
Developing for Excel with VBA
OpenCourser.com/course/4dddo0/developing
Developing for Excel with VBA
Building Excel Online Automation with Office Scripts
OpenCourser.com/course/li6sgz/building
Building Excel Online Automation with Office Scripts
Introduction to Data Analysis Using Excel
OpenCourser.com/course/jcha9s/introduction
Introduction to Data Analysis Using Excel
Excel for Everyone: Core Foundations
OpenCourser.com/course/tdok85/excel
Excel for Everyone: Core Foundations
Data for Business Analysts Using Microsoft Excel
OpenCourser.com/course/anilnf/data
Data for Business Analysts Using Microsoft Excel
Python in Excel 2023 Masterclass for Data Science
OpenCourser.com/course/1m3n7c/python
Python in Excel 2023 Masterclass for Data Science
Data Processing and Analysis with Excel
OpenCourser.com/course/wolvk1/data
Data Processing and Analysis with Excel
Business Intelligence Workflow with Excel 2019
OpenCourser.com/course/k5wk3m/business
Business Intelligence Workflow with Excel 2019
Forecast the #NoEstimates Way
OpenCourser.com/course/5tdauo/forecast
Forecast the #NoEstimates Way
Time
173 hours
Level
Introductory
Via
Pluralsight
Instructor
Bob Flisser
Language
English
Good to know
Provides foundational Excel skills for complete beginners
Builds a foundation for learners interested in deeper Excel study
Covers core Excel functions used across industries
Instructed by Bob Flisser, recognized for expertise in Excel training
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