Copy and paste into other worksheets

Copying and Pasting into other Worksheets This quick video will show you how to Copy and Paste into other Worksheets in Excel. Learn to move and copy data between worksheets on the same workbook. If you find your spreadsheet results misbehaving after a copy paste you...

Copy and paste into Word and PowerPoint

Copy and Paste into Word and PowerPoint This quick video will show you how to Copy and Paste from Excel into Word and PowerPoint. Learn to copy Excel spreadsheets tables and charts from Excel in Microsoft Word and PowerPoint. This is very useful when preparing reports...

Using Calculation settings

Using Calculation Settings This quick video explains how to use the Calculation Settings in Pivot Tables for Excel. The Options Tab in Pivot Table gives us a group called – Calculations. We can modify the functions used in the summary fields in our Pivot Table....

Turning on and off option in Show Group

Turning On and Off option in Show Group This quick video will show you how to display or hide items in a Pivot Table for presentation purposes. We can display or hide items in a Pivot Table for presentation purposes – this makes the Pivot Table easier to view without...

Extra Pivot Table options in Excel 2013

Extra Pivot Table Options in Excel 2013 This quick video will show you the difference between Excel 2010 and Excel 2013 Pivot Tables Excel adds a number of New Features in Excel 2013. Here you can find the differences between Excel 2010 and Excel 2013 Pivot Tables –...

Highlight Cell Rules

Highlight Cell Rules This quick video explains Highlighting Cells in Conditional Formatting in Excel. Highlight Cell Rules. Conditional formatting provides a powerful way to highlight data in a list. The foundation of conditional formatting are the rules you need to...