Presentations are an important part of many business conferences and meetings, and companies all across the globe use Microsoft PowerPoint to build and display their slideshows. While PowerPoint ...

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.

10 ways to reference Excel workbooks and sheets using VBA Your email has been sent Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

So, you need some eye-popping visuals to show off your top sales numbers for that meeting in 40 minutes but data, not design, is your forte. No problem. With Excel 2013—even if you’ve never used ...

Excel, VBA, basic math skills and background finance knowledge provide a good foundation for using financial models. Suitable for financial projections of all types, models identify and display ...

You have prepared a presentation using 12 months of sales data for your client, Dynamo Co. After everyone is gathered, the client’s CEO says she has more recent sales figures available and asks ...