Author: John

The Complete List Of Excel Keyboard Shortcuts

This is a comprehensive list of Excel keyboard shortcuts. All shortcuts have been tested on Excel 2016.   Copy And Paste Ctrl + C Copy the active cell or selected range to the clipboard. Ctrl + D Copy and paste the cell directly above into the active cell (fill down). Ctrl + R Copy and paste the cell directly to the left into the active cell (fill right). Ctrl + V Paste the last item from your clipboard. Ctrl + X Cut the active cell or selected range. Ctrl + Alt + V Paste special. Ctrl + Alt +...

Read More

How To Build Your Pivot Tables

What questions do we want to answer about our data?   Let’s create pivot tables to answer these questions about our sales data. What were the total sales for each sales representative? What were the top 3 States for sales? What were the total sales for each region by quarter? How many of orders were there for each product? The great thing with pivot tables is it’s easy to answer questions like these about your data with just a few drag and drop actions.   Get The Starting Workbook   Creating a pivot table to answer our questions  ...

Read More

How To Transform Data by Example

Microsoft Excel has just released a cool new add-in called Transform Data by Example to help make cleaning and transforming data easier. This add-in will allow you to quickly standardize time and dates, names, postal addresses, email addresses and much more! All you need to do is provide a few examples and Excel will find the transformation function for you. It does this by searching its large index of sophisticated transformation functions from services such as GitHub, Stack Overflow, .NET and Bing Maps to find the best match.   How to Install the Add-In?   The add-in is only available for Excel 2016,...

Read More

How To Create A Pivot Table

In this tutorial, we’ll take you through the steps to create a new Pivot Table. It’s generally a good idea to turn the data for your pivot table into a Table first. This will make it easier to add data at a later time and update your pivot table in addition to the many other benefits of tables. You can read more about the benefits of Excel Tables here.   Get The Starting Workbook     Turn your data into an Excel Table. Select any cell in your data range. Go to the Insert tab. Under the Tables section select...

Read More

How To Export Your Data Into Separate Workbooks Based On The Values In A Column

Something that comes up time and time again in any kind of work is separating data out into separate workbooks based on the values of a field in the data.   Get The Completed Workbook Let’s say you have sales data for your company and you need to send each of the sales representatives in the company a copy of their sales. You might not want to share the entire set of data with each rep but just their own sales due to privacy concerns around their commission based compensation. To do this, we will need to take our original...

Read More

Follow Us

Free eBook

Recent Tweets

Categories

Pin It on Pinterest

50 Tips to Master Excel

Subscribe to our newsletter and get the FREE ebook!

40 plus keyboard shortcuts!

Packed with hidden features you won't find anywhere else!

Top time saving tips that will reduce your work!

Easy to follow illustrated tips!

Something for every level from beginner to pro!

Check your email to confirm subscription and receive your free book.