MS EXCEL FOR BUSINESS & OFFICE PROFESSIONALS

INVITES YOU TO OUR ADVANCED MS EXCEL FOR BUSINESS & OFFICE PROFESSIONALS CLASS

INTRODUCTION
This hands-on training course has been specifically designed to assist you in simplifying and speeding up the task you perform with MS Excel every day.

In this class, you will discover how to refine and improve the spreadsheet that you work with to get the most out of MS Excel and save loads of time. We will show, step-by-step, some practical ways to work with spreadsheets, sort and validate data, take control of your work quality by learning how to create your own template, toolbars and styles. Become a whiz with auto-filling, auto-summing and other time-saving functions.

Take this opportunity to learn easy ways to create and automate spreadsheets - which will save you time while increasing the quality and usability of the information you are preparing. This will also result in you being able to source and provide key information for yourself and your manager.

WHO SHOULD ATTEND?
This training is recommended for anyone with basic knowledge of Microsoft Excel and everyone who wishes to enhance their skills in spreadsheet management.

EXPECTED OUTCOME: 

• Use advanced filters, VLOOKUP, Pivot Tables, Data manipulation and searching
• Design Excel-based templates and make an impressive and powerful presentation of reports
• Validate data captured to be sure of authenticity and accuracy for reliable output/information
• Plot a graph that changes its bars dynamically using tools like a slicer, sparkline, pivot chart etc.
• Use Excel macros to convert figures to words, automatically print a continuous report at a particular time and interval
• Set indicators (amber light, yellow light and red light) to prompt you about expiring periods (staff confirmation dates; leave resumption dates; re-order level; bill renewal due date etc.)
• Drive departmental performance using the KPI Command using conditional formatting in excel
• Preview and print documents, adjust margins and create headers
• Manage and control project deadlines using Advanced Excel Functions
• Transform business data into meaningful dashboards and dynamic charts
• Perform advanced calculations on Excel

COURSE CONTENT

SESSION 1:

• Creating and Working with Templates
• Creating and Working with Pivot Tables
• Creating and Working with Pivot Charts
• Using Logical Functions (IF, OR, AND, NOT, etc.
• Using Date and Time Functions
• Using Array Formulas
• Displaying and Printing Formulas
• Using Lookup Functions (VLOOKUP & HLOOKUP)
• Using MATCH and INDEX Creating Data Tables
• Creating a Dashboard with Pivot Charts
• Changing the Pivot table layout
• Formatting
• Producing reports
• Manipulating query headings
• Grouping and ungrouping data fields

SESSION 2:

• Adjusting Scale of Charts
• Formatting Data Points
• Creating Combination Charts
• Creating Trendlines
• Inserting Sparklines
• Adding and Formatting Graphical Elements
• Adding and Viewing Comments in Cells and Workbooks
• Protecting Worksheets with Passwords
• Protecting Worksheet Structure
• Sharing, Merging and Tracking Changes in Workbooks
• Understanding Data Quality issues
• Gathering data from different sources
• Linking Data
• Merging and Consolidating Data
• Excel Hints and Tips when working with data
   

TRAINING DETAILS

Duration: 1 Day
Date: January 27, 2019
Time: 9:00am – 4:00pm
Venue: CHEMLINE EXECUTIVE TRAINING HALL, Plot C, Obasa Avenue, Behind AP Filling Station, Off Oba- Akran, Ikeja, Lagos
Fee: N45,000

Please note that the training fee covers refreshments, certificates, writing pads, e-manuals and other training materials

HOW DO I REGISTER FOR THIS TRAINING?

Kindly send the details of your company nominees or your details to bomosaku@gmail.com.

 Payment can be made to BARBADOS SOLUTIONS, GTB Account Number 0159819628

POWER BUSINESS INTELLIGENCE

MICROSOFT 

POWER BUSINESS INTELLIGENCE TRAINING PROGRAM

December 15 and 16, 2018

SYNOPSIS

Imagine a car without a dashboard on the third mainland bridge at night. How will you know if the vehicle is overheating? How would you know if something is about to happen to the engine? How would you know if the fuel is about to finish? 

Many organizations and business functions are run without dashboards to give them insights about their organizations or specific functions. It is for this reason Microsoft came up with Microsoft Power Business Intelligence (BI) Tool.

Microsoft Power BI is Microsoft’s new business intelligence tool that delivers insights on the organization’s data. It enables a business enterprise to make more informed decisions based on facts and figures.

Power BI is an intelligent tool that studies your business your operations based on your data, provides you with insights that ordinary eyes cannot see in a stunning report format that anyone can understand and make sense of.

it handles both simple and complex data. Once this business tool is connected to your data sources, it will analyze your data and then go ahead to generates beautiful reports that can be published for everyone to consume on the web and across different mobile devices.

Power Business Intelligence allows a business to regulates its activities on a real-time basis, monitor performance indices and make an accurate forecast for the future.

At this training, we shall guide you from downloading and installing Microsoft Power BI desktop to creating reports, stunning dashboards and publishing on the web and mobile devices such that report can be seen on mobile devices.

Power BI is the future of business, and the future is here. Gain a Competitive advantage with Power BI.

üDo you want more from your data?  

üDo you wish to learn Data Analysis and Data Visualization? 

üDo you want to learn about DAX (Data Analysis Expression), the powerful data analysis language which is a HUGE hot career topic? 

üDo you want a course that teaches you everything you need to know to get started, but doesn't waste your time with things you will likely never encounter?

     This course is the perfect course for someone who wants to get their feet wet, learn some advanced functions, and take their Data Analysis skills to the next level with Microsoft Power BI.

Target Audience

üExcel users and smart business owners/analysts 

üProfessionals who want to go next level in data analysis and make graphs and reports with ease. This course is essential for professionals who want to take their career forward. Professionals like: 

•   Human Resources
•   Sales Professionals 
•   Financial Experts etc

üSomeone who has no experience or is a beginner with Power BI.

üManagers who want insight into the business for better decision making

Learning Objectives

üYou will learn how to develop an entire business intelligence tool from the ground up to publishing on the web or devices

üyou will gain the knowledge and confidence to apply these same concepts to your own real-world analysis (function specific).

üWhether you are a casual user, aspiring analyst, or data science professional, you will become an absolute Power BI ROCKSTAR 

Program Outline

üGathering, Connecting & Transforming the Raw Data

üGrouping, Aggregating, Modifying, Merging & Appending Queries

üBuild a Relational Data Model

üCreating Relationships

üAdd Calculated Fields

üCalculated Columns vs. Measures with DAX

üDesign Interactive Report

üIntro to the Power BI Report View

üAdding Objects & Charts

üFormatting & Filtering

üPublishing to Power BI Services

üData Viz Best Practices

LEAD FACULTY 

    Computer Science Graduate

   Masters Degree in Business Administration

   Over 18 years Training Spreadsheet Apps 

   Super Cal, Lotus 123, Quarto Pro, MS Excel)

   Trained over 10,000 participants on MS Excel within        and outside the country

   Microsoft Certified Professional (Office, SQL Server,        Web/Desktop Application Developer)

   Project Manager

   System / Business Analyst

   DW / BI Consultant

   Dashboard Reporting Expert

COST 

N100,000/Participant

We accept payment in Two Instalments. 

DATE

Dec 15 & 16, 2018

VENUE 

3, Odegbami Street, Boet Estate, ABC Bus Stop, 
Adeniyi Jones, Ikeja, Lagos.

BOOK A SEAT TODAY!

ONLY 15 PARTICIPANTS SHALL BE ADMITTED

OUR BANK DETAILS 

Bank Name:         Guaranty Trust Bank

    Account No:         0159819628       (Current Account)   




  

Sponsored By:

 

   This Program is being organized by Barbados Solutions. Barbados Solutions is an Accredited Training Centre for Chartered Institute of Personnel Management of Nigeria(CIPMN). 

Inquiries

 Biodun            08113424228, 

    Fadekemi,      08082707430, 

    Funke              08030590861