Course Description
Excel is a powerful yet easy-to-use set of tools that enables users of all levels to produce quality results. By providing fundamental tools for cell and worksheet references, Excel provides an easy-to-use system of organization for many types of data. In this course on Microsoft 365: Excel, you will learn about cells, worksheets, and workbooks. We will explore navigation to functions and formulas as well as proper practices to store, analyze, and display data. By the end of this course, you will be able to work with data types and formatting as well as display data with analysis.
This course provides an introduction for using Excel to input, reference, and use values in calculations. This extends to organizing your data in worksheets and using ribbons and menus to navigate. Formulas and functions cover the most-used math and date functions to provide analysis and summaries of data and data types. By creating custom formulas, you can customize Excel to your specific needs. Data is created for presentation. Data is input into cells that can be formatted both in terms of data type as well as organized using visual formatting enhancements. All of these tools combine to provide the beginner with a smooth and replicable experience for storing, analyzing, and presenting data.
Learning Objectives:
- Understand cells, worksheets, and workbooks
- Navigate to functions and formulas
- Understand ribbons and menus
Skills You Will Learn
- Microsoft Excel
- Spreadsheets
- Excel Formulas
- Excel Macros
- Microsoft Office 365
- Microsoft Office Accounting
What You'll Learn
- Understand cells, worksheets, and workbooks in Microsoft 365 Excel
- Navigate to functions and formulas using ribbons and menus
- Use common math and date functions to analyze and summarize data
- Create custom formulas to input, reference, and calculate values
- Work with data types and apply cell formatting
- Display data with charts, plots, pictures, shapes, and data tables
Key Takeaways
- Excel provides fundamental tools for cell and worksheet references, offering an easy-to-use system for organizing many types of data.
- Formulas and functions cover the most-used math and date functions to provide analysis and summaries of data.
- Creating custom formulas lets you customize Excel to your specific needs.
- Data input into cells can be formatted both by data type and organized using visual formatting enhancements.
- These tools combine to give the beginner a smooth and replicable experience for storing, analyzing, and presenting data.
Frequently Asked Questions
Who is this course for?
It is a beginner course on Microsoft 365: Excel, providing an introduction for using Excel to input, reference, and use values in calculations. Excel is described as a powerful yet easy-to-use set of tools for users of all levels.
What does this course cover?
The course covers cells, worksheets, and workbooks; navigation to functions and formulas; ribbons and menus; common math and date functions; creating formulas; charts, plots, pictures and shapes; data types; formatting cells; and data tables.
What will I be able to do by the end of the course?
By the end, you will be able to work with data types and formatting as well as display data with analysis, and store, analyze, and present data.
What skills does this course help build?
It helps build skills in Microsoft Excel, Spreadsheets, Excel Formulas, Excel Macros, Microsoft Office 365, and Microsoft Office Accounting.
How is the course structured?
The course is organized into lessons that begin with an Introduction and end with a Conclusion, covering topics such as cell and worksheet references, ribbons and menus, math and date functions, creating formulas, charts, plots, data types, formatting cells, and data tables.
