Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Add the Calculator to the Excel Toolbar

There were times when I had to find my Calculator App while I was doing some quick calculations in Excel. Instead of scrambling for the Calculator Application, you can actually have this inside of Excel! Excel has a lot of customizations and one handy tool is to include the Calculator application in the Excel toolbar. You can Continue Reading

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

Remove Second Hyphen with Excel’s SUBSTITUTE Formula

What does it do? Substitutes new_text for old_text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, [instance num]) What it means: =SUBSTITUTE(This cell, By this text character, To this text character, [In the 1st, 2nd…instance it occurs]) There are times where I needed to remove the nth occurrence from my text.  For example I would Continue Reading

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

Getting Started 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. To start off, we will do a simple example of merging the first Continue Reading

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

Group By Half Years With Excel Pivot Tables

  In our previous post, we were able to Group by Month using Pivot Tables.  Let us take it up another notch, and group it by Half Years! In the example below I show you how to get the Sales Grouped by Half Years: January to June and July to December   DOWNLOAD EXCEL WORKBOOK   STEP 1: Insert a Continue Reading

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

Create a Data Entry Form in Excel

  Whenever I wanted to input data for my Tables in Excel, I would have a long time inputting the records one by one.  I discovered a handy trick in Excel that can turn my Table into a handy Data Entry Form! Say goodbye to inputting data into this Table row by row by row by Continue Reading

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

Fill Down Values Using Power Query

Power Query lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to fill data down easily. You might be wondering when you might need to fill data down in your table. Let's suppose you have this set of data: A lot of values Continue Reading

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

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!