TagExcel tips and tricks

Sumifs Google Sheets – A detailed walkthrough & video tutorial

S

This tutorial is all about how to use SUMIF or SUMIFS formula in google sheets. Personally, I use Excel Sumifs formula all the time but the question is do we have a similar function in google sheets as well. Let’s find out. How to use Sumifs in Google sheets If you already know how to use sumif formula in excel then I think this will be a cakewalk. If not then no worries, I’ll walk...

Excel Sparklines – Add Thrust to your Analytical skills

E

Excel Sparklines is an excellent feature but unfortunately, not many people know how to use it. In this detailed tutorial, I’ll walk you through how you can use Excel sparklines to analyze your data quickly and effectively. How to insert Sparklines in Excel Step 1 : In excel 2016 click on Insert –> go to ‘Sparklines’ section Step 2 : Clink on the type of chart that you...

How to Solve Your Real Problems With Excel Goal Seek

H

We want to generate $1m Revenue in 2018 said by CEO. Well, that’s ambitious goal… Considering our current year Revenue is at $0.7m but how do we achieve that..? let’s see if we can use Excel Goal Seek to put some foundations. By the way, we are into Chocolate business. I’ll walk you through step by step on building various models to achieve 1m revenue target by using Goal...

10 Reasons for Excel Formulas not Working [and How to Fix Them]

1

“Oh My God” excel formulas not working in my report. Sounds familiar¬†right? If so, don’t worry, you are just one among many excel users who face this problem very often. Just think about it. You have built an excel model for Sales Forecast using various logics with fairly complicated formulas. [‘IF’ formulas with 64 conditions – just kidding] And when you try...