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...]
How To Use The Quick Analysis Tool In Excel.
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...]
Your Data Is In Access But You Need To Create An Excel Report – Create An External Data Connection
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...]
Excel Tip – Identify All Cells In A Worksheet With Conditional Formatting
Don't forget to sign up to the Excel at Excel Newsletter for 3 FREE Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below. You will also receive a copy of my FREE EBOOK of my Top 50 Tips to help you Excel At Excel. I have been generating a lot of Excel worksheets the past few weeks, and a lot of them have conditional formatting, which got me thinking, it would be really useful to easily highlight any cells that … [Read more...]
Excel Tip – How To Embed YouTube Videos Into Excel.
I want to show you today how to easily insert a YouTube video into Excel. Why would I want to do that you may ask?. ..... Maybe you need to send a user a video on how to use the Excel worksheet, promote your YouTube channel or maybe you want to show a video when you are presenting using Excel. Yes that is correct you can demonstrate your Excel solution then show a video right there from Excel without having to come out of Excel and go into YouTube, press play..... It is really easy to … [Read more...]
Recommended Excel Resources
