Ranking with Pivot Tables is a hidden feature and is a extremely helpful when performing ad hoc analysis, this tutorial goes through a step by step guide on how to rank with Pivot Tables.
Sick of the standard colors that Excel have to offer? Have a read of how you can change these colors and how they can affect your standard and chart colors.
Find and Replace (CTRL+H) is probably the quickest way you can find and replace a certain string or set of characters in Excel, however when it comes to Excel functions there is nothing pre-built.
Here is a quick way to replace a string with a string using Excel functions.
Ever wondered how you can create a Pivot Chart and not have it in it’s own sheet? Read on!
In this tutorial I will go through how you can link a Pivot Chart in Excel to a PowerPoint presentation. I suggest you read a post I did earlier which is an overview on linking between Excel and PowerPoint.
Related Posts :
#DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE! are all error indicators that Excel produce when a formula or function is used incorrectly or produces an invalid result.
There is one method I use to hide these error indicators or replace them with your own values, and when your formula produces a correct or valid result the formula or function will revert to that value.
This tutorial will run through how you use an Excel Pivot Table with a MySQL database, before we begin please check out my Configuring your MySQL ODBC driver as this takes you through a step by step guide on how to set up an ODBC connection (for MySQL), if you have already done this and your connection has tested successfully - lets move on!
Related Posts:
In my tutorials on how to connect a Pivot Table to an Access database and an Oracle database I have gone through how you can set up an ODBC connection in great detail however I know a lot of people are starting to use MySQL a lot more and would like to use Office products such as Excel and Access with MySQL as well. This tutorial looks at how to configure an ODBC connection to a MySQL database which is either:
Related Posts:
This is the last part of the 3 part tutorial on linking PowerPoint to Excel. In this tutorial I will go over how you can link a chart in a PowerPoint presentation to one that you have built in an Excel worksheet.
Related : Part 1 - How to link an Excel worksheet to a PowerPoint presentation
Related : Part 2 - How to link a table in Excel to a PowerPoint presentation
Related : Part 4 - How to link a Pivot Chart in Excel to a PowerPoint presentation
Related : Part 5 - How to link a Pivot Table in Excel to a PowerPoint presentation
This is the 2nd part of my series on how to link a PowerPoint presentation to an Excel worksheet, in this tutorial I will run through how to link a table in PowerPoint to one that you have built in Excel.
Recent Comments