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

2 Day Intermediate

Become a confident MS Excel user in
our 2-Days training. This training is
focused on data analytics and date investigation.

4 Day Advance

Learn to use Excel like a pro. This
workshop is designed for MS Excel
automation especially for highly
repeatable tasks.

Online Training

Become a confident MS Excel user
in our online training. The academy
covers both the intermediate and
advance courses.

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.


"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime."

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 it?
What Can You Gain?
Who Should Attend?
What You’ll Get?
Requirements

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 specializes in software, systems and databases, this training is much more focus on analyzing 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 analyze 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 it?
What Can You Gain?
Who Should Attend?
What You’ll Get?
Requirements

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?

As SmartB specializes in software, systems and databases, this training is much more focus on analyzing 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 analyze 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

Day 1: Training

The morning session will cover the following:

Create a personalize 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

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.

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.

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.

Online Academy
Basic to Intermediate Excel Learning

"Tell me and I forget, teach me and I may remember,
involve me and I learn.."

Learn MS Excel at your own pace and at your own speed as long as you're connected to the internet. Each sign up is valid for 2 years.

What is it?
What Can You Gain?
Who Should Attend?
What You’ll Get?
Requirements

What is the workshop about?

This is a online training that will cover the content from basic and intermediate levels. You’ll grow from a beginner excel user to becoming a pro user. We will be teaching you the tips and tricks become a really good excel user in the academy.

What Can You Gain?

By the end of the work shop, you can expect to learn the same learning outcomes as the intermediate training.

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 formatting 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

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.

Hear What Our Participants Say

"How you gather, manage, and use information will determine whether you
win or lose."
- Bill Gates, Microsoft

Our Clients

Request A Call Back Today!

Speak to one of our team members and arrange for a demo.

Copyright 2017-2026 - www.SmartB.Academy - All Rights Reserved. This website is owned and operated by SmartB Solutions.