- Learn hidden Excel features to improve your Excel experience and use it like a pro
- Free tutorial
- Rating: 4.5 out of 54.5 (501 ratings)
- 14,358 students
- 1hr 53min of on-demand video
- Created by Sandip Banerjee
English
What you’ll learn
- Microsoft Excel
- Excel Tips
- MS Excel
- Excel Productivity Tips
Requirements
- Microsoft Excel 2016 or later version is required to work on all tips
Description
Microsoft Excel is the most widely used spreadsheet program being used by users across the World. While this program is being widely used by millions of users, still full capability of this program is not known to majority of regular users. There are countless features and shortcuts are available within Excel which can help users to save precious time.
In this course I tried to cover such tips which I use on regular basis during my day to day work. I personally found these features very useful and helped me to be more productive.
I have tried to make all these features available in same place, so that it can help others also to be more productive while using MS Excel. Hopefully this will be helpful.
There are 3 sections in this course and each section contains 10 tips which will help you be more productive while using MS Excel. Tips in each of sections are not grouped in a specific order. I kept all tips random to avoid any monotonous flow. You can pick up any tip in any order as per your wish and requirement.
In case you have any question, please feel free to post in Q&A section. I will try to answer within 48 hours of time. Happy Learning.
Who this course is for:
- Excel users with some level of working knowledge
- Excel users who wants to learn time saving tips to improve productivity
Show less
Course content
6 sections • 31 lectures • 1h 52m total lengthCollapse all sections
Introduction1 lecture • 2min
- Welcome02:29
Excel Productivity Tips – Part 18 lectures • 30min
- Camera Tool05:40
- Add Line Break in Formula Bar01:56
- Advanced Copy-Paste using Office Clipboard04:38
- Navigate between Worksheets using Shortcut Keys01:08
- Flash Fill03:09
- Delete Blank Rows Quickly03:32
- Multi Level Row and Column sorting in Excel05:58
- Add Spark-lines03:39
Excel Productivity Tips – Part 26 lectures • 23min
- Paste Special – Transpose03:26
- Snap to Grid03:31
- Import data from a webpage05:31
- Status Bar Quick Calculations03:12
- Link Text Boxes to Cell01:26
- Number format for phone number and pin code/zip code05:33
Excel Productivity Tips – Part 39 lectures • 31min
- Invisible Text02:28
- Worksheet Grouping / Data Replicator03:22
- Advanced Transpose03:42
- XLStart Folder03:48
- How to use Slicers in Excel05:43
- Convert text to Numbers02:23
- Hiding Workbook Elements02:04
- Useful shortcut keys04:29
- Sort Data from left to right03:30
Excel Productivity Tips – Part 46 lectures • 25min
- Email as PDF03:25
- Quick Analysis of data within Excel03:40
- How to add blank rows after each data row03:16
- Custom views in Excel06:03
- EMBED Feature in Excel04:03
- Plot an average line to a chart04:31
Wrap Up1 lecture • 1min
- Thank You01:20
