Excel Quick Tips (2023)

Course details

The most common questions about using Excel now have timely video answers. This set of quick tips offers helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, applying conditional formatting, fixing a sheet, collaborating with your team, removing sensitive information from a file, getting tables ready for a presentation, and more. Join LinkedIn Learning staff instructor Garrick Chow as he provides on-the-spot solutions for some of the most common questions in Excel. Each video is about one minute long, so you can jump in and get some helpful insights in no time.

Concepts

0. Introduction

01 - Get answers to common Excel questions

1. Data Entry Tips

02 - Fill in a series of data
03 - Quickly insert multiple rows and columns
04 - Insert links
05 - Create and manage dropdown lists
06 - Summing rows
07 - Fill in contents with Flash Fill
08 - Quickly insert a total
09 - Extract part of a cell's contents

2. Working with Data

10 - Select specific rows or columns
11 - Find named ranges
12 - Change sort order
13 - Filter data
14 - Remove duplicate entries
15 - Convert formula values to plain numbers
16 - Transpose data from vertical to horizontal

3. Formatting Tips

17 - Text wrap
18 - Rotate and align cell data
19 - Apply international currency formats
20 - Apply cell styles
21 - Page options
22 - Adjust row height and column width
23 - Add headers and footers
24 - Align cells
25 - Add a watermark
26 - Conditional formatting by cell contents
27 - Copy and paste cell formatting
28 - Merge cells

4. Viewing Options

29 - Change magnification
30 - Freeze panes
31 - Hide and unhide columns and rows
32 - Show and hide grouped data

5. Collaborating on Spreadsheets

33 - Insert and respond to comments
34 - Collaborate on an Excel file
35 - Highlight portions of a spreadsheet
36 - Draw and mark up spreadsheets

6. Working with Files

37 - Encrypt a workbook with a password
38 - Restrict editing
39 - Save as PDF or CSV
40 - Inspect a spreadsheet
41 - Check for compatibility issues
42 - Add and reference worksheets
43 - Lock cells

Excel Quick Tips (2023)

Authors

Garrick Chow