Rarely Used but Very Useful Excel Tricks
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.
181 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Rarely Used but Very Useful Excel Tricks to your Wishlist.

Add to Wishlist

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.
181 students enrolled
Created by Tech Nitya
Last updated 4/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To make you Awesome in Excel
View Curriculum
Requirements
  • You need to have MS Excel and decent experience of working on it
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.

Who is the target audience?
  • Any level users of Ms Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Formatting tricks
4 Lectures 09:08

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

Preview 02:08

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

Preview 00:58

Use cell styles to add consistency to your models.

Preview 04:23

+
Being smart
4 Lectures 07:21

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

Aggeregate Function
01:55

Text and Value
01:26

Transpose
02:19
+
Charting
2 Lectures 07:54

Create perceptual map easily in Excel.

How to create a perceptual map in Excel
04:54

How to create step chart in Excel.

How to create a step chart
03:00
+
Removing Clutter
3 Lectures 08:29

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

Data tables
02:19

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

Structured referencing
04:43

Using Named Constants
01:27
+
Interesting functions
2 Lectures 02:59
The convert function
01:48

Capitalization functions
01:11
+
Time Saving
3 Lectures 07:34

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

Compare sheets and workbooks quickly
02:20

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

Fill blanks quickly
01:53

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

Why you should love your Control Key
03:21
+
Others
3 Lectures 06:59

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

Advanced text extraction from strings
04:09

PDF to Excel
01:35

Easy dropdowns
01:15
About the Instructor
Tech Nitya
4.4 Average rating
16 Reviews
436 Students
3 Courses
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

http://technitya.com/contact