Master Data Analysis & Visualization in Excel:

Advanced Excel Masterclass, Somalia

Learn top excel skills to reduce your turn around time in reporting and presentation.

Play Video

Save $50 when you make payments on or before 1st Jan 2020

Venue:
New Rays Hotel, Garowe, Somalia

Training Fee:
In-person: $400.00
Virtual: $250.00

Full Day, 8am-4pm:
12-14th Jan 2021
Virtual:
18th-21st Jan 2021, 3-6pm plus Sat 23rd Jan 2021, 7-11am

Booking & full payment must be completed at least 7 days before training day. On the registration form, please select the training mode (in-person or virtual). An email will be sent with payment details

In today’s workplace, knowing your way in Excel is the NUMBER ONE skill that everyone needs to have.

But…

Do you REALLY KNOW Excel? Are you using it as a calculator thus wasting your valuable time?

This course teaches you HAND-PICKED concepts on the quickest ways [read formulas] to do any given task.

This is what you can expect

Job Impact

Learn formulas that save you time spent generating reports. Decision makers gain timely access to data

Post-course Support

Stuck on a task? drop us a line or email. Trainer constantly shares tips & tricks to master Excel

Seasoned Trainers

Our subject matter experts genuinely understand their thing! …and will answer questions on the go

Practical Lessons

We offer interactive sessions with numerous exercises to help you apply the concepts learnt.

ROI

Get value for the money and time invested. We're careful to ensure results so that your budget doesn't go to waste!

CONTENT

Well researched curriculum, coupled with ample business related examples

We have distilled the content to the MUST-KNOW concepts for optimal benefits

  • Build robust formulas using F4 and $ sign
  • QAT & Key shortcuts
  • Formatting concepts –format painter, Excel tables
  • Creating drop down lists and named ranges
  • 5+ methods to identify and remove duplicates from your data
  • Segment/Group your data using Nested IF function
  • Join datasets from multiple sources in seconds with VLOOKUP and MATCH functions. We also look at VLOOKUP errors and how to fix them
  • Sanitize your data extracts using DATE and TEXT functions, e.g. dates formatted as text into proper dates
  • Advanced lookups using INDEX MATCH combination
  • The new XLOOKUP function (for those with Office 365)

Functions to automate tedious and time-consuming analytics tasks

  • SUMIFS, COUNTIFS, SUMPRODUCT
  • Troubleshoot errors using IFERROR
  • Advanced PivotTables and Pivot Charts
  • Creating a sample Excel dashboard
  • Rationale of chart selection; Charts dos and don’ts
  • Combination / dual-axis charts
  • Techniques to achieve professional finish on your charts
  • Adjusting axis –display in millions, billions etc.
  • Creating KPI progress bar charts and ring charts
  • Automatically colour negative and positive variances in charts
  • Make charts dynamic using drop downs, option buttons and combo boxes
  • Other visuals -lollipop chart, mini-bullet charts, etc.
  • Variance analysis using icon sets –up/down arrows, performance status with traffic lights
  • Data bars for in-cell charts
  • Using custom number formats
  • Applying REPT function for in-cell charts

Ready to experience Excel?

GET BETTER AT REPORTING & ANALYTICS BY ENROLLING TODAY!​

What our past students said

"William, I have finally completed the course and how excited I am! Your delivery is superb with very simple and clear illustrations. I had interacted with pivots and dashboards before, but this has taken me off to another trajectory."​
Charles Onsongo
Data Analyst
“Your dashboard training has already saved me a lot of time! I have used some tips which to present my funding analysis by location and staff type. Every month I just paste the new data and my source table self-adjusts. Magic! Just like that!”​
financial dashboards in excel
Yakub Mohamed
Finance Officer, WFP Kenya
“The revelations of concepts that I could use to reduce manual work was just amazing. I’ve since applied these techniques in my work resulting in greater speed of execution, verifiable outputs with less errors. William was a very patient trainer!”
excel dashboards past trainee
Brenda Nkatha
Demand Analyst

You're in Safe Company

Here is your opportunity to reclaim your time

Get ready to say, “everything now makes sense”

Go to Top