Lynda-Excel Quick Tips 2017

Lynda-Excel Quick Tips 2017
English | Size: 149.92 MB
Category: CBTs

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.

00 – Introduction
01 – Excel Quick Tips
Text wrap
Add and references worksheets
Change magnification
Freeze and lock panel options
Fill in a series of data
Select specific rows or columns
Set document recovery options
Quickly insert multiple rows and columns
Rotate and align cell data
Find named ranges
Copy cell formatting
Apply international currency formats
Insert hyperlinks
Merge cells
Apply cell styles
Create and manage dropdown lists
Page options
Hide and unhide columns and rows
Encrypt a workbook with a password
Summing rows
Adjust row height and column width
Restrict editing
Save as other file type
Add headers and footers
Lock cells
Change sort order
Check for compatibility issues
Align cells
Filter data

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.