If you've never heard of Excel's Power Query feature, you're not alone. Here's how to get started using it and gain a huge productivity boost.

Microsoft Excel gives users the flexibility to configure data and perform very basic operations, such as addition, subtraction, multiplication, or division by using shortcuts or custom formulas. This ...

Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users ...

Now that you understand how to use the basic filter function in Excel, here’s a Microsoft Excel tutorial on using the Filter function with multiple criteria.

Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

This course is intended for experienced Excel 2013 users who have a desire or need to advance their skills by using larger data sets to simulate realistic work applications. Main concepts covered ...