Loading...

Follow Settingbox.com – Excel Tips & Tricks to analyse your data on Feedspot

Continue with Google
Continue with Facebook
Or

Valid



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 ... Read more

The post How to Solve Your Real Problems With Excel Goal Seek appeared first on settingbox.com - Excel Tips & Tricks to analyse your data!.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

People who use Pivot Tables regularly knows this issue very well. ….i.e. manually refreshing pivot tables in your workbooks. It’s perfectly alright to use the manual method if you have one or two pivot tables in your reports. …but what if you have 5 to 10 pivot tables and then you will need to refresh all ... Read more

The post Simple Yet Powerful Macro to Refresh All Pivot Tables In Your Workbook appeared first on settingbox.com - Excel Tips & Tricks to analyse your data!.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

If you haven’t used excel data validation drop down list in your reports then you are mostly missing something “really big”. The combination of well-structured drop down list and formulas like Indirect, Sumifs & Vlookup are the deadly combinations for Excel dashboards. So, in this step by step tutorial, I’m going to cover how to ... Read more

The post How to Create Appealing Excel Data Validation Drop Down List appeared first on settingbox.com - Excel Tips & Tricks to analyse your data!.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The are a lot of issues in Excel. The most annoying one is “Excel cannot create or use the data range too complex”. I’m sure, by referring above sentence you will not be able to figure out route cause of the problem. Then, what will you do? You will google it… ….there will be some ... Read more

The post [Solved] Excel cannot create or use the data range too complex appeared first on settingbox.com - Excel Tips & Tricks to analyse your data!.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

“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 ... Read more

The post 10 Reasons for Excel Formulas not Working [and How to Fix Them] appeared first on settingbox.com - Excel Tips & Tricks to analyse your data!.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This is the largest collection of best excel tips and tricks on the web. I know, you have got a lot of advice out there about various excel tips and tricks, but you still tend to crave for more, aren’t you? The reason is very simple. Microsoft excel is not just a piece of software, it’s ... Read more

The post 51 Best Excel Tips and Tricks = Professional In Excel appeared first on settingbox.com - Excel Tips & Tricks to analyse your data!.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In this step by step tutorial, we are going take a look at how to split first and last name in excel with detailed examples. Data mining is a cumbersome work! You need to have a better understanding of various excel text formulas and tools like the Text to Columns to deal with the situation. If you ... Read more

The post How to Split First and Last Name in Excel [with examples] appeared first on settingbox.com - Excel Tips & Tricks to analyse your data!.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free year
Free Preview