Excel Quick Tips

Focused View

Garrick Chow

48:49

0 View

01 Introduction

001 Get fast answers to common Excel questions.mp4

00:37

02 Data Entry Tips

001 Fill in a series of data.mp4

00:54

002 Quickly insert multiple rows and columns.mp4

00:46

003 Insert hyperlinks.mp4

00:59

004 Create and manage drop-down lists.mp4

01:25

005 Summing rows.mp4

01:00

006 Work with stock and geography data types.mp4

01:21

007 Fill in contents with Flash Fill.mp4

00:46

008 Quickly insert a total.mp4

00:55

009 Extract part of a cells contents.mp4

02:39

03 Working with Data

001 Select specific rows or columns.mp4

00:50

002 Find named ranges.mp4

00:41

003 Change sort order.mp4

00:58

004 Filter data.mp4

00:50

005 Remove duplicate entries.mp4

01:44

006 Convert formula values to plain numbers.mp4

00:45

007 Transpose data from vertical to horizontal.mp4

01:35

04 Formatting Tips

001 Text wrap.mp4

00:46

002 Rotate and align cell data.mp4

00:56

003 Copy cell formatting.mp4

00:40

004 Apply international currency formats.mp4

00:51

005 Apply cell styles.mp4

00:46

006 Page options.mp4

01:00

007 Adjust row height and column width.mp4

00:54

008 Add headers and footers.mp4

00:57

009 Align cells.mp4

00:43

010 Add a watermark.mp4

01:15

011 Conditional formatting by cell contents.mp4

01:49

012 Copy and paste cell formatting.mp4

01:40

013 Merge cells.mp4

00:46

05 Viewing Options

001 Change magnification.mp4

00:56

002 Freeze and lock panel options.mp4

01:03

003 Hide and unhide columns and rows.mp4

00:46

004 Show and hide grouped data.mp4

01:13

06 Collaborating on Spreadsheets

001 Insert and respond to comments.mp4

01:34

002 Collaborate on an Excel file with others.mp4

01:50

003 Highlight portions of a spreadsheet.mp4

01:19

004 Draw and mark up spreadsheets.mp4

01:10

07 Working with Files

001 Set document recovery options.mp4

00:52

002 Encrypt a workbook with a password.mp4

00:56

003 Restrict editing.mp4

01:15

004 Save as other file type.mp4

00:50

005 Inspect a spreadsheet.mp4

00:39

006 Check for compatibility issues.mp4

00:43

007 Add and reference worksheets.mp4

00:47

008 Lock cells.mp4

01:08

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

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.