If you work in an office, chances are you use Microsoft Excel frequently. In fact, you may spend a whole day working on one workbook with its various spreadsheets. Discover how Microsoft Excel training can help you to increase your productivity by mastering the tips and tricks to reduce the amount of time you take to complete a task.
Course Objectives:
- Building knowledge and developing your skill with the aim of finishing with a spreadsheet set
up just how you want it. - Saving time and simplify work, thus boosting your staff work productivity.
- Helping you and your organization making better, smarter decisions.
- Learning the tips and shortcuts.
Venue
In-House Training
Who Should Attend:
Individuals who are interested to learn more on financial topics available such as Financial Functions.
Pre-requisite before Attending the Class
Individuals should have an understanding of any of the following operating systems: Windows 98/NT/2000/ME/XP/VISTA
Learning Methodology:
- Instructor-led Training
- Group Discussion
- Hands-On
- Exercises
Duration:
2 days (9:00am to 5:00pm)
Courses Outline
Setup & Printing Issues
- Printing
Worksheet Basics
- Freezing Worksheet Panes
Working with Simple Formulas
- Creating Simple Formulas
- Creating Formulas with Cell References
Creating Complex Formulas
- Complex Formulas
- Working with Cell References
- Relative References
- Absolute References
Working with Excel Functions
- Mathematical Functions
- Date Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Financial Functions
- Database Functions
Working with Cell Basics
- The Cell
- Cell Content
Working with Templates
- Using Templates
Working with Basic Functions
- Basic Functions
- Function Library
- Insert Function Command
Conditional Formatting
- Conditional Formatting
- Conditional Formatting Presets
Require more support than our training courses?
Our full range of services can help you in many ways:
Custom Courses
- We can work with you to deliver a tailored made course for your staff, not only in Microsoft Excel, but also PowerPoint, Word and other Microsoft Office software
Standard Business Documents
- We can work with you to design standard business documents in Microsoft Excel, Word, and PowerPoint, making it quick and easy to produce professional, branded, stunning business documents
Automated Reporting
- Unsure if Microsoft Excel gives you the information you need to run your business? We can design, develop and generate monthly reports in easily accessible formats such as PDF, giving you the information at your fingertips to run your business – no more days wasted in incomprehensible data reports
What You Can Expect From Our Course
Qualified Trainer
Our trainer is a Microsoft Office 2010 Master Specialist and well-sought after Microsoft Certified Trainer with more than 15 years of experience. He has conducted hundreds of Microsoft Office application classes with leading companies in the region and gets excellent ratings for
all his classes.
Small Class Sizes
We limit the number of participants to 15 pax per session. This means that participants will become more productive immediately after the training session.
Solutions
Real answers and solutions to your issues, not off the shelf training.
Ask Our Expert
Participants will be given an email for assistance on future inquiries.