1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

# CPD Courses- Gauteng

Based on our presentation to CPD Courses – Gauteng (see photos on Google+ or Facebook), below are the links to the appropriate video clips and downloads mentioned during the presentations, and the additional material provided.

If you want to assess your staff’s Excel skills send them to the free Excel Skills Assessments

If you have any particular items you want to cover, either ask at the presentations or email adrian@AuditExcel.co.za with what you want to find out more about.

To find out more about the public or inhouse courses we offer you can visit the Live Excel courses page or the Excel training dates.

We also provide regular tips and tricks via the blog or you can subscribe to our free newsletter.

As per the presentation, below the numbers relating to the parts of the course that may have interested you and a few more.

2. IF function and how to use it– a very important formula for creating conditions within a formula e.g. IF a tax payer is older than 65 do this otherwise that

General Excel Tips and Tricks

• 3- Grouping– Grouping columns and rows so that you can drill down into more detail or view only a summary e.g. annual versus monthly details
• 4- Navigating Excel Cells– how to quickly move around cells and jump between ranges of cells
• 5- Entering Dates and Times– shortcut to putting a date and time stamp onto an Excel file
• 6- Viewing multiple windows– for comparing different spreadsheets including how to view two sheets from the same spreadsheet at the same time
• 7- Show Formula– how to see all the underlying formula or to see the numbers being referred to by the formulas
• 8- Writing Paragraphs– Tricks in getting paragraphs of text to fit into the columns
• 9- Status Bar for Quick info– get a quick sum, average, count, max and min of a group of cells without calculations
• 10- Watch Window– watch one part of a spreadsheet while you work on another e.g. watch the total tax liability while you capture the income statement
• 11- Text to speech– get excel to read out lists of numbers for you to compare to a document

12- Cleaning up Data– Quick way to remove unwanted rows from a data dump from a client

13- Removing Duplicate Entries– new tool for removing duplicate entries in an Excel database

15- Calculate the working days between 2 dates– inbuilt function for determining the number of WORKING days between 2 dates

16- Data Validation– how to create drop down lists for use in templates

17- Transpose Cells from Rows into Columns or Columns into Rows– Easily converting rows into columns and columns into rows

18- Pivot Table introduction– quick introduction into Excel most powerful and important tool

19- Protecting cells in a spreadsheet– how to protect certain cells in a spreadsheet to avoid accidental (or malicious) changes

20- Goalseek to find the best answer– Lets Excel determine what the profit needs to be to achieve a certain level of tax

This and more is available in the training courses we offer. In House courses are also available. Contact adrian@AuditExcel.co.za for more information