Manage worksheets and workbooks
1. Import data into workbooks
- Import data from .txt files
- Import data from .csv files
2. Navigate within workbooks
- Search for data within a workbook
- Navigate to named cells, ranges, or workbook elements
- Insert and remove hyperlinks
3. Format worksheets and workbooks
- Modify page setup
- Adjust row height and column width
- Customize headers and footers
4. Customize options and views
- Customize the Quick Access toolbar
- Display and modify workbook content in different views
- Freeze worksheet rows and columns
- Change window views
- Modify basic workbook properties
- Display formulas
5. Configure content for collaboration
- Set a print area
- Save workbooks in alternative file formats
- Configure print settings
- Inspect workbooks for issues
Manage Data Cells and Ranges
6.Manipulate data in worksheets
- Paste data by using special paste options
- Fill cells by using Auto Fill
- Insert and delete multiple columns or rows
- Insert and delete cells
7. Format cells and ranges
- Merge and unmerge cells
- Modify cell alignment, orientation, and indentation
- Format cells by using Format Painter
- Wrap text within cells
- Apply number formats
- Apply cell formats from the Format Cells dialog box
- Apply cell styles
- Clear cell formatting
8. Define and reference named ranges
- Define a named range
- Name a table
9. Summarize data visually
- Insert Sparklines
- Apply built-in conditional formatting
- Remove conditional formatting
Manage Tables and Table Data
10. Create and format tables
- Create Excel tables from cell ranges
- Apply table styles
- Convert tables to cell ranges
11. Modify tables
- Add or remove table rows and columns
- Configure table style options
- Insert and configure total rows
12. Filter and sort table data
- Filter records
- Sort data by multiple columns
Perform Operations by using Formulas and Functions
13. Insert references
- Insert relative, absolute, and mixed references
- Reference named ranges and named tables in formulas
14.Calculate and transform data
- Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
- Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
- Perform conditional operations by using the IF() function
15. Format and modify text
- Format text by using RIGHT(), LEFT(), and MID() functions
- Format text by using UPPER(), LOWER(), and LEN() functions
- Format text by using the CONCAT() and TEXTJOIN() functions
Manage Charts
16. Create charts
- Create charts
- Create chart sheets
17. Modify charts
- Add data series to charts
- Switch between rows and columns in source data
- Add and modify chart elements
18. Format charts
- Apply chart layouts
- Apply chart styles
- Add alternative text to charts for accessibility
