Secret Evaluate Function
Suppose you receive a spreadsheet with calculations, but the calculations are stored as text, for display purposes only, and not used to actually derive answers. Without wanting to reinvent the… Read more »
Author Archives: excelgoodies
How to Add Notes to Powerpoint Slides using VBA
This snippet converts the TextBoxes / Shapes with Text that are available in PowerPoint Slide to Notes Section. Sub Export_TextBoxes_AsNotes() Dim oPPT As Presentation Dim oSlide As Slide Dim oSlideShape… Read more »
How to Calculate Correlation Coefficients in Excel 2010?
In a business environment, the Excel analyst will often be asked to prove theories and test concepts, one of the common theories to test is whether there is any correlation… Read more »
VBA Code Bank : Create appointment in outlook calendar for different time zones
Three factors affect the scheduling of a meeting in Outlook: The computer’s clock setting (time). The computer’s local time zone setting, which consists of an offset value to Greenwich mean… Read more »
When to not use Autofill in Excel
Excel has its own autocomplete option that by default is switched on when you get Excel out the box. Depending on your task this feature can be a helpful one… Read more »
Put some spark in your Chart with Excel Sparklines
Excel Sparklines were introduced in Excel 2010 and are great for displaying the trend of data over time and making sense of a sea of numbers. Just take this before… Read more »
Calculate the % change
When creating reports with history, such as a weekly sales report, it is very useful to add a percentage change column against the data. It is useful for managers to… Read more »
How to convert a date into a month name?
Converting a date into a month name is an extremely easy thing to do in Excel, but like everything it is only easy if you know how There are a… Read more »
How to remove Page Breaks and Page Number watermark in Excel
A common problem for the Excel newcomer is how to remove the page number watermarks from an Excel worksheet along with the page breaks. It can be a distracting view… Read more »
Adding leading Zero to the Cell Value
If you need to add leading zeros to a value in Excel there are two methods that you can use, depending on whether the result you want is a numeric… Read more »