Use Microsoft Excel Like a Pro

Automate, Reduce, Get More Done

What We Offer

  • 2 Day Intermediate

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

More
  • 4 Day Advance

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

More

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

Contact 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.

Contact 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.

Get Started Now

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

Request A Call Back Today!

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

Get In Touch