Microsoft Excel Blog
MENU
Skip to content

Please enter your Email-id

@
Subscribe Cancel

Excel In-Cell Charts

Excel In Cell Charts aren’t actually charts at all, insofar as you won’t find them in the Charts menu in Excel. They’re actually a formula that you can insert in… Read more »

Charts ; Graphs    Charts, Dashbaoards, Excel

Excel 2016 updated with new PowerPivot features

Microsoft’s Excel 2016 remains the premier spreadsheet solution for anyone who needs a powerful tool for analyzing and presenting complex data. While limited spreadsheet viewing and editing is available in… Read more »

PowerPivots    Pivot, PowerPivot, Powerpivots

Top 10 Most Useful Excel Formulas

SUM, COUNT, AVERAGE SUM allows you to sum any number of columns or rows by selecting them or typing them in, for example, =SUM(A1:A8) would sum all values in between… Read more »

Microsoft Excel    Excel, Excel Formulae, Formulas

Applying Filters to your PowerPivot Data Model

Within the PowerPivot Data Model editor, you can also filter the data that is returned to Excel through the filtering option. HOW TO DO IT To can add a filter… Read more »

PowerPivots   

Using PowerPivot to Create Dynamics AX Dashboards

PowerPivot gives you all of the capabilities that the Pivot Tables have, plus more. With PowerPivot you can create pivot tables and charts, and also dashboards with multiple panels showing… Read more »

PowerPivots   

VBA Code Bank – Convert Excel to XML

We can use VBA to convert and Save the Excel File as XML file. This can be used in Excel 2003,2007,2010,2013. Example to illustrate the concept: use the following Excel… Read more »

VBA Code Bank, VBA Macro Programming   

VBA Code Bank – Get the Name of all SubFolders for an Outlook Folder

In this post, I am going to show you how to pull out the outlook’s subfolders name to Excel. When you use VBA in an Office Application, in this example… Read more »

VBA Code Bank, VBA Macro Programming   

Best Hidden Tricks in Microsoft Excel

Most of us are probably familiar with Excel, but not knowing the shortcuts and tricks can turn any simple spreadsheet into a long drawn-out process. We have put together some… Read more »

Microsoft Excel    Excel, Microsoft, Tips, Tricks

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 »

Microsoft Excel    Excel Formulae

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 »

VBA Code Bank, VBA Macro Programming    Excel VBA, VBA Code

Post navigation

← Older posts
Newer posts →
03 - Jun - 2020 Excel VBA Macro Course

Recent Posts

  • How to Show Progress on Status Bar using VBA?
  • Open XML File in Excel
  • Why Vlookup when there is Index?
  • Merge text files using VBA
  • How to Reverse the Text in a Cell?

Archives

  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • April 2015
  • March 2015
  • February 2015
  • November 2014
  • October 2014
  • July 2014
  • April 2014
  • March 2014

Categories

  • Charts ; Graphs (4)
  • Dashboards (2)
  • Microsoft Excel (29)
  • PowerPivots (4)
  • VBA Code Bank (32)
  • VBA Macro Programming (34)

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Copyright 2016
Excelgoodies, Inc.
Ribosome by GalussoThemes.com
Powered by WordPress