60 results for: pivot table

What is Power Query and Why Should You Use It?

What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.

Analyze Data in Excel – AI Insights at Your Fingertips

Speed up your analysis in Excel with the Analyze Data button. It creates helpful reports for you using artificial intelligence.

Top 5 Excel Interview Questions

Make sure you know the answers to these Excel Interview questions before you go to your next interview. These are asked specially if you’re applying for data analyst jobs.

How to Switch Data in Columns to Rows in Excel with Power Query

Here is the easiest way you can switch data from columns to rows in Excel. It involves NO formulas, NO Transpose – just simply UNPIVOT with Get & Transform. After-all tabular data sets are easier to work with.

Excel Complex Lookup: Find Header

In this tutorial we tackle a complex lookup problem – how to return the header based on criteria in a matrix. I offer my solution using INDEX and SUMPRODUCT. We also cover alternative approaches proposed by the Excel community, including an interesting TEXTJOIN solution that is able to handle multiple match results.

Business Charts in Excel

Create Business charts that grab attention AND auto-update. Wow your coworkers and managers with smart time-saving techniques.

Excel Black Belt course cover

Black Belt Excel Package

What would your life look like if you became an Excel Black Belt?
You’ll get the best deal with this (cost savings) package. It will take you from Excel Newbie to Grand Master.

Google Sheets QUERY Function Explained

The Query function in Google sheets is one of the most powerful Google Sheets functions. It’s easy to learn if you follow the rules laid out in this tutorial. You’ll be ready to solve any data analysis problem in Google Sheets.

How to Use Microsoft Forms

With Microsoft Forms you can easily create surveys & quizzes to share with others. You can export the Microsoft Form results to Excel (You can also create an automatic connection between Forms and Excel online). Check out the complete tutorial to find out more.

How to Easily Import Data from Web to Excel

Quickly learn how to import data from a web page into Excel with these 2 practical examples. The advantage of importing data this way is that whenever the data on the website is updated, you’ll just need to “refresh” the data in Excel to get the latest information. It’s super easy!

Excel Shortcuts You SHOULD know!

Are you using all of these 20 Excel keyboard shortcuts in your daily work? They range from data navigation to auto sum, inserting the date and time and even moving rows of data and dropping them between other rows.

Why you Need This Feature Before Distributing Your Excel Files

Discover the Inspect Document feature in Excel. It is particularly useful when you collaborate on files with others. It helps you find hidden information in your workbook, such as comments, personal information, hidden sheets, rows and columns, etc.

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

  • Pinpoint the Excel skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill