Mon, Apr 19 2021

Trending
  • Over 2,500 Workplace Professionals listed on OSW List
  • Over 11,000 Coworking locations listed on OSW
Open Sourced Workplace

Vote for this video!

Author: ADMIN
Title: Top 25 Excel 2016 Tips and Tricks
Category: Collaboration
Description:

The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly. My personal favorite is #21. Become more productive using Excel at work, school and home.

 
Check out the Advanced Excel video at https://youtu.be/PU8ACyYxJBk.
 
Another 15 Excel 2016 Tips & Tricks: https://youtu.be/L9SKTj2gevA
 
Introduction to Excel for Beginners: https://youtu.be/WxUQLHJn77Q
 
Contents: 1. Quick Analysis Tool 0:47
 
2. Filter 1:44
 
3. Drop-Down List 2:25
 
4. AutoFit Column Width 3:12
 
5. Transpose 3:47
 
6. Remove Duplicates 4:13
 
7. Goal Seek 5:23
 
8. VLOOKUP 6:55
 
9. Flash & Auto Fill 9:06
 
10. Paste Special Values 10:47
 
11. Images in Charts 11:50
 
12. IF Function 12:28
 
13. Insert Screenshot 13:40
 
14. Absolute Cell Reference 14:15
 
15. Show Formulas 15:54
 
16. Text to Columns 16:57
 
17. Conditional Formatting 18:11
 
18. PowerPivot 19:36
 
19. Freeze Panes 20:46
 
20. Ctrl-Arrow Keys 21:40
 
21. 3D References 21:58
 
22. Forecast Sheet 23:43
 
23. SUMIFS Function 24:16
 
24. IFERROR Function 25:38
 
25. Filled Maps 26:30

Votes: 0
Views: 375

There are no comments.

Subscribe to newsletter

Recent Joins

Question Of The Day

What is the main business driver for workplace professionals post-vaccine?

  • Deeper alignment with HR
  • Focus on technology and digitization
  • Focus on employee health and wellbeing
  • Owning the workplace experience
  • Development and deployment of a new workplace strategy
  • Sustainability & Environmental initiatives
  • Cost containment and reductions
Submit

Question & Answers

My Tip of the Day

Contribute Your Content Here

Top Articles

50 Best Office Christmas Decorating Ideas 50 Best Office Christmas Decorating Ideas
Oct 19 2019
25 Types of Hazards in the Workplace And How To Prepare 25 Types of Hazards in the Workplace And How To Prepare
Mar 04 2019
25 Problems with Social Media in the Workplace (Employee and Employer Adverse Effects) 25 Problems with Social Media in the Workplace (Employee and Employer Adverse Effects)
Jul 03 2019
100 Least Stressful Jobs (Find a Peaceful Work Experience That Fits You) 100 Least Stressful Jobs (Find a Peaceful Work Experience That Fits You)
May 30 2019
What is Office Etiquette and Why is it Important? What is Office Etiquette and Why is it Important?
Apr 07 2019
Are Employee Engagement Surveys Really Confidential? (Flaws and Can You Get Fired) Are Employee Engagement Surveys Really Confidential? (Flaws and Can You Get Fired)
May 02 2019

Subscribe to newsletter

Contribute to Open Sourced Workplace Platform

Contribute

Contact Open Sourced Workplace

Contact

Open Sourced Workplace

Mission Statement

Open Sourced Workplace is a community for business owners and workplace professionals seeking to share information, knowledge, insights and experiences for the collective purpose to maximize employee experience for every employee no matter their function, where they work or who they work for.

Open Sourced Workplace will endeavor to provide products and services that add value, remove friction and promote this goal.

© Copyright 2021, All Rights Reserved