Microsoft Excel remains the go-to spreadsheet software for millions of people around the world. If you’ve been meaning to learn Excel for years but haven’t quite got around to it, or if you use Excel every day but feel lost when you log in, then this course is for you.
The course begins by introducing you to entering numbers and text into Excel, create basic formulas and how relative references and Order of Operations works. You will then learn how to work with larger Excel files and utilize split-screen and freeze panes, as well as how to insert headers and Footers in Excel. The course also teaches you how to add rows and columns and change column widths, how to use copy, cut and paste to save time, and how to print the correct part of your spreadsheet!
By the end of this beginner-friendly course, you’ll be able to:
- Navigate the Excel interface.
- Boost Excel productivity with formulas and shortcuts.
- Prepare data for analysis with organized and filtered data.
- Master math, statistical, logic, and text functions to manipulate data.
- Sort and filter data to quickly find important information.
- Use charts and graphs to present clear insights.
- Create and format Pivot Tables to summarize large data sets.
- Automate repetitive Excel tasks.
- Discover the latest features, like XLOOKUP, Dynamic Arrays, and LET functions.
- Use data validation to restrict data entry and reduce input errors.
- Customize page setup options for printing.
Over 100,000 people have learned practical, actionable Excel skills for business from our self-paced online classes to help them work smarter every single day.
Ready to add value, save time, and boost your productivity? Start mastering Excel today!
This course includes
-
- Introduction to Excel
- Basic Excel Functions & Formulas
- Formatting and Data Management
- Charts and Data Visualization
- Intermediate Formulas and Functions
- Tables and PivotTables
- Data Analysis Tools
- Collaboration and Sharing
Curriculum
- 8 Sections
- 0 Lessons
- 2 Weeks
Expand all sectionsCollapse all sections
- Section 1: Getting Started with ExcelLearn the Excel interface, including ribbons, cells, worksheets, and workbooks. Understand how to create, save, and navigate spreadsheets efficiently.0
- Section 2: Data Entry and FormattingMaster entering and editing data, applying number formats, and customizing the appearance of worksheets. Learn about cell styles, borders, and conditional formatting.0
- Section 3: Formulas and FunctionsDevelop skills in creating basic and advanced formulas using Excel’s built-in functions. Topics include SUM, AVERAGE, MAX, MIN, RANK, COUNT, IF, COUNTIF, and using absolute vs. relative references.0
- Section 4: Managing Data: Sorting, Filtering, and ValidationLearn how to organize large data sets by sorting and filtering. Explore data validation techniques to maintain accuracy and control input.0
- Section 5: Working with Charts and GraphsVisualize data with various chart types including column, pie, line, and combo charts. Learn how to customize chart elements for clearer data communication.0
- Section 6: Using Tables and Named RangesUnderstand how to convert data ranges into structured tables, use named ranges, and apply table styles for better data management and referencing.0
- Section 7: Introduction to PivotTables and PivotChartsUnlock Excel’s powerful data analysis tools by learning how to create PivotTables and PivotCharts to summarize, group, and analyze large datasets efficiently.0
- Section 8: Printing and Sharing WorkbooksPrepare spreadsheets for printing and digital sharing. Learn how to set print areas, adjust page layout, use headers/footers, and protect your work.0
Instructor
