Data Mastery Workshop With Microsoft Excel

( Advanced)

Abuja: (Saturday) 5th May

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 Excel to a basic level for data entry, to format cells, even to use a basic PivotTable. 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 Excel to analyze data on any level. Whether you're 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 Data Mastery Workshop ( With 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.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

• 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
• Learn how to "transpose data" - switching the columns and rows in Excel
• Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
• 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 and many more

Requirement

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

• PC or Mac with a full version of Microsoft Excel (any version from 2003 to 2013 or Microsoft 365).
• Some work-related projects to which you can readily apply what you learn. (optional)

Relevant audiences

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.

Learning outcomes

• 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 organisation 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

Description

This training provides you everything you need to know about Microsoft Excel.

From the fundamentals, to the most advanced features, after taking this course you will be able to use Microsoft Excel at an expert level.

This course provides comprehensive scope on Microsoft Excel

Our facilitators have designed, refined, and perfected this course to make it easy for you to master Microsoft Excel.

TRAINING SCHEDULE

Available Date:

Abuja:

Saturday , 5th May, 2018

Time: 10.00 am- 5.00pm

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

To check out some highlights of our recent programs, kindly visit our Facebook page : www.facebook.com/prementors or our website: www.precepts.com.ng

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

Registration Fee :

N20,000 ( Intermediate To Advanced )

*Customized On-Site Training Sessions Also Available 

Registration Instructions

Call 0703-268-7697 or 0802-561-6156 to confirm availability before making the transaction. If there is availability, then you will proceed to register

Account Name: Precepts & Mentors

Account Number: 101 411 9494 Zenith Bank

After payment, send your details including: Name, Email Address, GSM, Teller Number (OR evidence of Electronic Transfer) to 0802-561-6156 or 0703-268-7697. You will receive an acknowledgement and you will be enrolled into the program.

 WHY TRAIN With Precepts & Mentors

Our Methods

We utilize top subject matter experts to deliver the peak learning experience available. Our facilitators and mentors provide every participant with the most useful and up-to-date information for their personal development.

Our Facilitators:

Are seasoned professionals in their respective fields of endeavour

Are 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

Precepts & Mentors makes use of down-to-earth and practical methods in transferring knowledge and experience in the most useful form.

Our specialty is in facilitating mentorship platforms in organizations by equipping them with the best tools to enable cross-fertilization of knowledge and ideas. Our sessions are highly interactive and engaging as well.

VALUE ADDED SERVICE

*Learning Experience: Delivered by industry experts

*Course Materials: Clear, easy-to-understand reference materials

*Lunch

*Practical Case Studies

*Exercises: They are designed to help participants try out what they have learnt and meet ‘life size’ challenges that are then handled by the facilitators.

*Post-Training Coaching Program

*Certificates will be issued at the end of the workshop

If you have any questions or comments, we would be happy to hear them. You can reach us on 0802-561-6156 (Collins) OR 0703-268-7697 or send an email to training@mentors.com.ng or visit www.mentors.com.ng   or our Facebook page www.facebook.com/prementors

(c) Precepts & Mentors ; Abuja Office: Suite DA7, Zone D Shopping Complex, Zone D, Apo Legislative Quarters, Apo, FCT- Abuja. | Lagos Office: 10 Omotayo Ojo Street, Off Allen Avenue, Ikeja, Lagos | Website: www.mentors.com.ng  | Telephone: +234-802-561-6156, +234-703-268-7697 |  Email:training@mentors.com.ng  | Facebook: www.facebook.com/prementors