X

Video Tip: Microsoft Excel - Pivot Tables Show Report Filter

Video Tip: Microsoft Excel - Pivot Tables Show Report Filter

A quick 5 minute video in order to share a feature many are not aware of within Microsoft Excel; showing report filter pages within a Pivot Table. 

Video Tip: Microsoft Excel - Changing Date Format

Video Tip: Microsoft Excel - Changing Date Format

Learn how to change how the date appears within Microsoft Excel by changing the date format.

Video Tip: Microsoft Excel - Flash Fill

Video Tip: Microsoft Excel - Flash Fill

Increase your effeciency within Microsoft Excel by using flash fill.

Video Tip: Microsoft Excel - Moving Columns

Video Tip: Microsoft Excel - Moving Columns
Learn how to move entire rows and columns within Microsoft Excel without displacing any data.

You did WHAT with Excel?

You did WHAT with Excel?

Many consider Microsoft Excel to be the "swiss-army-knife of software" while others have no idea just how extensive its capabilities are. Travel deeper into this amazing, versatile productivity provider and expand your own portfolio of magic that you can work with Excel.

Find helpful worksheet data displayed onscreen (Excel 2016)

  • 3 December 2018
  • Author: Jonathan Scott
  • Number of views: 48
  • 0 Comments
Find helpful worksheet data displayed onscreen (Excel 2016)

Graphically display helpful worksheet data on screen with Excel 2016.

 

Convert units of measurement within your data (Excel 2016/2013/2010)

  • 5 November 2018
  • Author: Jonathan Scott
  • Number of views: 49
  • 0 Comments
Convert units of measurement within your data (Excel 2016/2013/2010)

Microsoft Excel’s CONVERT function provides an easy way to display your data in another unit of measurement. 

 

Select your dataset without all that clicking and dragging (Excel 2016/2013)

Selecting your dataset without clicking and dragging preview imageLearn faster ways to select cells, rows or columns in larger data sets, without scrolling or dragging your cursor.

Microsoft Excel Order Of Operations

Microsoft Excel Order of Operations preview imageExcel adheres to a strict order of operations when calculating formulas. Keep this order in mind when building formulas to ensure accurate results.

Excel: The More You Know, the More You Grow

Excel: The More You Know, the More You Grow preview imageMany observers have noted that most people who use Excel probably know about 10% of what it can do. Those who learn how to use more extract far more value from Excel and become far more valuable to their employers. Here are some directions for learning and earning more with the world’s most powerful spreadsheet.

RSS
12

Theme picker

Search