How to Customize Excel’s Quick Access Toolbar
In this Excel tutorial I walk through how to fully customize the Quick Access Toolbar in Microsoft Excel 2016, including how to add...
Continue reading
Excel
- Sort by: Latest
Formula for Calculating the Average in Excel
In this tutorial we will review the best method for finding an average in an Excel data set using the ‘Average’ formula.
Continue reading
How to Round Numbers in Excel
This tutorial explains how to use the rounding formula in Excel to round to the nearest decimal place, along with making formatting...
Continue reading
How to Create Formatted Tables in Excel Automatically
This tutorial teaches how to automatically generate tables in Excel 2010, including different ways to customize and manage those tab...
Continue reading
How to Calculate a Sum in Excel
This tutorial explains how to create sums using formulas in Excel 2010 for single column and multiple column spreadsheets.
Continue reading
Example of Getting Data from a Tab in Excel
This tutorial explains the formula for pulling in data from multiple tabs into a single worksheet. This can be a great way to summar...
Continue reading
How to Sort and Filter Data in Excel
In this tutorial we will analyze how to sort data and create filters to organize columns.
Continue reading
How to Merge Text Columns in Excel
In this tutorial I explain how to connect text columns in Excel for easier reading and organization.
Continue reading
How to Design and Format an Excel Spreadsheet
This tutorial teaches how to: Move cells, change cell colors, alter text orientation, add images, and change text color.
Continue reading
