Excel Tip – Total Multiple Columns at Once

If you have columns similar to the example below there is an easy way to total them all at once. Select the empty cells beneath each column (where you want to see the answer). Click in the cell beneath the first column, hold down Ctrl and click on the cell underneath...

Excel Tip – Very Tiny Charts

In Excel there will be occasions where you would like to show the trend of data, but have no room for a chart. There is a feature in Excel that can solve your problem . . small charts that fit into one cell! They are called Sparklines, which include line charts and...

Virtual Training With a Live Instructor

The advent of virtual environments now makes possible live direct interactive training between a remotely located instructor and student(s) who remain at their office or home. Compared to non-interactive text or video based instruction, virtual instructor-led courses...

Excel Tip – Countdown to your Birthday Next Year

Open an Excel spreadsheet and in cell A1, type your birthday for next year, such as 7/7/2016 In B1 key in this function   =today()       (Computes the current date) In C1 type this formula      =A1-B1     and press Enter to finish Click in C1 and enlarge this cell,...

Excel Tip – Scale To Fit

Ever have one of those spreadsheets that do not quite fit on one page, no matter what you do! There is a simple way to make it fit. When you have your spreadsheet open click on the Page Layout tab and go to the Scale to Fit group. If your spreadsheet is too long then...

Mastering Excel Formulas (very valuable for Excel users)

IF you use Excel this class is a ‘must take’. In only 3 hours you can master the mysteries of Excel formulas with Software Savvy’s highly focused, hands-on training class. From creating basic formulas to working with IF Statements and VLookup functions … and...