We may earn an affiliate commission when you visit our partners.
Excel 2021 Essentials
ClipTraining
ClipTraining
In this course, Excel 2021 Essentials, you will learn foundational knowledge of the Excel interface and settings. When youíre finished with this course, you will have the skills needed to begin creating your own professional spreadsheets (and begin preparation for the Microsoft Office exams).
Read more
In this course, Excel 2021 Essentials, you will learn foundational knowledge of the Excel interface and settings. When youíre finished with this course, you will have the skills needed to begin creating your own professional spreadsheets (and begin preparation for the Microsoft Office exams).
Read more
In this course, Excel 2021 Essentials, you will learn foundational knowledge of the Excel interface and settings. When youíre finished with this course, you will have the skills needed to begin creating your own professional spreadsheets (and begin preparation for the Microsoft Office exams).
In this course, Excel 2021 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When youíre finished with this course, you will have the skills needed to begin creating your own professional spreadsheets (and begin preparation for the Microsoft Office exams).
Register for this course and see more details by visiting:
OpenCourser.com/course/18hvfz/excel
What's inside
Syllabus
Getting to Know Excel 2021
Backstage View
Working with Worksheets and Data
Working with Rows and Columns
Read more
Syllabus
Getting to Know Excel 2021
Backstage View
Working with Worksheets and Data
Working with Rows and Columns
Read more
Formatting
Totaling Values
Saving a File
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Develops a strong foundational knowledge of the Excel interface and settings, which is essential for working with spreadsheets
Covers fundamental concepts, making it a suitable choice for beginners or those looking to refresh their understanding of Excel
Maps well to objectives for Microsoft Office exams, providing a solid foundation for certification preparation
Instructors have extensive experience and are recognized for their work in Excel training
Save this course
Save Excel 2021 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 2021 Essentials with these
activities:
Review Excel Interface and Basic Functions
Show steps
Refresh your memory on Excel's interface and fundamental functions to ensure a smooth transition into the course.
Browse courses on
Excel Basics
Show steps
-
Open an Excel spreadsheet
-
Familiarize yourself with the Ribbon, Quick Access Toolbar, and Formula Bar
-
Practice basic functions like SUM, AVERAGE, and COUNT
Refresh: Microsoft Office Fundamentals
Show steps
Brush up on your basic Microsoft Office skills to ensure you have a strong foundation for this Excel course.
Browse courses on
Microsoft Office
Show steps
-
Review the basics of Microsoft Word, Excel, PowerPoint, and Outlook.
-
Create a new document, spreadsheet, and presentation in each application.
-
Practice basic formatting and editing tasks.
Read a text on Excel Essentials
Show steps
Familiarize yourself with Excel's essential concepts to set a strong foundation for the course.
View
Microsoft Excel 365 Bible
on Amazon
Show steps
-
Purchase or borrow a copy of Excel 2021 Bible
-
Read chapters 1-3 to gain an overview of Excel basics
-
Complete any practice exercises or quizzes in the book
11 other activities
Expand to see all activities and additional details
Show all 14 activities
Complete Excel Practice Exercises
Show steps
Test and strengthen your Excel skills through repetitive exercises, solidifying your understanding of the fundamentals.
Show steps
-
Download practice exercises from the course resources
-
Open the exercises in Excel and work through them step-by-step
-
Check your answers against the provided solutions
Excel Study Group
Show steps
Enhance your learning by collaborating with peers in a study group to discuss concepts and work on projects.
Show steps
-
Find a study partner or group.
-
Meet regularly to discuss course material and work on assignments together.
-
Share knowledge and support each other's learning.
Excel Dashboard Tutorial
Show steps
Deepen your understanding of Excel by following a guided tutorial on creating interactive dashboards.
Browse courses on
Data Visualization
Show steps
-
Find a guided tutorial on creating Excel dashboards.
-
Follow the tutorial step-by-step.
-
Create your own Excel dashboard using the techniques you learned.
Complete Microsoft's Excel Tutorials
Show steps
Reinforce your understanding of Excel concepts through Microsoft's interactive tutorials.
Show steps
-
Visit Microsoft's Excel tutorial page
-
Choose a tutorial that aligns with your learning goals
-
Follow the step-by-step instructions and complete the exercises
Excel Formula Practice
Show steps
Strengthen your Excel formula skills through repetitive exercises and practice.
Browse courses on
Excel Formulas
Show steps
-
Find a website or app that offers Excel formula practice exercises.
-
Complete as many exercises as you can.
-
Review your answers and identify areas where you need improvement.
Solve Excel Exercises on Excel Hero
Show steps
Enhance your Excel proficiency by solving practical exercises on Excel Hero.
Show steps
-
Create an account on Excel Hero
-
Choose an exercise that matches your skill level
-
Solve the exercise and compare your solution to the provided answer
Create a Workbook with Real-World Data
Show steps
Enhance your Excel proficiency by creating a functional workbook that simulates real-world scenarios, applying your knowledge in a practical context.
Browse courses on
Data Manipulation
Show steps
-
Identify a real-world dataset or scenario
-
Design a workbook structure that meets the data requirements
-
Enter and manipulate the data using appropriate formulas and functions
-
Create charts to visualize the data and identify trends
Explore Advanced Features through External Tutorials
Show steps
Expand your Excel knowledge by exploring specialized tutorials, gaining insights into advanced features and techniques beyond the course coverage.
Browse courses on
Excel VBA
Show steps
-
Identify external tutorials that align with your learning goals
-
Follow the tutorials step-by-step, experimenting with the new features
-
Apply what you've learned to your own projects
Create a Budget Spreadsheet
Show steps
Apply your Excel skills to a real-world project by creating a customized budget spreadsheet.
Show steps
-
Gather your financial data (income, expenses, savings goals)
-
Design a spreadsheet layout that meets your specific needs
-
Input your data and apply appropriate formulas and functions
-
Format the spreadsheet for clarity and readability
Excel Project: Data Analysis and Visualization
Show steps
Apply your Excel skills to a real-world project by analyzing data and creating visualizations.
Browse courses on
Data Analysis
Show steps
-
Choose a dataset to analyze.
-
Use Excel to clean and prepare the data.
-
Create charts and graphs to visualize the data.
-
Write a report summarizing your findings.
Participate in an Excel Competition
Show steps
Challenge yourself and showcase your Excel proficiency by participating in an Excel competition.
Show steps
-
Find an Excel competition that aligns with your interests and skill level
-
Study the competition guidelines and requirements
-
Develop a solution to the competition problem
-
Submit your solution and wait for the results
Review Excel Interface and Basic Functions
Show steps
Refresh your memory on Excel's interface and fundamental functions to ensure a smooth transition into the course.
Browse courses on
Excel Basics
Show steps
Show steps
Show steps
- Open an Excel spreadsheet
- Familiarize yourself with the Ribbon, Quick Access Toolbar, and Formula Bar
- Practice basic functions like SUM, AVERAGE, and COUNT
Refresh: Microsoft Office Fundamentals
Show steps
Brush up on your basic Microsoft Office skills to ensure you have a strong foundation for this Excel course.
Browse courses on
Microsoft Office
Show steps
Show steps
Show steps
- Review the basics of Microsoft Word, Excel, PowerPoint, and Outlook.
- Create a new document, spreadsheet, and presentation in each application.
- Practice basic formatting and editing tasks.
Read a text on Excel Essentials
Show steps
Familiarize yourself with Excel's essential concepts to set a strong foundation for the course.
View
Microsoft Excel 365 Bible
on Amazon
Show steps
Show steps
Show steps
- Purchase or borrow a copy of Excel 2021 Bible
- Read chapters 1-3 to gain an overview of Excel basics
- Complete any practice exercises or quizzes in the book
11 other activities
Expand to see all activities and additional details
Show all 14 activities
Complete Excel Practice Exercises
Show steps
Test and strengthen your Excel skills through repetitive exercises, solidifying your understanding of the fundamentals.
Show steps
Show steps
Show steps
- Download practice exercises from the course resources
- Open the exercises in Excel and work through them step-by-step
- Check your answers against the provided solutions
Excel Study Group
Show steps
Enhance your learning by collaborating with peers in a study group to discuss concepts and work on projects.
Show steps
Show steps
Show steps
- Find a study partner or group.
- Meet regularly to discuss course material and work on assignments together.
- Share knowledge and support each other's learning.
Excel Dashboard Tutorial
Show steps
Deepen your understanding of Excel by following a guided tutorial on creating interactive dashboards.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Find a guided tutorial on creating Excel dashboards.
- Follow the tutorial step-by-step.
- Create your own Excel dashboard using the techniques you learned.
Complete Microsoft's Excel Tutorials
Show steps
Reinforce your understanding of Excel concepts through Microsoft's interactive tutorials.
Show steps
Show steps
Show steps
- Visit Microsoft's Excel tutorial page
- Choose a tutorial that aligns with your learning goals
- Follow the step-by-step instructions and complete the exercises
Excel Formula Practice
Show steps
Strengthen your Excel formula skills through repetitive exercises and practice.
Browse courses on
Excel Formulas
Show steps
Show steps
Show steps
- Find a website or app that offers Excel formula practice exercises.
- Complete as many exercises as you can.
- Review your answers and identify areas where you need improvement.
Solve Excel Exercises on Excel Hero
Show steps
Enhance your Excel proficiency by solving practical exercises on Excel Hero.
Show steps
Show steps
Show steps
- Create an account on Excel Hero
- Choose an exercise that matches your skill level
- Solve the exercise and compare your solution to the provided answer
Create a Workbook with Real-World Data
Show steps
Enhance your Excel proficiency by creating a functional workbook that simulates real-world scenarios, applying your knowledge in a practical context.
Browse courses on
Data Manipulation
Show steps
Show steps
Show steps
- Identify a real-world dataset or scenario
- Design a workbook structure that meets the data requirements
- Enter and manipulate the data using appropriate formulas and functions
- Create charts to visualize the data and identify trends
Explore Advanced Features through External Tutorials
Show steps
Expand your Excel knowledge by exploring specialized tutorials, gaining insights into advanced features and techniques beyond the course coverage.
Browse courses on
Excel VBA
Show steps
Show steps
Show steps
- Identify external tutorials that align with your learning goals
- Follow the tutorials step-by-step, experimenting with the new features
- Apply what you've learned to your own projects
Create a Budget Spreadsheet
Show steps
Apply your Excel skills to a real-world project by creating a customized budget spreadsheet.
Show steps
Show steps
Show steps
- Gather your financial data (income, expenses, savings goals)
- Design a spreadsheet layout that meets your specific needs
- Input your data and apply appropriate formulas and functions
- Format the spreadsheet for clarity and readability
Excel Project: Data Analysis and Visualization
Show steps
Apply your Excel skills to a real-world project by analyzing data and creating visualizations.
Browse courses on
Data Analysis
Show steps
Show steps
Show steps
- Choose a dataset to analyze.
- Use Excel to clean and prepare the data.
- Create charts and graphs to visualize the data.
- Write a report summarizing your findings.
Participate in an Excel Competition
Show steps
Challenge yourself and showcase your Excel proficiency by participating in an Excel competition.
Show steps
Show steps
Show steps
- Find an Excel competition that aligns with your interests and skill level
- Study the competition guidelines and requirements
- Develop a solution to the competition problem
- Submit your solution and wait for the results
Career center
Learners who complete Excel 2021 Essentials will develop knowledge and skills
that may be useful to these careers:
Financial Analyst
Financial Analyst
Financial Analysts are responsible for researching, analyzing, and forecasting financial data and trends. They use their knowledge of Excel to create spreadsheets and financial models to help businesses make informed decisions about investments, budgeting, and other financial matters. This course can help Financial Analysts develop the skills they need to create accurate and reliable financial models, which are essential for making sound investment decisions and forecasting future financial performance.
Market Research Analyst
Market Research Analyst
Market Research Analysts collect, analyze, and interpret data about markets, customers, and competitors. They use their knowledge of Excel to create spreadsheets and reports that help businesses understand their market position and make informed decisions about product development, marketing campaigns, and other business strategies. This course can help Market Research Analysts develop the skills they need to create accurate and reliable market research reports, which are essential for understanding customer needs and developing effective marketing strategies.
Actuary
Actuary
Actuaries use mathematical and statistical techniques to assess risk and uncertainty. They use their knowledge of Excel to create spreadsheets and models that help businesses and governments make informed decisions about insurance, investments, and other financial matters. This course can help Actuaries develop the skills they need to create accurate and reliable risk assessment models, which are essential for pricing insurance policies and managing financial risk.
Data Analyst
Data Analyst
Data Analysts collect, clean, and analyze data to help businesses understand their operations and make informed decisions. They use their knowledge of Excel to create spreadsheets and reports that help businesses identify trends, patterns, and opportunities. This course can help Data Analysts develop the skills they need to create accurate and reliable data analysis reports, which are essential for understanding business performance and making data-driven decisions.
Business Analyst
Business Analyst
Business Analysts help businesses improve their operations and performance by identifying and analyzing problems and developing solutions. They use their knowledge of Excel to create spreadsheets and models that help businesses track key performance indicators (KPIs), forecast future performance, and make informed decisions about business operations. This course can help Business Analysts develop the skills they need to create accurate and reliable business analysis reports, which are essential for understanding business performance and making sound business decisions.
Project Manager
Project Manager
Project Managers plan, execute, and close projects. They use their knowledge of Excel to create spreadsheets and reports that help them track project progress, manage resources, and communicate with stakeholders. This course can help Project Managers develop the skills they need to create accurate and reliable project management reports, which are essential for keeping projects on track and meeting deadlines.
Operations Manager
Operations Manager
Operations Managers oversee the day-to-day operations of a business. They use their knowledge of Excel to create spreadsheets and reports that help them track performance, identify inefficiencies, and make informed decisions about operations. This course can help Operations Managers develop the skills they need to create accurate and reliable operations management reports, which are essential for understanding business performance and making operational improvements.
Accountant
Accountant
Accountants prepare, analyze, and interpret financial statements. They use their knowledge of Excel to create spreadsheets and reports that help businesses track their financial performance and make informed decisions about investments, budgeting, and other financial matters. This course can help Accountants develop the skills they need to create accurate and reliable financial statements, which are essential for understanding business performance and making sound financial decisions.
Auditor
Auditor
Auditors examine and evaluate financial records to ensure that they are accurate and reliable. They use their knowledge of Excel to create spreadsheets and reports that help them identify errors and irregularities in financial statements. This course can help Auditors develop the skills they need to create accurate and reliable audit reports, which are essential for ensuring the accuracy and reliability of financial statements.
Financial Planner
Financial Planner
Financial Planners help individuals and families plan for their financial future. They use their knowledge of Excel to create spreadsheets and reports that help their clients track their financial goals, manage their investments, and make informed decisions about their finances. This course can help Financial Planners develop the skills they need to create accurate and reliable financial plans, which are essential for helping clients achieve their financial goals.
Tax Preparer
Tax Preparer
Tax Preparers prepare and file tax returns for individuals and businesses. They use their knowledge of Excel to create spreadsheets and reports that help them calculate taxes and prepare tax returns. This course can help Tax Preparers develop the skills they need to create accurate and reliable tax returns, which are essential for ensuring that clients pay the correct amount of taxes.
Loan Officer
Loan Officer
Loan Officers help individuals and businesses obtain loans. They use their knowledge of Excel to create spreadsheets and reports that help them analyze loan applications and make decisions about whether or not to approve loans. This course can help Loan Officers develop the skills they need to create accurate and reliable loan analysis reports, which are essential for making sound lending decisions.
Insurance Agent
Insurance Agent
Insurance Agents help individuals and businesses obtain insurance policies. They use their knowledge of Excel to create spreadsheets and reports that help them analyze insurance needs and make recommendations about insurance policies. This course can help Insurance Agents develop the skills they need to create accurate and reliable insurance analysis reports, which are essential for helping clients obtain the right insurance coverage.
Salesperson
Salesperson
Salespeople sell products and services to individuals and businesses. They use their knowledge of Excel to create spreadsheets and reports that help them track sales, manage customer relationships, and make informed decisions about sales strategies. This course can help Salespeople develop the skills they need to create accurate and reliable sales reports, which are essential for understanding sales performance and making data-driven sales decisions.
Customer Service Representative
Customer Service Representative
Customer Service Representatives provide support to customers by answering questions, resolving problems, and processing orders. They use their knowledge of Excel to create spreadsheets and reports that help them track customer interactions, identify trends, and make informed decisions about customer service operations. This course can help Customer Service Representatives develop the skills they need to create accurate and reliable customer service reports, which are essential for understanding customer needs and improving customer service operations.
For more career information including salaries, visit:
OpenCourser.com/course/18hvfz/excel
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 2021 Essentials.
Offers an extensive collection of Excel functions and formulas, serving as a valuable reference for learners seeking to expand their knowledge and skills.
Save
Provides a comprehensive guide to creating and customizing charts and graphs in Excel, enhancing the visual presentation of data.
Offers a comprehensive guide to working with PivotTables and PivotCharts in Excel, enabling learners to effectively summarize and analyze large datasets.
Save
Offers a comprehensive introduction to VBA programming in Excel, covering topics from basic syntax to advanced object-oriented programming techniques.
Save
Comprehensive guide to Excel 2021. It will teach you how to use all of the features of Excel, from basic to advanced.
Teaches you how to use Excel to create dynamic and informative dashboards and reports. It will help you learn how to present data in a clear and concise way.
Provides a comprehensive guide to Excel VBA programming. It will teach you how to use VBA to automate tasks and extend the functionality of Excel.
Provides a comprehensive guide to Excel 2021 macros and VBA. It will teach you how to use these powerful tools to automate tasks and extend the functionality of Excel.
Provides a comprehensive guide to Excel Power Query. It will teach you how to use this powerful tool to connect to, transform, and clean data.
Provides a comprehensive guide to Excel data analysis. It will teach you how to use Excel to analyze and visualize data.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/18hvfz/excel
Share
Similar courses
Here are nine courses similar to
Excel 2021 Essentials.
Excel 365 Essentials
OpenCourser.com/course/knj0zp/excel
Excel 365 Essentials
Most relevant
Excel 2021 Pro
OpenCourser.com/course/6vpvfp/excel
Excel 2021 Pro
Most relevant
Excel 2021 Power Users
OpenCourser.com/course/j3xia7/excel
Excel 2021 Power Users
Most relevant
PowerPoint 2021 Essentials
OpenCourser.com/course/d6gpjg/powerpoint
PowerPoint 2021 Essentials
Most relevant
Excel 365 Pro
OpenCourser.com/course/we239c/excel
Excel 365 Pro
Most relevant
Excel 2019 Essentials
OpenCourser.com/course/j8rj2e/excel
Excel 2019 Essentials
Most relevant
PowerPoint 365 Essentials
OpenCourser.com/course/4srrwm/powerpoint
PowerPoint 365 Essentials
Most relevant
Excel 2019 Power Users
OpenCourser.com/course/ncsrxi/excel
Excel 2019 Power Users
Most relevant
Control Excel with Python & OpenPyXL
OpenCourser.com/course/7gdx1w/control
Control Excel with Python & OpenPyXL
Time
151 hours
Level
Introductory
Via
Pluralsight
Instructor
ClipTraining
Language
English
Good to know
Develops a strong foundational knowledge of the Excel interface and settings, which is essential for working with spreadsheets
Covers fundamental concepts, making it a suitable choice for beginners or those looking to refresh their understanding of Excel
Maps well to objectives for Microsoft Office exams, providing a solid foundation for certification preparation
Instructors have extensive experience and are recognized for their work 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