Excel Pivot Tables are sometimes a mystery to users of Excel. In this example I am going to show you how to add a percentage (%) column into a pivot table. This column will calculate that rows percentage of the grand total. We will start with some sample raw data. In the worksheet above we […]
You are browsing archives for
Tag: Office 365
How to create a dual axis chart in Excel
Creating a dual axis chart In my opinion, charting in Excel is an art that needs to be practiced extensively to be an expert. As I demonstrate many examples in class I like to give additional info here for reference, for past, or future students. In this example I will show you how to create […]
How to insert a degree symbol in Microso...
How to Insert Degree Symbol in Microsoft Word I recently created a post on How to insert the degree symbol in Google Docs. The post received quite a few views so I figured I would create a similar post on How to Insert a degree symbol in Microsoft Word as well. Below is a simple […]
How to add a call out Arrow to an Excel ...
How to add a call out Arrow to an Excel Spreadsheet Lets pretend that you have an Excel Spreadsheet with an important number that you do not want your viewers to miss. How do you add a call out arrow to your spreadsheet? Below is our sample spreadsheet with a total under the last row […]
How to change background color of a page...
How do you change the page background color in Microsoft Word In wrapping up an Intro to Microsoft Word class I am teaching I received an email that asked how to change a page background color. This seems to be a simple question but it was not covered in our class book. I will post […]
How to calculate age in Excel
How do you calculate age using a formula or function in Excel To calculate age in Excel is relatively easy if you know the proper function to use. In this quick example I am going to use the today() function to perform some simple date math. In the below example we have a column of […]
Missing Row and Column Headings in Excel
Microsoft Windows Shortcut Keys
Microsoft Windows Shortcut Keys Reference Card For my students in the Introduction to Personal Computers classes (or any Microsoft software class realy), below is a good quick reference guide for using Microsoft Windows Shortcut Keys. This is very good for all Windows users to have handy as there are many shortcut keys to remember for […]
Excel vLookup Example
Excel vLookup Example While teaching Excel classes over the past few semesters I get many questions on how to perform certain fuctions in Excel. Below is another request for and Excel vLookup example. This is for a student that needed this for real world work. My student had two lists of customers. The first was […]
Office 365: One License, Five Devices
#Office365: One License, Five Devices View: Office 365: One License, Five Devices Also visit our Amazon Local Associates Page