How to Create a Form Using Microsoft Excel 2007. There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code. A basic form can be very ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

Excel has evolved into a robust platform for data analysis and reporting, thanks to its advanced business intelligence tools: Power Query, Power Pivot, Data Model, and DAX. These powerful features can ...

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Learn essential Excel techniques to build robust financial models, forecast accurately, and impress stakeholders with your ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

Susan Harkins continues her review of Excel's analysis tools with Scenario Manager.

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.