7 Sections
43 Lessons
60 Minutes
Expand all sections
Collapse all sections
Introduction
1
1.1
01. Get answers to common Excel questions
Data Entry Tips
8
2.1
01. Fill in a series of data
2.2
02. Quickly insert multiple rows and columns
2.3
03. Insert links
2.4
04. Create and manage dropdown lists
2.5
05. Summing rows
2.6
06. Fill in contents with Flash Fill
2.7
07. Quickly insert a total
2.8
08. Extract part of a cells contents
Working with Data
7
3.1
01. Select specific rows or columns
3.2
02. Find named ranges
3.3
03. Change sort order
3.4
04. Filter data
3.5
05. Remove duplicate entries
3.6
06. Convert formula values to plain numbers
3.7
07. Transpose data from vertical to horizontal
Formatting Tips
12
4.1
01. Text wrap
4.2
02. Rotate and align cell data
4.3
03. Apply international currency formats
4.4
04. Apply cell styles
4.5
05. Page options
4.6
06. Adjust row height and column width
4.7
07. Add headers and footers
4.8
08. Align cells
4.9
09. Add a watermark
4.10
10. Conditional formatting by cell contents
4.11
11. Copy and paste cell formatting
4.12
12. Merge cells
Viewing Options
4
5.1
01. Change magnification
5.2
02. Freeze panes
5.3
03. Hide and unhide columns and rows
5.4
04. Show and hide grouped data
Collaborating on Spreadsheets
4
6.1
01. Insert and respond to comments
6.2
02. Collaborate on an Excel file
6.3
03. Highlight portions of a spreadsheet
6.4
04. Draw and mark up spreadsheets
Working with Files
7
7.1
01. Encrypt a workbook with a password
7.2
02. Restrict editing
7.3
03. Save as PDF or CSV
7.4
04. Inspect a spreadsheet
7.5
05. Check for compatibility issues
7.6
06. Add and reference worksheets
7.7
07. Lock cells
Excel Quick Tips (2023)
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Modal title
Main Content