There are still some openings in my upcoming Adult Continuing Education Excel classes starting early March 2022. Please see the links below if you are interested in taking a class. […]
You are browsing archives for
Category: Excel
How to add a Line Break in the concatenate() function.
In this short post I will show you how to add a line break into the concatenate() function. It my example I will show you how to create something like […]
How to insert a graphic object in Microsoft Excel
What is a graphic object in Excel terms? Excel graphic objects will display data with greater importance or visual appeal. There are 6 different types of graphical objects in Excel. […]
Common MS Excel Tips and Questions
Student Tips for Microsoft Excel For past, present an future students, below are some links to past articles for Tips and Tricks using Microsoft Excel. Many of these I have […]
Fall 2019 Classes
If you are interested in learning more about Microsoft Excel, Microsoft Word, WordPress or are looking to learn more about your pc please have a look at some of our […]
Excel Reconciliation and Decimal Precision
How to reconcile Excel with a payroll system? I had a past student bring in a problem spreadsheet that they could not reconcile with their Quickbooks Payroll totals. This student […]
How do you use Goal Seek in Excel?
How do you use Goal Seek in Excel? Goal Seek in Excel is a seldom used tool that can help you find the number of units of a product you […]
What is a Excel 3D Reference and How Do You Use One?
What is a Excel 3D Reference and How Do You Use One? Excel 3D References can come in handy when you need to perform a calculation on data located in […]
How to add a percentage column in a pivot table.
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 […]
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 […]