Custom colors in Excel
Posted by schone on June 20th, 2008Sick 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.
Replace a string with a string in Excel
Posted by schone on June 19th, 2008Find 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.
Create a Pivot Chart not in its own sheet
Posted by schone on June 19th, 2008Ever wondered how you can create a Pivot Chart and not have it in it’s own sheet? Read on!
How to link a Pivot Chart to a Powerpoint Presentation (IV)
Posted by schone on June 17th, 2008In 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 :
Hide or replace Excel error values
Posted by schone on June 17th, 2008#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.
Using an Excel Pivot Table with a MySQL database
Posted by schone on June 15th, 2008This 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:
Configuring your MySQL ODBC driver
Posted by schone on June 12th, 2008In 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:
- Hosted locally
- or, hosted on a server on a LAN
Related Posts:
How to link a chart in Excel to a PowerPoint presentation (III)
Posted by schone on June 12th, 2008This 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
How to link a table in Excel to a PowerPoint presentation (II)
Posted by schone on June 11th, 2008This 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.
How to link a PowerPoint presentation to an Excel worksheet (I)
Posted by schone on June 10th, 2008This is part 1 of many tutorials on how to link cell values, tables and charts in a PowerPoint presentation to an Excel worksheet. This will be helpful when creating regularly updated presentations, for example: A quarterly business performance presentation. Once it is setup all you will need to do is update your Excel worksheet and it will flow through to your PowerPoint presentation … Yes, dynamic presentations!
This post will look at linking cell values.
Related Posts :
Recent Comments