Excel 2024 Essential Training (Office 2024/LTSC)

Course details

Excel, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, Jess Stratton shows you the ins and outs of the 2024 release. From navigating the interface to creating dynamic charts and using advanced features like PivotTables, and XLookup, develop the skills you need to boost your productivity and data analysis capabilities. Perfect for beginners and anyone looking to update their Excel skills, this course can help empower you to harness the full potential of Excel 2024 in your everyday work.

Learning objectives
Navigate the Excel 2024 interface efficiently and understand its core components.
Create, format, and manage workbooks and worksheets effectively.
Input, edit, and manipulate data using various Excel tools and features.
Apply basic and advanced formulas and functions to perform calculations and data analysis.
Organize and analyze data using sorting, filtering, and PivotTables.
Visualize data through static and dynamic charts, conditional formatting, and other graphical elements.
Utilize advanced features such as XLookup for complex data operations.
Collaborate with others by sharing workbooks and implementing data protection measures.
Optimize Excel for printing and presenting data effectively.
Apply best practices for efficient data management and analysis in Excel 2024.

Concepts

0. Introduction

01 - Analyze data with maximum efficiency in Excel
02 - Check the version of Excel you are using

1. Work with Excel Files

03 - Navigate Excel and the ribbon
04 - Create, open, and save a file
05 - Enter text in a workbook

2. Work with Cells and Text in Excel

06 - Format text in Excel
07 - Autofill and edit text
08 - Copying and deleting cell data
09 - Change borders and background colors
10 - Merge cells
11 - Find and replace text and values
12 - Work with cell data types

3. Work with Excel Sheets

13 - Rename, insert, and delete a sheet in Excel
14 - Move and group sheets

4. Work with Rows and Columns in Excel

15 - Adjust column and row height and width
16 - Delete and hide rows and columns
17 - Insert multiple rows and columns
18 - Move and rearrange rows and columns
19 - Freeze columns and rows

5. Work with Formulas and Functions in Excel

20 - Build a formula and reference cells
21 - Copy formulas and use AutoSum
22 - Create a formula with XLOOKUP
23 - Split text into two columns

6. Sort and Filter Data in Excel

24 - Sort data in Excel
25 - Filter data with a dropdown list
26 - Create a PivotTable to group and summarize data
27 - Use conditional formatting to see trends
28 - Create and work with charts
29 - Create dynamic charts and tables

7. Collaboration and Sharing in Excel

30 - Print a workbook or sheet
31 - Share a workbook or sheet
32 - Protect your file from unwanted changes

Conclusion

33 - Take Excel further with charts, tables, and more