Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Excel 365 2021: Beginner
Learn basic Excel skills to create, edit, and print a variety of spreadsheets and charts.Preview the first lesson free — get full access to all 33 lessons.
Beginner Provider : Douglas Bush 8 chapters · 33 Lessons · 1h 15m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
The ability to effectively organize and analyze data is critical in today’s competitive business environment, and Excel is the go-to software for addressing these needs. Excel contains a rich feature-set designed to make it possible for any user to manage and evaluate different types of data. Accurate data analysis is an important part of the decision-making process for any company. Excel plays a critical role by leveraging raw text and numeric data into actionable results, so decision-makers have all the necessary information to understand past performance and map out future strategies.
In this Microsoft Excel 365 (2021) Beginner course, you’ll learn the fundamentals of this popular spreadsheet program utilized by companies worldwide. By the end of this course, you’ll understand how to organize your data, add formatting, create simple formulas and functions, work with large spreadsheets, visualize your data with charts, and print out the results.
What You'll Learn
- Create well-organized spreadsheets by formatting titles, headings, text, and values
- Analyze data using basic formulas, functions, and Autosum
- Visualize data with column, bar, pie, doughnut, line, and area charts
- Manage large spreadsheets using rows, columns, worksheets, tabs, and freeze panes
- Produce professional-looking printed results with print areas, orientations, and page breaks
- Navigate Excel efficiently using keyboard navigation and selection shortcuts
Key Takeaways
- Excel is the go-to software for organizing and analyzing different types of data in a competitive business environment.
- Accurate data analysis is an important part of the decision-making process for any company.
- Excel turns raw text and numeric data into actionable results so decision-makers can understand past performance and map out future strategies.
- This beginner course covers the fundamentals of Excel 365 (2021), including organizing data, formatting, formulas and functions, charts, and printing.
- Learners can convert ranges into tables using the Format as Table feature and manage large spreadsheets with worksheets, tabs, and freeze panes.
Frequently Asked Questions
Who is this course for?
It is a beginner-level course for anyone who wants to learn the fundamentals of Microsoft Excel 365 (2021), the popular spreadsheet program used by companies worldwide.
What will I be able to do after completing this course?
By the end of the course you will understand how to organize your data, add formatting, create simple formulas and functions, work with large spreadsheets, visualize your data with charts, and print out the results.
What types of charts does the course cover?
The course covers column charts, bar charts, pie charts, doughnut charts, line charts, and area charts, as well as editing charts and chart keyboard shortcuts.
Does the course teach formulas and functions?
Yes. It covers basic formulas, basic functions, using Autosum, and copying formulas and functions so you can analyze data.
What skills are associated with this course?
The course is associated with skills including Microsoft Excel, Spreadsheets, Excel Macros, ExcelPackage, Excel Solver, and Microsoft Office 365.
