Inserting and Deleting Worksheets in Excel- Instructions
Wednesday, October 02 2019
Inserting and Deleting Worksheets in Excel: Overview In this tutorial, you will learn about inserting and deleting worksheets in Excel. Inserting and deleting worksheets in Excel is a critical skill to possess when working with Microsoft Excel workbooks. To insert a single new worksheet to the right of the currently selected worksheet, click
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments
Change Worksheet Tab Color in Excel – Instructions
Monday, September 30 2019
Change Worksheet Tab Color in Excel: Overview You can change worksheet tab color in Excel, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Use a Top 10 AutoFilter in Excel – Instructions
Friday, September 20 2019
Use a Top 10 AutoFilter in Excel: Overview You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Goal Seek in Excel- Instructions and Video Lesson
Thursday, September 19 2019
Goal Seek in Excel: Overview You can use Goal Seek in Excel when you know the result you want a formula to return, but do not know the value needed to create the desired result. Anytime you have a situation where you know the result that you need to obtain, but are unsure of
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Freeze Panes in Excel – Instructions and Video Lesson
Wednesday, September 18 2019
Freeze Panes in Excel: Overview You can freeze panes in Excel to view data in two separate sections of a long worksheet simultaneously. You can freeze panes in Excel to freeze one or two sections of a worksheet to prevent scrolling. Then you can then scroll the unfrozen section of the worksheet to view
- Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019, Office 365
Sort a Table in Excel – Instructions and Video Lesson
Monday, September 16 2019
Sort a Table in Excel: Overview You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Create Calculated Columns in Power Pivot in Excel – Instructions
Thursday, September 12 2019
Create Calculated Columns in Power Pivot in Excel: Overview This lesson shows you how to create calculated columns in Power Pivot in Excel. You can create calculated columns and measures from the tables in the Power Pivot data model. Doing this lets you create table values that you can then add to PivotTables and
- Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019