Data Mastery Workshop With MS Excel ( Beginner To Advanced )

Data Mastery Workshop With Microsoft Excel
Do More With MS Excel (Beginner To Advanced)
Reserve Your Seat
Lagos | Abuja | Port Harcourt Friday, 10th January (Beginner To Intermediate). Saturday, 11th January 2019 (Intermediate To Advanced). Time: 9 am prompt

OVERVIEW

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.

By the Data Mastery With Excel Workshop, You Will…

  • Learn how to navigate around Excel
  • Learn how to enter and edit data in Excel
  • Learn how to adjust the way data and information are displayed 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
  • Learn how to “freeze columns and rows” with freeze panes in Excel
  • Learn how to remove duplicates from data in Excel

That’s Not All, You Will Also…

  • Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
  • Learn how to perform some financial calculations, loan amortization, etc
  • 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 how to integrate Microsoft Excel with Microsoft Word
  • Learn how to use passwords in Excel to protect your work in multiple scenarios
  • Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
  • Learn how to use printing and sharing in Excel
  • 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

Course Benefits

  • Conduct insightful analysis of small or large data sets.
  • Banish your “phobia” for MS Excel  for good.
  • Build a dashboard to monitor your or your company’s performance.
  • Present your work beautifully be it in a table, scatter, radar or pie chart.

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 : www.facebook.com/prementors

LAGOS TRAINING VENUE: Simply Afrikan Place ; 19 Fola Osibo Road, Lekki Phase 1, Lagos

ABUJA TRAINING VENUE: IBI Training Centre, Discovery Mall, Adetokunbo Ademola Crescent, Wuse 2, Abuja

Come early to the Venue with evidence of payment to register.

OUR FACILITATORS ARE...

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

REQUIREMENTS

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

LAPTOP

Windows or Mac with Microsoft Excel (any version from 2003 to 2013 or Microsoft 365).
Project

PROJECT

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

REGISTRATION FEE

  • 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

PAYMENT & REGISTRATION INSTRUCTIONS

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

PAST ATTENDEES

GOT QUESTIONS?

COUNTDOWN TO WORKSHOP