• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Excel Tips& Tricks

Drill Down Option In Excel Pivot Table.

January 21, 2021 by Barbara

Hello, Excellers. Welcome back to another #Excel Tip blog post. This Pivot Table blog will take you through the Drill Down feature in Excel Pivot Tables. When you create a Pivot Table in Excel, each of the values represents one line of data or record in that data set. The Pivot Table creates a summary of your data set. Let's use an example in this blog post. You can download the sample data set and Pivot Table, by clicking the download button below. I have a very simple data set and … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Pivot Tables Tagged With: Excel Tips, Excel Tips& Tricks, Pivot Table

Excel Formatting Trick To Merge without Merging.

January 12, 2021 by Barbara

Hello Excellers, and welcome back to another #Excel blog post in my 2021 series. Today I will show you how to achieve the same effect in Excel, without actually merging cells in Excel. Confused?. Don't be. Do you use merged cells in your Excel worksheets?. Have you come across issues when you try to write formulas such as XLOOKUPS and VLOOKUPS. Well, those merged cells are probably causing the issues. We can use Center Across Selection as a great alternative. Some while users love … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Tutorials Tagged With: Excel Tips, Excel Tips& Tricks

Remove Duplicates With Power Query.

October 1, 2020 by Barbara

Hello Excellers. Today I will share with you a great Excel tip. How to remove really quickly duplicate data records using Power Query. Power Query (previously called Get & Transform) in Excel 2016 is a really easy way to manage your data, and removing duplicate records is one of those easy tasks. See a sample set of Excel data in the screen grab below. Let's take a look at how easy it is to use Power Query to resolve the duplicate rows of data by following the steps … [Read more...]

Filed Under: Blog, Excel Business Intelligence, Power Query Tagged With: Excel Tips, Excel Tips& Tricks, excel tutorials

How To Use The Quick Analysis Tool In Excel.

September 29, 2020 by Barbara

From Excel 2013 onwards, the quick Analysis Tool makes it really easy to analyse your data quickly and easily. It contains a variety of Excel tools. The tool can be used with data from a range of cells or an Excel data table. How To Access The Quick Analysis Tool. So, it is really easy to get started with the Quick Analysis tool. Once you select a range of cells or an Excel data table, the tool appears at the bottom right of your data set. A range of analysis tools is now available to … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks Tagged With: Excel Tips, Excel Tips& Tricks, excel tutorials

Your Data Is In Access But You Need To Create An Excel Report – Create An External Data Connection

October 25, 2017 by Barbara

If you have data stored outside of Excel, such as an Access Database, SQL Server or and OLAP Cube then you can still use a Pivot Table to analyse this data, yes all you need to do is connect to this data as an 'external data source' and Voila!, you can use the familiar and powerful features of an Excel Pivot Table. I am going to connect my Pivot Table to the Northwind Access database which I have downloaded to my machine. (Northwind is the example database that Microsoft Provides, and is a … [Read more...]

Filed Under: Blog, Excel Tips& Tricks Tagged With: Blog, Excel Tips& Tricks

  • 1
  • 2
  • Next Page »

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Popular Pages

  • Home

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Follow Us

Search

© howtoexcelatexcel.com. All rights reserved.

  • Privacy Policy