|
|
Tips & Tricks
Tips & Tricks
Tip, Tricks and other interesting Excel related goodies
Thanks for visiting our site. Here we show some useful tips and tricks related to Excel. These tips and tricks are freely distributed to South Africans but everyone can register for them if they want. Send us an email asking to be put on the list.
This Months Tip- Can you do these tasks in Excel
It is one thing to know about the tools in Excel. It is another to know when and how to use them. Can you address the situation below or download the PDF file and see if you can figure out how to address these situations in the time/ click mentioned. Note that you DO NOT NEED VBA to do any of these tasks.
DOWNLOAD: HOW QUICK CAN YOU DO THESE EXCEL TASKS
Fill in the blank cells:
Many people who attend our courses have the following problem. They have a report that has gaps in the cells. Hours are spent copy and pasting each cell to the empty cells. You can do this in 2 to 3 minutes, with 3 clicks in 2 different ways.
So to get from the screenshot above to the screenshot below, what 2 ways can you use?
To test yourself, download this PDF and see if you can address these issues
DOWNLOAD: HOW QUICK CAN YOU DO THESE EXCEL TASKS
This book will give you the knowledge to halve the amount of work you do when using dates in your Excel spreadsheets. Short and to the point, it asks the types of questions that are commonplace in business and provides all the answers
|
Pivot Tables are one of Excels most important tools. Learn all the tips and tricks that will turn you into a Pivot Table professional
|
Pivot Tables are one of Excels most important tools. Learn all the tips and tricks that will turn you into a Pivot Table professional. Includes a book, spreadsheets and video clips
|
This application driven 3 day programme leads delegates through advanced Excel data analysis functions, explaining the function and its uses including pivot tables and graphing.
|
This application driven half day programme leads delegates through Microsoft Excel's Pivot Tables features.
|
Gain the required Excel 2007 Advanced knowledge to create complex business applications in Microsoft Excel. This series will teach you to analyse data, use formulae and apply filters.
|
Gain the required Excel 2010 Advanced knowledge to create complex business applications in Microsoft Excel. This series will teach you to analyse data, use formulae and apply filters.
| |
|
|