Excel Quick Tips

Focused View

Garrick Chow

43:35

390 View

01 - Introduction

01 - Get answers to common Excel questions.mp4

00:31

02 - 1. Data Entry Tips

01 - Fill in a series of data.mp4

00:50

02 - Quickly insert multiple rows and columns.mp4

00:42

03 - Insert links.mp4

01:10

04 - Create and manage dropdown lists.mp4

01:37

05 - Summing rows.mp4

00:56

06 - Fill in contents with Flash Fill.mp4

00:49

07 - Quickly insert a total.mp4

00:55

08 - Extract part of a cells contents.mp4

02:40

03 - 2. Working with Data

01 - Select specific rows or columns.mp4

00:42

02 - Find named ranges.mp4

00:38

03 - Change sort order.mp4

00:49

04 - Filter data.mp4

00:45

05 - Remove duplicate entries.mp4

01:48

06 - Convert formula values to plain numbers.mp4

00:35

07 - Transpose data from vertical to horizontal.mp4

01:34

04 - 3. Formatting Tips

01 - Text wrap.mp4

00:54

02 - Rotate and align cell data.mp4

00:43

03 - Apply international currency formats.mp4

00:31

04 - Apply cell styles.mp4

00:48

05 - Page options.mp4

00:37

06 - Adjust row height and column width.mp4

00:50

07 - Add headers and footers.mp4

00:52

08 - Align cells.mp4

00:35

09 - Add a watermark.mp4

01:12

10 - Conditional formatting by cell contents.mp4

01:52

11 - Copy and paste cell formatting.mp4

01:32

12 - Merge cells.mp4

00:49

05 - 4. Viewing Options

01 - Change magnification.mp4

00:48

02 - Freeze panes.mp4

01:07

03 - Hide and unhide columns and rows.mp4

00:33

04 - Show and hide grouped data.mp4

00:58

06 - 5. Collaborating on Spreadsheets

01 - Insert and respond to comments.mp4

01:10

02 - Collaborate on an Excel file.mp4

01:19

03 - Highlight portions of a spreadsheet.mp4

01:06

04 - Draw and mark up spreadsheets.mp4

00:52

07 - 6. Working with Files

01 - Encrypt a workbook with a password.mp4

01:03

02 - Restrict editing.mp4

01:45

03 - Save as PDF or CSV.mp4

00:57

04 - Inspect a spreadsheet.mp4

00:45

05 - Check for compatibility issues.mp4

00:53

06 - Add and reference worksheets.mp4

00:47

07 - Lock cells.mp4

01:16

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Excel

Excel Analytics

Excel Dashboard

Excel Modeling

Excel Formulas and Functions

Excel Macros

Excel Charts

Excel Shortcuts and Tips

Garrick Chow

Instructor's Courses

Experienced Senior Staff with a demonstrated history of working in the internet industry. Skilled in Microsoft Office, Apple software, Audio Editing, Learning Management, Adobe Creative Suite, and Instructional Design. Strong media and communication professional with a Bachelor's Degree focused in English from Dickinson College.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.