Microsoft Excel 365: Part 1
A comprehensive introduction to Microsoft Excel 365 Online. This course covers everything from navigating the Excel interface and managing workbooks, to working with formulas and functions, formatting worksheets, inserting pictures and shapes, organizing data with tables and charts, analyzing data with PivotTables, and finalizing workbooks with comments and worksheet management tools. Designed for users comfortable with Windows who want to get up to speed with Excel 365 Online.
What you'll learn
- Log into Office 365 and launch Excel Online
- Identify and describe the components of the Excel Online interface
- Create, open, save, share, and print workbooks
- Describe spreadsheets, worksheets, workbooks, columns, rows, cells, and ranges
- Use Tell Me and other Excel help features
- Build and evaluate formulas using mathematical operators and cell references
- Use functions such as SUM, AVERAGE, MAX, MIN with AutoSum and Insert Function
- Select, cut, copy, paste, move, and fill data using AutoFill and Flash Fill
- Insert, delete, resize, hide, and unhide rows and columns
- Sort and filter worksheet data
- Format text using fonts, the Format Painter, and hyperlinks
- Apply borders, fills, and number formats to cells
- Align cell content using indent, wrap text, and merge options
- Use Find, Replace, and Go To commands
- Apply conditional formatting rules
- Insert, resize, rotate, and format pictures and shapes
- Create and customize tables
- Insert, move, resize, and modify charts
- Create and work with PivotTables including sorting and filtering
- Insert, edit, and delete comments
- Manage worksheets by inserting, deleting, duplicating, hiding, reordering, and renaming them
- Apply workbook view options including freeze panes
Preview a lesson
Using Comments Comments are a key collaboration feature in Excel Online, allowing you and your colleagues to annotate cells with notes, questions, or feedback. Inserting a Comment 1. Select the **cell** you want to annotate. 2. Click **Review → New Comment**, use **Insert → Comment**, or right-click and choose **New Comment**. 3. The **Comments pane** opens on the right. Type your comment and click **Post**. A **red triangle** appears in the top-right corner of the cell to indicate a comment is attached. Click the **speech bubble icon** that appears when the cell is selected to view the comment. Showing and Hiding the Comments Pane The Comments pane opens automatically when you create a comment. Toggle it on or off at any time by clicking **Review → Show Comments**. Editing a Comment 1. Click the cell containing the comment. 2. Click the **speech bubble** icon to view it in the Comments pane. 3. Click **Review → Edit Comment**. 4. Make your changes and click **Post** to save. Deleting a Comment 1. Select the cell and click the speech bubble icon to open the comment. 2. Click **Review → Delete Comment** or click the **…** menu within the comment and choose **Delete thread**. The comment is removed immediately.
Curriculum
Lesson 1: Getting Started with Excel Online
5 lessons- textGetting Started with Excel Online
- textGetting to Know Excel
- textManaging Workbooks
- textGetting Help in Excel Online
- 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: Formatting a Worksheet
6 lessons- textFormatting Text
- textFormatting Cells
- textAligning Cell Content
- textUsing Find & Select Tools
- textApplying Conditional Formatting
- quizLesson 3 Quiz
Lesson 4: Adding Pictures and Shapes
3 lessons- textInserting Pictures
- textInserting and Formatting Shapes
- quizLesson 4 Quiz
Lesson 5: Organizing Data with Tables and Charts
4 lessons- textInserting Tables
- textInserting Charts
- textModifying Charts
- quizLesson 5 Quiz
Lesson 6: Using PivotTables
4 lessons- textInserting PivotTables
- textWorking with PivotTable Data
- textSorting and Filtering PivotTable Data
- quizLesson 6 Quiz
Lesson 7: Finalizing Workbooks
4 lessons- textUsing CommentsPreview
- textManaging Worksheets
- textChanging View Options
- quizLesson 7 Quiz