Rarely Used but Very Useful Excel Tricks

Collection of rarely used Excel tricks that will help you solve common challenges you face while using Excel at work.
4.2 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
178 students enrolled
50% off
Coupon valid until Mar 1, 2017 7:59 AM UTC
Take This Course
  • Lectures 21
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

Course Description

This course is about being awesome in Excel. This will take you MS Excel skills to the next level. This is a collection of professionally record videos which are to the point and short.

Each video is about one trick which is generally unknown but is very useful.

This course is result of my huge experience of working as an analyst in big companies. I know which are the challenges that are faced on a regular basis and this course aims at making you aware of methods you can use to solve all these challenges.

This course takes a case by case approach where a problem is presented and a solution is demonstrated. There is no sequence to follow, just watch what you like and become awesome in Excel.

What are the requirements?

  • You need to have MS Excel and decent experience of working on it

What am I going to get from this course?

  • To make you Awesome in Excel

Who is the target audience?

  • Any level users of Ms Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Formatting tricks

How to show custom units like hours, man days, inches etc as texh in cells at the same time perform calculations on these cells.


Save time while formatting multiple tables using this rarely used Excel feature.


Use cell styles to add consistency to your models.

Displaying Ratios
Section 2: Being smart
Rounding to Multiples

This is the new function in Excel 2010, very powerful to have your Excel files and models error free.

Text and Value
Section 3: Charting

Create perceptual map easily in Excel.


How to create step chart in Excel.

Section 4: Removing Clutter

How to use data tables in Excel to get powerful analysis performed in minutes.


Why use Excel's new feature of Structured referencing to add ease of understanding to your models.

Using Named Constants
Section 5: Interesting functions
The convert function
Capitalization functions
Section 6: Time Saving

Use Excel's view side by side feature to compare workbooks and worksheets very quickly.


How to use this simple tricks and save a lot of time by filling in blanks cells. No macros.


Why i love you use the control key in my day to day work.

Section 7: Others

How to perform advanced string manipulations in Excel. Very useful in day to day workings in Excel.

PDF to Excel
Easy dropdowns

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tech Nitya, Software Training, Tutorials, Instructional Design

Founded by Amit Kumar, TechNitya.com is a London based professionally managed & committed training company.

TechNitya.com is proud of its team of high energy, passionate, and professional IT trainers/consultants drawn from drawn from both the world of academics as well as active industry practice with specialized knowledge in a variety of environments.

Amit Kumar, who is an MBA with more than 16 years of business management experience, is responsible for finding and recruiting experts around the globe in various domains and helping them turn their expertise into easy to follow and inexpensive courses/tutorials.

For further details…please feel free to contact us at the link below


Ready to start learning?
Take This Course