Yawn-proof software training

Software Training Blog

Tips and tricks for MS Office, PCs and Macs

3 New Features in Excel 2016

Microsoft has a few new features in the works for Excel 2016, from business insight and analysis tools, to new eye-catching, page popping charts.  Here are three features to get excited about.    1. "Tell me" -- Granted, this feature i...Tell Me
Power Query
Waterfall
Histogram
Box and Whisker
Treemap
Sunburst
Continue reading
  1864 Hits
  0 Comments
1864 Hits
0 Comments

Splitting or Separating Data in Columns - And a new Quick Tool in Excel 2013

My clients come to me with a variety of questions when it comes to their software and files. One of the more common requests I get is for “cleaning” data files that need to be sorted and formatted for import to a given program. They will supply me wi...Excel 2013-Text-to-Columns-Sample-Data
Excel 2013-Insert-column
Excel 2013-Text-to-Columns-start
Excel-2013-Text-to-Columns---Data-Ribbon
Excel 2013-Text-to-Columns---step-1
Excel 2013-Text-to-Columns---step-2
Excel 2013-Text-to-Columns---step-3
Excel 2013-Text-to-Columns-complete
Excel 2013-Text-to-Columns---comma
Excel 2013-Text-to-Columns-start
Excel 2013-Flash-Fill
Excel 2013-Flash-Fill-Complete
Continue reading
  2293 Hits
  0 Comments
2293 Hits
0 Comments

Excel for Mac 2011 VS. PC 2010

It wasn’t long ago that the lines were pretty well defined for what computer platform a user would have to choose in order to run a particular piece of software. The Microsoft Office suite seemed to demand being run on a Windows PC, while design soft...
Continue reading
  2121 Hits
  0 Comments
2121 Hits
0 Comments

EXCEL - Conditional Formatting

When we talk about Conditional Formatting in Excel, we're not *only* talking about changing the font style or colour of a cell. Conditional Formatting is a handy tool that enables Excel users to quickly analyse and highlight specified data or determi...Excel-Condtional-Formatting--Sample-Data
Excel-Condtional-Formatting--Highlighting-Cells-Menu
Excel-Condtional-Formatting-Highlight-Cells-details
Excel-Condtional-Formatting--Clear-Conditional-Formatting
Excel-Condtional-Formatting--Icon-Sets-and-More-Rules
Excel-Condtional-Formatting--Formatting-with-icons
Excel-Condtional-Formatting--Create-new-rule
Excel-Condtional-Formatting---Shading-alternate-rows
Continue reading
  27379 Hits
  0 Comments
27379 Hits
0 Comments

EXCEL - Getting Started with PivotTables

Creating PivotTables with Microsoft Excel allows user to quickly sort and summarize large amounts of data. This tool is particularly useful for databases with duplicate values, e.g. City, Colour, Style, etc., and those that include numeric values e.g...Excel-PivotTables-starting-table
Excel-PivotTables-select-cell
Excel-PivotTables-Insert-PivotTable
Excel-PivotTables-Create-Pivot-Table-Window
Excel-PivotTables-New-PivotTable-Display
Excel-PivotTables-Select-Fields
Excel-PivotTables-Value-Field-Settings
Excel-PivotTables-Edit-Value-Field-Settings
Excel-PivotTables--sample-2
Excel-PivotTables-Sample-2-Filter
Continue reading
  2406 Hits
  0 Comments
2406 Hits
0 Comments
Book

How To Choose a Software Trainer They'll Thank You For

Survey says: "Sitting through software training is painful".

Knowing how to use MS Office and knowing how to train people to use it are two different things. Download this Special Report and discover how to choose a trainer that leaves your employees feeling useful.

  • Claire Langfield, Executive Assistant

    Chippewas of Rama First Nation

    The majority of my computer training focused on Publisher. I have received positive comments and feedback from several of my colleagues on the changes between my first attempt and current expertise creating the monthly internal newsletter for my department. They enjoy the updated format and the way in which the information is presented. 

    Deborah assisted me through a learning curve, as I had not previously had any exposure to this program prior to joining Rama. She also provided me with a refresher course on PowerPoint and Excel.  Deborah is a patient teacher and tailored the training to suit my job requirements.