Excel Quick Tips

Focused View

Garrick Chow,Jess Stratton

48:49

100 View

01 - Introduction

01 - Get fast answers to common Excel questions.mp4

00:37

02 - Data Entry Tips

01 - Fill in a series of data.mp4

00:54

02 - Quickly insert multiple rows and columns.mp4

00:46

03 - Insert hyperlinks.mp4

00:59

04 - Create and manage drop-down lists.mp4

01:25

05 - Summing rows.mp4

01:00

06 - Work with stock and geography data types.mp4

01:21

07 - Fill in contents with Flash Fill.mp4

00:46

08 - Quickly insert a total.mp4

00:55

09 - Extract part of a cell's contents.mp4

02:39

03 - Working with Data

01 - Select specific rows or columns.mp4

00:50

02 - Find named ranges.mp4

00:41

03 - Change sort order.mp4

00:58

04 - Filter data.mp4

00:50

05 - Remove duplicate entries.mp4

01:44

06 - Convert formula values to plain numbers.mp4

00:45

07 - Transpose data from vertical to horizontal.mp4

01:35

04 - Formatting Tips

01 - Text wrap.mp4

00:46

02 - Rotate and align cell data.mp4

00:56

03 - Copy cell formatting.mp4

00:40

04 - Apply international currency formats.mp4

00:51

05 - Apply cell styles.mp4

00:46

06 - Page options.mp4

01:00

07 - Adjust row height and column width.mp4

00:54

08 - Add headers and footers.mp4

00:57

09 - Align cells.mp4

00:43

10 - Add a watermark.mp4

01:15

11 - Conditional formatting by cell contents.mp4

01:49

12 - Copy and paste cell formatting.mp4

01:40

13 - Merge cells.mp4

00:46

05 - Viewing Options

01 - Change magnification.mp4

00:56

02 - Freeze and lock panel options.mp4

01:03

03 - Hide and unhide columns and rows.mp4

00:46

04 - Show and hide grouped data.mp4

01:13

06 - Collaborating on Spreadsheets

01 - Insert and respond to comments.mp4

01:34

02 - Collaborate on an Excel file with others.mp4

01:50

03 - Highlight portions of a spreadsheet.mp4

01:19

04 - Draw and mark up spreadsheets.mp4

01:10

07 - Working with Files

01 - Set document recovery options.mp4

00:52

02 - Encrypt a workbook with a password.mp4

00:56

03 - Restrict editing.mp4

01:15

04 - Save as other file type.mp4

00:50

05 - Inspect a spreadsheet.mp4

00:39

06 - Check for compatibility issues.mp4

00:43

07 - Add and reference worksheets.mp4

00:47

08 - Lock cells.mp4

01:08

Description

More from LinkedIn Learning's top experts

Business Software Newsletter

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.

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.

Jess Stratton

Instructor's Courses

I am an instructor with LinkedIn Learning - With over 300 hours of instructional content on Lynda.com, my courses are specialized for businesses, home office, social media, and personal use focusing on Google Apps, Microsoft Office, home tech, and productivity/mobile apps. My writings have been in computer textbooks, and I have several published articles in industry magazines and major websites including Lifehacker.org. I'm a frequent speaker at large industry conferences about productivity, web, and Lotus Notes/Domino. I used to own and operate a successful brick-and-mortar boutique style computer learning facility in downtown shopping district. I LOVE my job. I get to help people be the very best at their own jobs.

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.