Excel Quick Tips (2020)

49mIntermediate2020-12-21

Authors

Garrick Chow

Senior Staff Instructor at LinkedIn Learning

Nick Brazzi

LinkedIn Learning Staff Author

Jess Stratton

LinkedIn Learning Staff Author, Tech Consultant

Course details

The most common questions about using Excel now have timely video answers. This set of quick tips provides helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, fixing a sheet you received, or getting tables ready for presentation. Each video is about one minute long, so you can jump in and get some helpful insights in no time.

Skills covered

Quick TipsSpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoft

Concepts

0. Introduction

01 - Get fast 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 hyperlinks
05 - Create and manage drop-down lists
06 - Summing rows
07 - Work with stock and geography data types
08 - Fill in contents with Flash Fill
09 - Quickly insert a total
10 - Extract part of a cell's contents

2. Working with Data

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

3. Formatting Tips

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

4. Viewing Options

31 - Change magnification
32 - Freeze and lock panel options
33 - Hide and unhide columns and rows
34 - Show and hide grouped data

5. Collaborating on Spreadsheets

35 - Insert and respond to comments
36 - Collaborate on an Excel file with others
37 - Highlight portions of a spreadsheet
38 - Draw and mark up spreadsheets

6. Working with Files

39 - Set document recovery options
40 - Encrypt a workbook with a password
41 - Restrict editing
42 - Save as other file type
43 - Inspect a spreadsheet
44 - Check for compatibility issues
45 - Add and reference worksheets
46 - Lock cells