Rarely Used but Very Useful Excel Tricks
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.
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.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
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.
|Section 2: Being smart|
Rounding to MultiplesPreview
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
|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
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