Microsoft 365 Excel: Part 1
A comprehensive beginner's course on Microsoft 365 Excel. You will learn how to navigate the Excel interface, create and save workbooks, work with formulas and functions, format and modify worksheets, configure print settings, manage large workbooks, and customize the Excel environment to suit your workflow. No prior Excel experience is required.
What you'll learn
- Identify the basic components of the Excel interface including the ribbon, Name Box, Formula Bar, and worksheet tabs
- Create, save, and manage Excel workbooks in various file formats
- Use Excel's built-in help and search features to find answers and guidance
- Build formulas using mathematical operators, cell references, and the correct order of operations
- Apply common functions such as SUM, AVERAGE, MAX, and MIN using AutoSum and the Insert Function dialog box
- Manipulate worksheet data using cut, copy, paste, AutoFill, Flash Fill, and drag-and-drop
- Insert, delete, resize, hide, and unhide rows and columns
- Sort and filter data to organize and refine worksheet displays
- Format text and cells using fonts, borders, fills, number formats, and alignment tools
- Use Find, Replace, and Go To commands to locate and update data
- Run the Spelling checker to identify and correct errors
- Configure page layout settings and print workbooks with appropriate options
- Manage worksheet tabs through renaming, color-coding, grouping, moving, hiding, and deleting
- Control workbook views using Freeze Panes, Split, and multiple windows
- Customize the Excel environment via the Excel Options dialog box, the ribbon, and the Quick Access Toolbar
- Enable and manage Excel add-ins
Preview a lesson
Customize General, Language, and Formula Options The **Excel Options dialog box** (opened via **File → Options**) is the central hub for personalizing how Excel looks and behaves. It contains 10 categories. The General Category The General category controls overall appearance and default behaviors: **Show Mini Toolbar on selection** – Toggles the mini toolbar on/off when selecting cells. **Enable Live Preview** – Shows formatting changes before you apply them. **ScreenTip style** – Controls the detail level of command tooltips. **Default font and font size** – Sets the starting font for all new workbooks. **Default view for new sheets** – Chooses the view (Normal, Page Layout, etc.) for new sheets. **Include this many sheets** – Sets the number of worksheets in each new workbook (default: 1). **User name** – The name associated with your copy of Microsoft Office. **Office theme** – Choose between Colorful, Dark Gray, and White themes. The Language Category Set the **display language** (interface buttons and menus) and **authoring/proofing language** (spell check and grammar). If you work in multiple languages, you can add additional editing languages here. The Formulas Category Customize how formulas behave: **Calculation options** – Choose *Automatic* (default), *Automatic Except for Data Tables*, or *Manual*. **Working with formulas** – Set R1C1 reference style, enable/disable Formula AutoComplete. **Error Checking** – Toggle background error checking and change the color
…Enroll to read the rest and the full curriculum.
Curriculum
Lesson 1: Getting Started with Excel
4 lessons- textGetting to Know Excel
- textCreating Workbooks
- textGetting Help in Excel
- quizLesson 1 Quiz
Lesson 2: Working with Data
6 lessons- textA Closer Look at Formulas
- textUsing Formulas and Functions
- textWorking with Data
- textWorking with Rows and Columns
- textSorting and Filtering Data
- quizLesson 2 Quiz
Lesson 3: Modifying a Worksheet
6 lessons- textFormatting Text
- textFormatting Cells
- textAligning Cell Content
- textSearch For and Replace Data
- textSpell Check a Worksheet
- quizLesson 3 Quiz
Lesson 4: Printing Workbook Contents
3 lessons- textDefine the Basic Page Layout for a Workbook
- textRefine the Page Layout and Apply Print Options
- quizLesson 4 Quiz
Lesson 5: Managing Large Workbooks
4 lessons- textFormat Worksheet Tabs
- textManage Worksheets
- textManage the View of Worksheets and Workbooks
- quizLesson 5 Quiz
Lesson 6: Customizing the Excel Environment
5 lessons- textCustomize General, Language, and Formula OptionsPreview
- textCustomize Proofing, Save, and Version Control Options
- textCustomize the Ribbon, Quick Access Toolbar, and Add-Ins
- textCustomize Advanced and Trust Center Options
- quizLesson 6 Quiz