$197beginner

Microsoft Excel 365: Part 1

Name: Microsoft Excel 365: Part 1
Price: 197.00 USD
Availability: InStock

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.

32 lessons7 modules480 minutes

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

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.

Microsoft Excel 365: Part 1

What you'll learn

Preview a lesson

Curriculum

Lesson 1: Getting Started with Excel Online

Lesson 2: Working with Data

Lesson 3: Formatting a Worksheet

Lesson 4: Adding Pictures and Shapes

Lesson 5: Organizing Data with Tables and Charts

Lesson 6: Using PivotTables

Lesson 7: Finalizing Workbooks

Reviews