Excel Quick Tips
- Offered byLinkedin Learning
Excel Quick Tips at Linkedin Learning Overview
Duration | 1 hour |
Total fee | ₹1,150 |
Mode of learning | Online |
Credential | Certificate |
Excel Quick Tips at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Excel Quick Tips at Linkedin Learning Course details
- 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
Excel Quick Tips at Linkedin Learning Curriculum
Introduction
Get fast answers to common Excel questions
Data Entry Tips
Fill in a series of data
Quickly insert multiple rows and columns
Insert hyperlinks
Create and manage drop-down lists
Summing rows
Work with stock and geography data types
Fill in contents with Flash Fill
Quickly insert a total
Extract part of a cell's contents
Working with Data
Select specific rows or columns
Find named ranges
Change sort order
Filter data
Remove duplicate entries
Convert formula values to plain numbers
Transpose data from vertical to horizontal
Formatting Tips
Text wrap
Rotate and align cell data
Copy cell formatting
Apply international currency formats
Apply cell styles
Page options
Adjust row height and column width
Add headers and footers
Align cells
Add a watermark
Conditional formatting by cell contents
Copy and paste cell formatting
Merge cells
Viewing Options
Change magnification
Freeze and lock panel options
Hide and unhide columns and rows
Show and hide grouped data
Collaborating on Spreadsheets
Insert and respond to comments
Collaborate on an Excel file with others
Highlight portions of a spreadsheet
Draw and mark up spreadsheets
Working with Files
Set document recovery options
Encrypt a workbook with a password
Restrict editing
Save as other file type
Inspect a spreadsheet
Check for compatibility issues
Add and reference worksheets
Lock cells
Excel Quick Tips at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Excel Quick Tips at Linkedin Learning Students Ratings & Reviews
- 4-51