Use Microsoft Excel Like a Pro
Learn to make Microsoft Excel work faster for you when you attend our hands-on intensive workshop.
When you complete a repetitive task that takes 45 seconds and move it to half a second, that means you are saving 90 X your work/time.
Automate, Reduce, Get More Done
What We Offer
Learn The Tips & Tricks To Excel Automation...
With NO Programming Required...
Get Done Faster
MS Excel is not new, yet many do not know the simple secrets to make excel work REALLY FAST.
Join our workshop where we will give you hands-on guidance to learn and make your work life easier, more relax and more productive.
Real Results
This is a workshop. That means, you will be working on REAL projects or tasks from your business only.
Only work on real files so that these are most relevant to your workplace. More importantly, you will see instant results as you can relate them to your workplace.
ROI Guaranteed
During the workshop, we will sit beside you when you create YOUR OWN automation files or processes.
Because we hold your hands to develop your own automation, all your files are already automated to some degree before the workshop ends.
Note: The above are only applicable for the advance workshop.
2-Days Intermediate
Excel Training
"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime."
Learn to become a confident excel user in 2 days.
What is the workshop about?
This is a 2 day training class with lots of time for practices. This is where you build the confidence to navigate around MS Excel and become proficient at managing all sorts of data.
This training will focus more on data analysis and data investigation.
What Can You Gain?
By the end of the work shop, you can expect to
- Learn some intermediate excel formulas
- Learn how to use the following with confidence
- Pivot table
- VLOOKUP
- SUMIF
- COUNT
- COUNTIF
- Absolute & Mixed Reference
- Data validation
- Goal Seek
- Learn basic data investigation tips and tricks
Note: The list can vary pending on the request that may arise during the training.
Who Should Attend?
As SmartB specialises in software, systems and databases, this training is much more focus on analysing data from various software or databases. The people who specifically should attend are:
- Administration staff
- Reporting staff
- Finance analyst
- Data interrogator
Essentially, this is for people who wants to investigate and analyse data efficiently.
What You’ll Get?
During the workshop, you will get
- 2 full day of intermediate training
- Exposure on how to manage data from software and systems
- Create reports for analysis
- Build confidence in data analytics
Getting Started
Interested parties must either be from one company or you may be able to sign up as one single participant. If you are coming on your own, we will keep you on the wait list until a schedule has been set.
Attendee Requirements
The attendee must
- Have been using MS Excel (actively) for 6 months or more
- Bring his/her own laptop
- Run or plans to run repeatable tasks at work
- Able to bring some of his/her work files to the workshop
Number of attendees per class
Minimum 8 pax and maximum 12 pax.
Timeline/Scheduling
Workshops dates are flexible but must be completed within 3 weeks from the first day or it will loose its effectiveness.
Venue
Ideally, the training should be done where the team can access the working files. If the company does not have a training venue, one can be arranged with us.
4-Days Intensive
Advance Excel Workshop
"Tell me and I forget, teach me and I may remember,
involve me and I learn.."
Get everything you need in 4 days to build an internal automation team. Find out more here.
What is the workshop about?
This is a 4 day workshop to get you from an average excel user to becoming a pro user. We will be teaching you the tips and tricks become a really good excel user within that 4 days.
The workshop includes 1 day of training and 3 days of practical automation work.
What Can You Gain?
By the end of the work shop, you can expect to
- Learn some intermediate to advance excel formulas
- Learn how to automate and shorten the time to run your regular tasks
- Learn how to design and plan simple automation processes
- Solidify the method with many exercises
- Completed a few automation on your work file
- Be more advance than the majority of average excel users
Who Should Attend?
Companies or team of people who use MS Excel to run REPEATABLE tasks on a regular basis. Typically these includes:
- Remove duplicates
- Filter specific keywords
- Select or Delete blank rows
- Create formulas
- Apply formating to raw data
These are just some of the items that you may be doing. Other bigger tasks could already include:
- Monthly reporting
- Reconcialition processes
What You’ll Get?
During the workshop, you will get
- 1 full day of advance excel training
- 3 full days of practical training & practices
- Access to advance excel users who will be sitting besides you during the workshop to help you solve complex excel problems
- You would have already automated a few of your work files before the end of the workshop
- By the end of it, you will have more than enough experience (and confidence) to continue your automation work back in your normal workplace.
Getting Started
Interested parties must either be from one company or you may be able to sign up as one single participant. If you are coming on your own, we will keep you on the wait list until a schedule has been set.
Attendee Requirements
The attendee must
- Have been using MS Excel (actively) for 2 years or more
- Bring his/her own laptop
- Run or plans to run repeatable tasks at work
- Able to bring some of his/her work files to the workshop
Number of attendees per class
Minimum 8 pax and maximum 12 pax.
Timeline/Scheduling
Workshops are run over a period of 4 weeks with 1 day each week. Workshop cannot be extended for more than 8 weeks from the first day or it will loose its effectiveness.
Venue
Ideally, the training should be done where the team can access the working files. If the company does not have a training venue, one can be arranged with us.
Breakdown of the 4-Day Workshop
-
1
Day 1: Training
The morning session will cover the following:
• Create a personalise Customize Access Toolbar
• Understand the basic concept of MS Excel shortcut and shortcut tools
• Intermediate to advance excel tools
The afternoon session includes:
• Excel exercises -
2
Day 2: Automation Day
The morning session starts with creating task lists (by the attendees) required for automation. The rest of day is dedicated to automating the task in those list. With the help of the trainer (and his team) to help automate as much work as possible.
-
3
Day 3: Design & Planning
The morning session will cover the following:
• Design, work-flow and planning
• Structure vs un-structured data
• Automating more complex processes
This will be useful for advance or complex automation. -
4
Day 4: Automation Day
Similar to day 2 where more advance/complex tasks will be automated.
The schedule above is just for reference and can be changed pending on the skill level the group.
As you can see from above, there are 2 x half days of training and the rest is dedicated to working on further improving the files.
Also, based on the overall skill level of the attendees and their readiness, we can also progress towards advance design and planning workshops.
"How you gather, manage, and use information will determine whether you win or lose."
- Bill Gates, Microsoft
Customers love our system for different reasons...
Satheesh Kumar - Group Information Technology Manager, AGX Logistics - It was a pleasure to work with SmartB. The system is easy to use and the project went well as the implementation was quick and smooth.
Our Clients
