|
|
|
Microsoft Excel Mastery
Increased productivity for people who use Microsoft Excel every day
with Sharon Connolly
Communication and IT skills trainer, and professional image consultant
Many of us use Microsoft Excel extensively in our work. Updating spreadsheets and manipulating data can take up a large amount of our working day, but few of us have ever had any formal training. If we have had training, chances are it may have been years ago and we are not up to date with the new features available.
This is a comprehensive hands-on workshop to teach you the best practice for all the simple things you do on a daily basis. It will also reveal ways to dramatically improve data analysis and manipulation. If you need to design an Excel spreadsheet or work with figures, Sharon will show you how you can easily revolutionise the way you work by in just one day.
Sharon Connolly has made this workshop different and unique by choosing subjects that are traditionally spread across more than one day with most training providers. She has put all the key topics into just one day, specially for you!
Who Should Attend?
Anyone who currently uses or needs to learn how to use Microsoft Excel and wants to improve their productivity and success at work. This workshop is non-technical with no jargon, and is suitable for all levels. All participants will benefit from this practical, intensive workshop.
Workshop Objectives
- Understand and customise Office ribbons.
- Uncover new Office features you never knew were there.
- Discover a multitude of shortcuts that will help you get through daily tasks quicker.
- Improve the visual presentation of your work with design tips, and learn how to manipulate graphics professionally.
- Keep abreast of changes and updates with document reviewing.
- Share data between more than one worksheet or book.
- Learn more advanced formulae for powerful calculations and data manipulation.
- Discover ways to manage and manipulate lists for powerful data analysis.
- Find out how to automate repetitive tasks with macros.
- Easily share Excel information with other Microsoft Office applications.
Methodology
The training is hands-on and instructor led. Each participant will have his/her own PC and will work though practical exercises to ensure everything learned is absorbed effectively and can be put into practice straight away. A comprehensive manual and shortcut cards are also included.
Workshop Highlights
Supercharging basic productivity
- 'Wow!' shortcuts for entering and editing text
- Autofill magic entering
- 10 Excel formulae you really need to know
- Basic calculations
- Formatting for professional presentation
- Managing printing
Working with multiple sheets and files
- 3D adding
- Linking data between sheets and files
- Grouping sheets
- Data consolidation
- Sharing data with other MS applications
More advanced formulae
- Conditional statements, ifs, nested ifs, conditional ifs
- Lookup and reference functions, Vlookup, index, match
- Text calculations, left, right, mid, trim, concatenate
- Summary calculations, countif, sumIf
Working with large amounts of data
- List filtering
- Subtotals
- Basic pivot table functions
Basic macros
- Recording and playing macros
- Running macros from the quick access toolbar
- Introduction to macro editing
| Date | To be confirmed |
| Time | 9am to 5pm |
| Venue | To be confirmed |
| Fee | S$395 |
| S$375* |
| (including refreshment breaks, buffet lunch and comprehensive workbook) |
| * This fee is applicable for 3 or more registrations from the same organisation |
About Sharon Connolly
Sharon Connolly started work as an IT trainer in 1990, in the days when computers didn't have a mouse and you needed to use two disks to start your word processing program. Sharon has trained thousands of people from a multitude of different companies and many different levels. Her ability to switch training styles from 'fast-paced technical wizardry' to 'gentle hand-holding for the terrified' means that she's always asked back for more, and has been looking after the IT training needs for some clients for over 15 years. In 2000, Sharon made what seemed an unusual decision to add image consultancy to her training and coaching repertoire. In today's age of social media and web conferencing, this unique blend of how to use technology effectively and project a professional polished online image puts her in a unique position. It means Sharon is the only person qualified to not only teach people how to become IT experts, but also look good while doing it.
“There is more to being a great trainer and simply having expert knowledge and sharing it, although obviously Sharon excels in both respects. What makes Sharon stand out is her ownership of the day. Completely prepared and therefore totally calm and able to focus on hosting taking an interest in the delegates. People clearly feel very at ease with Sharon, and as a result relax, enjoy their course and learn more.”
Joanna Hibbert
IT Manager
“I have worked with Sharon for the past 12 months in which time she has provided IT training to numerous employees. Sharon really understands our business and has personalised the courses she delivers to enhance the learning experience for our employees. The delegate feedback is always positive - Sharon is seen as the expert in IT training, is very personable and is a pleasure to work with. ”
Sharon Rees
Learning and Development Manager, Amazon
|
|
Home
