Data Mastery Workshop With MS Excel ( Beginner To Advanced )

Data Mastery Workshop With Microsoft Excel
Advance Your Career with MS Excel ( Basic to Advanced )
Reserve Your Seat
Lagos Saturday, 11th December (Beginner To Intermediate). Saturday, 18th December 2021 (Intermediate To Advanced). Time: 9 am prompt


Microsoft Excel, the world’s most popular spreadsheet software, is designed to help users perform a myriad of business tasks, from to-do lists to forecasts to macros and VBA. Excel is used by millions of professionals around the world.

Most office staff can use MS Excel to a basic level for data entry, to format cells, even to use a basic Pivot Table. But few make it to the next level, to be able to build models, conduct scenario analyses, apply checks to flag errors, create a dashboard or format to a client-ready standard.

Our Excel classes are designed to help you use MS Excel to analyze data on any level. Whether you are just learning how to create spreadsheets or need to perform advanced data analysis with functions, formulas, and charts, these courses will help you unlock the maximum potential of this popular data-analysis program.

As you participate in the Mastering Data Mastery Workshop (Using MS Excel), it will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

Learning Outcomes/ Course Benefits

  • Learn how to use Excel commands effectively
  • Learn how to manage and transform data in Excel
  • Learn how to write formulas quickly and easily with the point-and-click method
  • Learn how to use relative, absolute, and mixed references in Excel
  • Learn how to create powerful calculations with Excel functions
  • Learn how to visually represent your data with charts and graphs in Excel
  • Learn how to use Excel data tools like sorting, subtotaling, and filtering
  • Master Simple and Complex Calculations using SUMIF, SUMIFS, IF, NESTED IF, DSUM in real world scenarios
  • Learn how to remove duplicates and tidy up your in Excel
  • Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
  • Use WHATIF Tools eg Goal SEEK, DATA TABLE, SCENARIO MANAGER effectively
  • Learn how to perform some financial calculations, loan amortization, etc
  • Work with Big Data, merge tables and use Power Query effectively
  • Learn how to create data models with PowerPivot
  • Learn how to format worksheets in Excel for impact and appeal
  • Learn how to automate Excel tasks with time-saving Macros
  • Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions

Who is the Workshop For?

From beginners to advanced users looking to brush up on their Excel Skills, this course is perfect for all ability levels and our teaching methods are tailored to groom each participant

Accountants, managers, administrators, consultants, salespeople, engineers, managers, fresh graduates, entrepreneurs.

For the complete and updated curriculum / course outline for the Data Mastery (with MS Excel) Workshop, kindly SMS/ WhatsApp +234-802-561-6156 or +234-703-268-7697


Taking the right Excel training can not only improve your Excel skills, but also help you to apply those skills to a wide range of practical situations and problems. Rather than just learning what Excel is able to do, you will learn how to use those Excel techniques and features to make a real difference within your organization or your personal life.

Excel training doesn’t just help you do what you’ve always done more quickly and efficiently. It will also extend how much you can do with Excel, and increase the effectiveness of the reports and presentations that you use Excel to prepare.

********Limited slots available*********

To check out some highlights of our recent programs, kindly visit our Facebook page :


Simply Afrikan Place ; 19 Fola Osibo Road, Lekki Phase 1, Lagos

Time: 9 am prompt

Date: Saturday, 11th December, 2021 ( Basic to Intermediate ). Saturday, 18th December, 2021 ( Intermediate to Advanced )


Seasoned professionals in their respective fields of endeavour
Accurate subject matter experts
Have a wide range of experience
Have ample work and training exposure
Have a proven track record of successful milestones in their fields of endeavour.
Are willing to be mentors and personal advisers to the participants


In order to participate in the hands-on portions of this course, you will need to have the following:


Windows or Mac with Microsoft Excel (any version from 2003 to 2019 or Microsoft Office 365).


Some work-related projects to which you can readily apply what you learn (optional).


  • Beginner
  • N25,000
  • (Ideal for beginners who have little or no experience in MS Excel)
  • Full Workshop Module
  • Free Course Materials
  • Practical Case Studies
  • Exercises
  • Post-Training Guidance
  • Certificate
  • Lunch
  • Register
  • Advanced
  • N25,000
  • (Ideal for candidates who desire a broad use of MS Excel )
  • Full Workshop Module
  • Course Materials
  • Practical Case Studies
  • Exercises
  • Post-Training Mentorship
  • Certificate
  • Lunch
  • Special Gift
  • Register
  • Combined
  • N40,000
  • (Ideal for beginners and intermediates who want to master MS Excel completely)
  • Full Workshop Module
  • Free Course Materials
  • Practical Case Studies
  • Exercises
  • Post-Workshop Coaching
  • Certificate
  • Free Lunch
  • Register


Please call 0703-268-7697 or 0802-561-6156 to confirm availability before making payment.
Pay into Zenith Bank. Account Name: Precepts & Mentors. Account Number: 101 411 9494
Send proof of payment including your Name, Email, GSM to 0802-561-6156 or 0703-268-7697.
You will receive an acknowledgement and you will be enrolled into the program.