We may earn an affiliate commission when you visit our partners.
ClipTraining
In this course, Excel 365 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 365 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 365 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 365 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/knj0zp/excel
What's inside
Syllabus
Getting to Know Excel 365
Backstage View
Working with Worksheets and Data
Working with Rows and Columns
Read more
Syllabus
Getting to Know Excel 365
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
Introduces the Excel interface and settings, which are fundamental to using Excel
Builds a foundation for creating professional spreadsheets, which is a valuable skill in various industries
Provides preparation for Microsoft Office exams, which can enhance job prospects
Covers the Ribbon interface and Backstage View, which are essential for navigating and customizing Excel
Guides learners through working with worksheets, cells, columns, and rows, which are core elements of Excel
Teaches formatting and Auto options, which help enhance the appearance and functionality of spreadsheets
Save this course
Save Excel 365 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 365 Essentials with these
activities:
Read 'Microsoft Office Excel 2019 Step by Step'
Show steps
Provides thorough instruction and reference on the layout and features of Excel 365.
View
Microsoft Office 2019 Step by Step
on Amazon
Show steps
-
Read through Chapter 1 to become familiar with the user interface.
-
Practice using the Backstage view and Ribbon interface.
Review basic computer skills
Show steps
Refreshes basic computer skills necessary for navigating and using Excel 365 effectively.
Browse courses on
Computer Basics
Show steps
-
Review the basics of using a computer mouse and keyboard.
-
Practice navigating files and folders in an operating system.
Organize your course materials
Show steps
Helps students stay organized and access materials easily, promoting efficient learning.
Show steps
-
Create a folder for the course and subfolders for each module.
-
Save all course materials (slides, notes, assignments) in the appropriate folders.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Follow tutorials on the Microsoft Office Support website
Show steps
Offers guided instructions and demonstrations on specific topics covered in the course.
Browse courses on
Backstage View
Show steps
-
Watch the tutorial on 'Getting Started with Excel 365'.
-
Watch the tutorial on 'Using Backstage View'.
-
Watch the tutorial on 'Working with Worksheets and Data'.
Join a study group or online forum
Show steps
Provides opportunities for collaboration, discussion, and support from peers going through the same learning journey.
Show steps
-
Join a study group or online forum related to Excel 365.
-
Introduce yourself and share your learning goals.
-
Ask questions, share insights, and participate in discussions.
Work through Excel 365 Essentials Practice Drills
Show steps
Provides hands-on exercises to reinforce the concepts covered in the course.
Browse courses on
Formatting
Show steps
-
Complete the exercises in Section 1 on working with the Ribbon interface and Backstage View.
-
Complete the exercises in Section 2 on working with worksheets, cells, columns, and rows.
-
Complete the exercises in Section 3 on formatting and Auto options.
Create a cheat sheet with Excel 365 shortcuts
Show steps
Encourages active learning by summarizing key concepts and providing a quick reference guide for future use.
Browse courses on
Keyboard Shortcuts
Show steps
-
List the most commonly used Excel 365 shortcuts.
-
Organize the shortcuts by category (e.g., formatting, navigation).
Create a budget spreadsheet
Show steps
Applies the skills learned in the course to a practical project, reinforcing the concepts and building confidence.
Browse courses on
Formatting
Show steps
-
Create a new spreadsheet and format it for a budget.
-
Set up columns for income, expenses, and totals.
-
Enter your income and expenses.
-
Use formulas to calculate totals and subtotals.
Read 'Microsoft Office Excel 2019 Step by Step'
Show steps
Provides thorough instruction and reference on the layout and features of Excel 365.
View
Microsoft Office 2019 Step by Step
on Amazon
Show steps
Show steps
Show steps
- Read through Chapter 1 to become familiar with the user interface.
- Practice using the Backstage view and Ribbon interface.
Review basic computer skills
Show steps
Refreshes basic computer skills necessary for navigating and using Excel 365 effectively.
Browse courses on
Computer Basics
Show steps
Show steps
Show steps
- Review the basics of using a computer mouse and keyboard.
- Practice navigating files and folders in an operating system.
Organize your course materials
Show steps
Helps students stay organized and access materials easily, promoting efficient learning.
Show steps
Show steps
Show steps
- Create a folder for the course and subfolders for each module.
- Save all course materials (slides, notes, assignments) in the appropriate folders.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Follow tutorials on the Microsoft Office Support website
Show steps
Offers guided instructions and demonstrations on specific topics covered in the course.
Browse courses on
Backstage View
Show steps
Show steps
Show steps
- Watch the tutorial on 'Getting Started with Excel 365'.
- Watch the tutorial on 'Using Backstage View'.
- Watch the tutorial on 'Working with Worksheets and Data'.
Join a study group or online forum
Show steps
Provides opportunities for collaboration, discussion, and support from peers going through the same learning journey.
Show steps
Show steps
Show steps
- Join a study group or online forum related to Excel 365.
- Introduce yourself and share your learning goals.
- Ask questions, share insights, and participate in discussions.
Work through Excel 365 Essentials Practice Drills
Show steps
Provides hands-on exercises to reinforce the concepts covered in the course.
Browse courses on
Formatting
Show steps
Show steps
Show steps
- Complete the exercises in Section 1 on working with the Ribbon interface and Backstage View.
- Complete the exercises in Section 2 on working with worksheets, cells, columns, and rows.
- Complete the exercises in Section 3 on formatting and Auto options.
Create a cheat sheet with Excel 365 shortcuts
Show steps
Encourages active learning by summarizing key concepts and providing a quick reference guide for future use.
Browse courses on
Keyboard Shortcuts
Show steps
Show steps
Show steps
- List the most commonly used Excel 365 shortcuts.
- Organize the shortcuts by category (e.g., formatting, navigation).
Create a budget spreadsheet
Show steps
Applies the skills learned in the course to a practical project, reinforcing the concepts and building confidence.
Browse courses on
Formatting
Show steps
Show steps
Show steps
- Create a new spreadsheet and format it for a budget.
- Set up columns for income, expenses, and totals.
- Enter your income and expenses.
- Use formulas to calculate totals and subtotals.
Career center
Learners who complete Excel 365 Essentials will develop knowledge and skills
that may be useful to these careers:
Management Consultant
Management Consultant
Management Consultants use Excel to create presentations and analyze data to help businesses improve their performance. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Management Consultants. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Management Consultants who need to be able to manage and analyze large amounts of data.
Data Scientist
Data Scientist
Data Scientists use Excel to clean, analyze, and visualize data. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Data Scientists. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Data Scientists who need to be able to manage and analyze large amounts of data.
Business Analyst
Business Analyst
Business Analysts use Excel to create business models and analyze business data. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Business Analysts. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Business Analysts who need to be able to manage and analyze large amounts of business data.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use Excel to create models and analyze data to help businesses improve their operations. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Operations Research Analysts. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Operations Research Analysts who need to be able to manage and analyze large amounts of data.
Statistician
Statistician
Statisticians use Excel to analyze data and draw conclusions. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Statisticians. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Statisticians who need to be able to manage and analyze large amounts of data.
Data Analyst
Data Analyst
Data Analysts collect, interpret, and present data to help businesses make informed decisions. This course, Excel 365 Essentials, provides a strong foundation in working with data in Excel, which is a key tool for Data Analysts. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Data Analysts who need to be able to manage and analyze large amounts of data.
Financial Analyst
Financial Analyst
Financial Analysts use Excel to create financial models and analyze financial data. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Financial Analysts. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Financial Analysts who need to be able to manage and analyze large amounts of financial data.
Actuary
Actuary
Actuaries use Excel to create models and analyze data to help businesses assess risk. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Actuaries. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Actuaries who need to be able to manage and analyze large amounts of data.
Marketing Manager
Marketing Manager
Marketing Managers use Excel to create budgets and track campaign performance. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Marketing Managers. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Marketing Managers who need to be able to manage and track marketing campaigns.
Project Manager
Project Manager
Project Managers use Excel to create timelines and track progress on projects. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Project Managers. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Project Managers who need to be able to manage and track projects.
Sales Manager
Sales Manager
Sales Managers use Excel to create sales forecasts and track sales performance. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Sales Managers. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Sales Managers who need to be able to manage and track sales performance.
Software Engineer
Software Engineer
Software Engineers use Excel to create prototypes and mockups of software applications. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Software Engineers. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Software Engineers who need to be able to create and manage software applications.
Product Manager
Product Manager
Product Managers use Excel to create roadmaps and track progress on product development. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Product Managers. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Product Managers who need to be able to manage and track product development.
Web Developer
Web Developer
Web Developers use Excel to create prototypes and mockups of websites. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Web Developers. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Web Developers who need to be able to create and manage websites.
Customer Success Manager
Customer Success Manager
Customer Success Managers use Excel to track customer satisfaction and identify opportunities for improvement. This course, Excel 365 Essentials, provides a strong foundation in Excel, which is a key tool for Customer Success Managers. The course covers topics such as getting to know Excel 365, working with worksheets and data, and formatting. These skills are essential for Customer Success Managers who need to be able to manage and track customer relationships.
For more career information including salaries, visit:
OpenCourser.com/course/knj0zp/excel
Reading list
We've selected eight 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 365 Essentials.
Great resource for anyone who wants to learn how to create effective Excel dashboards and reports. It covers everything from data preparation to visualization.
Great resource for anyone who wants to learn how to use Excel formulas and functions effectively. It covers everything from basic to advanced topics.
Great resource for anyone who wants to learn how to use Excel pivot tables and charts effectively. It covers everything from basic to advanced topics.
Great resource for anyone who wants to learn how to use VBA to automate Excel tasks. It covers everything from basic to advanced topics.
Save
Great resource for anyone who wants to learn how to use Power Query to import and transform data in Excel. It covers everything from basic to advanced topics.
Great resource for anyone who wants to learn the basics of Excel 2019. It covers everything from creating and formatting spreadsheets to using formulas and functions.
Great resource for anyone who wants to learn more about the advanced features of Excel 2019. It covers everything from data analysis to financial modeling.
Great resource for anyone who wants to learn how to use Excel formulas and functions effectively. It covers everything from basic to advanced topics.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/knj0zp/excel
Share
Similar courses
Here are nine courses similar to
Excel 365 Essentials.
Excel 2021 Essentials
OpenCourser.com/course/18hvfz/excel
Excel 2021 Essentials
Most relevant
Excel 365 Pro
OpenCourser.com/course/we239c/excel
Excel 365 Pro
Most relevant
PowerPoint 365 Essentials
OpenCourser.com/course/4srrwm/powerpoint
PowerPoint 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
Excel 2019 Essentials
OpenCourser.com/course/j8rj2e/excel
Excel 2019 Essentials
Most relevant
PowerPoint 2021 Essentials
OpenCourser.com/course/d6gpjg/powerpoint
PowerPoint 2021 Essentials
Most relevant
PowerPoint 365 Power Users
OpenCourser.com/course/21rvkv/powerpoint
PowerPoint 365 Power Users
Most relevant
PowerPoint 365 Pro
OpenCourser.com/course/a7t2ov/powerpoint
PowerPoint 365 Pro
Most relevant
Time
153 hours
Level
Introductory
Via
Pluralsight
Instructor
ClipTraining
Language
English
Good to know
Introduces the Excel interface and settings, which are fundamental to using Excel
Builds a foundation for creating professional spreadsheets, which is a valuable skill in various industries
Provides preparation for Microsoft Office exams, which can enhance job prospects
Covers the Ribbon interface and Backstage View, which are essential for navigating and customizing Excel
Guides learners through working with worksheets, cells, columns, and rows, which are core elements of Excel
Teaches formatting and Auto options, which help enhance the appearance and functionality of spreadsheets
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