fbpx
Search
Close this search box.

All articles with 'screencasts' Tag

Extract BOLD portion of a cell in Excel using getBoldText() function

Published on Feb 26, 2024 in Excel Howtos, VBA Macros
Extract BOLD portion of a cell in Excel using getBoldText() function

Use the getBoldText() function in Excel to extract bolded portion of a cell automatically. Saves you time and helps with data cleaning.

Continue »

How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]

Published on Feb 14, 2024 in Excel Howtos, Learn Excel
How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]

Do you want to create a dynamic dependent drop down list in Excel like below? You can use XLOOKUP and data validation to set this up quickly. It is fully dynamic and works across a full column too.

Continue »

35 shortcuts & tricks to make you an #AWESOME Data Analyst

35 shortcuts & tricks to make you an #AWESOME Data Analyst

Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.

So today let me share with you 35 shortcuts, productivity hacks and tricks to help you be even more awesome.

Continue »

Calculating Critical Path using Excel Formulas [Project Management]

Published on Oct 3, 2023 in Learn Excel, Project Management
Calculating Critical Path using Excel Formulas [Project Management]

Do you know that we can easily calculate the critical path for a project using Excel formulas?

For a long time, it has been tricky to calculate the Critical Path using Excel formulas. But thanks to the arrival of new Dynamic Array functionality in Excel, we can now calculate critical path. In this article let me describe the approach with an example.

Put on your hardhats, this one is going to blow your minds.

Continue »

When & how to use the 30+ chart types in Power BI?

Published on Jul 11, 2023 in Power BI
When & how to use the 30+ chart types in Power BI?

Power BI has a LOT of chart types. So, when & how to use these charts in data analysis situations? In this article, let me share my top tips for picking and using the right chart type for your needs.

Continue »

Make an Impressive Interactive Map Chart in Excel

Published on May 23, 2023 in Charts and Graphs
Make an Impressive Interactive Map Chart in Excel

Today, let’s learn how to make an impressive map chart with Excel. Something like this.

Continue »

Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)

Published on Mar 28, 2023 in Learn Excel, Templates
Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)

Create a beautiful & fully interactive todo list with Excel using this tutorial (or download the free todo list template). Impress everyone.

Continue »

#### in Excel cell

Published on Dec 10, 2022 in Learn Excel
#### in Excel cell

You open an Excel file and some cells show #### instead of the value. Here is a quick fix.

Continue »

How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)

Published on Nov 25, 2022 in Learn Excel, Power Query
How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)

Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.

Continue »

Filter one table if the value is in another table (Formula Trick)

Published on Nov 17, 2022 in Learn Excel
Filter one table if the value is in another table (Formula Trick)

I have an orders table and want to see only orders from a given list of products. We can use Excel’s FILTER function to do this.

Continue »

Mortgage Calculator with Extra Payments – Excel Download

Published on Sep 6, 2022 in Learn Excel, Templates
Mortgage Calculator with Extra Payments – Excel Download

Recently, we got a new mortgage. And I wanted to know the impact of “extra payments” on it. So I made an Excel calculator. Check it out ?

Continue »

How to create interactive tooltips in Power BI (step by step)

Published on Aug 8, 2022 in Power BI
How to create interactive tooltips in Power BI (step by step)

One of the easiest ways to impress your audience with Power BI is a tooltip. This simple idea can provide incredible value to the report readers and elevate your work to next level. In this easy tutorial, learn how to set up and work with tooltips in Power BI.

Continue »

Image Lookup – How-to show dynamic picture in a cell [Excel Trick]

Published on Dec 16, 2020 in Learn Excel
Image Lookup – How-to show dynamic picture in a cell [Excel Trick]

Do you ever want to have an image or picture lookup in Excel? Something like the depiction above.

In this article, learn how to set up an image lookup using Excel. You can use this to display staff details, product images or machine parts etc.

Continue »

9 Box grid for talent mapping – HR for Excel – Template & Explanation

Published on Nov 17, 2020 in Charts and Graphs, Learn Excel
9 Box grid for talent mapping – HR for Excel – Template & Explanation

9 box grid is a popular method for talent mapping. Download this free excel template for tracking and visualizing your employee performance & potential data.

In this article, I explain about powerful excel features like FILTER(), SORT() and CONCATENATEX() to create a similar 9 box talent map grid for your data.

Continue »

6 Must Know Line Chart variations for Data Analysis

Published on Oct 1, 2020 in Charts and Graphs
6 Must Know Line Chart variations for Data Analysis

Line charts in Excel are essential for trend analysis, spotting distribution and outliers. Use these 6 variations to get more out your line chart.

  • Indexed Line Chart
  • Sparklines
  • Spaghetti Line Chart
  • Smoothed Line Chart
  • Forecast Line Chart
  • Line Chart Combinations
Continue »