Blog

November 25, 2021

Circular Referencing Solution

November 18, 2021

Printing tricks

November 11, 2021

Excel vs Tableau

November 5, 2021

GOOGLE PRO SEARCH

October 28, 2021

Working with Formulas in Excel

October 28, 2021

Working with Data Tables

October 21, 2021

The Double Negative

October 15, 2021

How to delete Alternate Rows

October 7, 2021

Excel Table & it’s Properties

What is an Excel table? An Excel Table is not just any range of data with headings, but a specific Excel object that unlocks additional properties. […]
September 30, 2021

Excel’s 5 Useful but rarely used Functions

May 19, 2021

5 POWER BI TRICKS THAT WILL BLOW YOUR MIND

April 27, 2021

Find & Replace with Wildcards

April 19, 2021

Filter Data using Wildcards

April 19, 2021

HOW TO DELETE ALTERNATE ROW

If we want to delete alternate rows from a data set, then the following steps can be performed to make our task easier instead of deleting […]
April 19, 2021

Repeat Function

December 13, 2019

November 2019 update

November 28, 2019

Wildcards

November 19, 2019

5 Things to avoid in MS Excel

While MS Excel can be a great tool to automate your work, save loads of time and make your work flexible, there are certain things that […]
November 13, 2019

5 GMAIL HACKS

November 5, 2019

Tired of using SUMIFS? TRY DSUM

When trying to sum values with conditions, SUMIFS has always been our go-to function. However, when there are too many conditions, going on adding criteria, selecting […]
October 23, 2019

Cut and Paste Using Spike

The Spike is a Microsoft Word function which allows you to remove two or more items (such as text or graphics) from non-adjacent locations in a […]
October 18, 2019

Spare 30 Seconds and get Insight to 6 Amazing Features of POWER BI!

October 4, 2019

Magic of Flash Fill

Flash fill is an awesome tool which magically fills data once it identifies a pattern. The tool justifies its name by executing a task that would […]
October 2, 2019

5 MS WORD HACKS TO MAKE YOUR LIFE EASIER

You think you know MS Word? Annoyed with formatting issues? MS Word can be an annoyance but a lot can be accomplished when used to its […]
June 17, 2019

Tired of Excel files running slow or getting stuck, or need better analytics on your data!!

POWER BI which includes Power Query, PowerPivot and Power View solves all the problem.     This can be used to systematically transform and consolidate financial […]
November 28, 2018

CTRL+ SHIFT Shortcuts

This video shows the amazing uses of CTRL+Shift shortcuts which reduces a great amount of time and improves speed. Now change numbers to other formats with […]
August 10, 2018

EXCEL TRICKS

October 23, 2019

Cut and Paste Using Spike

The Spike is a Microsoft Word function which allows you to remove two or more items (such as text or graphics) from non-adjacent locations in a […]
October 2, 2019

5 MS WORD HACKS TO MAKE YOUR LIFE EASIER

You think you know MS Word? Annoyed with formatting issues? MS Word can be an annoyance but a lot can be accomplished when used to its […]