Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Draw a Logo with a Scatter Chart in Excel

Scatter Charts in Excel could be used for fun in situations where your boss is away and you have nothing else to do but learn the undoubted power of Microsoft Excel! I was just playing around with drawing lines, and I tried recreating my logo with an Excel Scatter Chart: You will just need a little Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Quick Reports Using Excel Custom Views

Whenever I wanted to print my Excel worksheet for a report, I usually had to trim down the data and do changes like hiding the columns so it could fit into one page. Other common scenarios would be, hiding employee salaries or filtering out specific customer data. It is cumbersome because after printing it out I had Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Data Type Conversions with M in Power Query

Power Query lets you perform a series of steps to clean & transform your Excel data. There are times when we want to do things that are not built in the user interface.  This is possible with Power Query's programming language, which is M. One of the unique characteristics of M is it takes data Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Group By Custom Dates With Excel Pivot Tables

In my previous Group By Month post, we grouped our Sales by each month. However the cool thing with Excel is that we can take that a step further and customize our grouped date range! In the example below I show you how to get the Sales Grouped by Custom Dates:   DOWNLOAD EXCEL WORKBOOK   STEP 1: Insert Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Clear Everything Before the Hyphen with Excel’s REPLACE Formula

What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the way to this number, with this new text) Once I was given a list of Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Smart Lookup in Excel 2016

  There were times when I was working in a spreadsheet and I had to do a quick internet search to understand some of the words in my cells. The process was, copy the text, paste on my browser, and click search. Little did I know that in Excel 2016, there is a feature called Smart Lookup! Smart Lookup Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Replicating Excel’s LEFT Function with M in Power Query

Power Query lets you perform a series of steps to transform your Excel data. There are times when we want to do things that are not built in the user interface. This is possible with Power Query's programming language, which is M. Unfortunately not all of Excel's formulas can be used in M. For example, if Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+
Searching... Searching...
Get better at Excel!

Do you want to get better at Excel?

If so, join over 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis & DOWNLOAD my 80 page Excel Resource Guide eBook for Free!