25 Most used shortcuts in Excel if you are a Data Analyst
Most used shortcuts on Excel in order of their usage on an average.
Using Offset Function in Excel
This article shows you how to use offset function in excel in an easy and interesting way.
Limitation of Vlookup and How to overcome it by Using Index and Match Function (Upskill Tutorial on
Learn how to use Index and Match instead of Vlookup with a very simple Example
Using HTML Colors in Excel
Working with colours in excel sometimes might challenge your creativity. Though the colour palette has millions of colours to choose but...
Excel Demo Video
Please watch a demo on using Excel features to simplify daily activities. Enroll today for excel class. #video
Text Functions - Advance Excel
There are hundreds of formulas in Excel. In this post I would like to cover some of the Text Functions in Excel. Assumption: A1 has a...
Bye Bye Sugar Sync! Hi Bitcasa Backup
Well there are many cloud storage services but most of them require you to upload your files for backup. They overlook the fact that we...
Application Object VBA
Application object contains application-wide settings and options. Below are few commondly used codes to control events using Application...
Excel Workbook Index Page Creator - Upskill Technologies
With excel spreadsheets being used everywhere it’s a common scenario that you will have too many sheets in a workbook and it gets...
Upskill Invoice Generator
Often comes a time when you want to send an invoice for your services to get paid. If you are a freelancer or contractor then you would...
