Microsoft Excel – U Connect

Microsoft Excel

With Microsoft Teams on your PC, Mac, or mobile device, you can: Excel makes it easy to work with numbers. Excel makes it easy to enter data using the AutoFill feature. You get chart suggestions based on your data and can create them with a single click. You can also easily pin trends and patterns using data bars, color codes, and icons.

Course Content

Expand All

01. Presentation of Excel 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

1. Create a workbook

2. Insert or delete a spreadsheet

3. Move or copy worksheets or worksheet data

4. Subtract in Excel

5. Multiply in Excel

6. Divide in Excel

7. Automatically Fill Data into Spreadsheet Cells

02. Rows and Columns 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

1. Insert or delete rows and columns

2. Select cell contents in Excel

3. Freeze panes to lock rows and columns

4. Hide or show rows or columns

5. Split text into multiple columns using the Conversion Assistant

6. Create a sequential date list

03. Cells 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

1. Move or copy cells and cell contents

2. Change column width or row height in Excel

3. Merge cells and unmerge cells

4. Apply data validation to cells

04. Shaping 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

1. Number formats available in Excel

2. Align or rotate text in a cell

3. Change the format of a cell

4. Copy cell formatting

5. Add Watermark in Excel

6. Create a Custom Number Format

05. Formulas and functions 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

1. Overview of formulas in Excel

3. SUM (SUM, function)

4. COUNTIF (COUNTIF, function)

5. IF (IF, function)

6. IF.CONDITIONS

9. Define and use names in formulas

10. Combine text from two or more cells into one cell

06. Tables 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

1. Create and format tables

2. Sort data in a table

3. Filter data from a range or array

4. Total data from an Excel table

5. Use segments to filter data

07. Graphics 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

1. Create an end-to-end chart

2. Add or remove titles from a chart

3. Show or hide a chart legend or data table

4. Add or remove secondary axis in chart from Excel

5. Add a trendline or average to a chart

6. Instantly analyze your data

7. Update existing chart data

8. Use sparklines to show data trends

08. Pivot Tables 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

1. Create a pivot table to analyze spreadsheet data

2. Use the Field List to Organize Fields in a PivotTable

3. Group or ungroup data in a pivot table

4. Filter data in a pivot table

5. Create a PivotChart

09. Share and co-create 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

1. Share your Excel workbook with others

2. Comments and ratings

3. Collaborate on Excel workbooks simultaneously with co-editing

4. Protect an Excel file

+9719 enrolled

Not Enrolled

This course is currently closed

Course Includes

9 Lessons
55 Topics

English