Training: Business Data Analysis and Microsoft Excel Productivity courses, Lagos and Abuja

ALVAPRO ESOLUTIONS

ALVARO Esolutions is Business Data Analysis Consulting and Advanced Excel Training Partner for Corporate, B-Schools etc. We do only not teach Excel but empower the participants with tips and tricks, troubleshoot techniques, best industries practices. Out of the box solutions and many more.

Our trainers are the end user of excel and we always do research on Microsoft excel features, functions and keep on upgrading the hands precisely, which really helps the participants in understanding the subject in to the core and can make use of those time saving techniques and finest solutions to make a difference in the workplace, we will be a value addition to the job profile and work as well.

We have had trainings attended by participant from organizations such as Ericson Nigeria, Smile Nigeria, Ministry of Justice, Hayat Kimya Nig ltd, and Health Assurance Consultants Lagos, Rahamaniya Oil and Gas Limited.

HOW OUR TRAINING WORKS

1. An expert instructor come to your office personally train the students.
2. Each student receives a Course Manual with Practice Files
3. Course is scheduled based on dates you provide (subject to instructor availability)
4. We usually require about 2 weeks lead time to arrange a training session
5. Training is completed in a convenient session(s) of your choosing
6. 20 minute break and 30 minutes long break for lunch daily
7. Post training support and a training certificate from us (alvaPRO eSolutions, a registered Microsoft Partner)

You’ll have to arrange for:

1. A Lab facility for the workshop or participants should bring their laptop to the company’s preferred location
2. Public seminar: Participants are required to bring their laptops to the workshop.

PUBLIC SEMINAR FOR INDIVIDUALS LAGOS

BUSINESS DATA ANALYSIS AND MICROSOFT EXCEL PRODUCTIVITY COURSE

MAY 2018

Friday 25th May 2018, Time: 9am – 5pm Saturday 26th May 2018, Time: 9am – 5pm

Address: Kristina Jade Learning Center, 70b Olorunlogbon Street, after Banex Hotel, Anthony Village, Lagos.

BUSINESS DATA ANALYSIS AND ADVANCE EXCEL PRODUCTIVITY COURSE

JUNE 2018

Friday 1st June 2018, Time: 9am – 5pm Saturday 2nd June 2018, Time: 9am – 5pm

Address: Kristina Jade Learning Center, 70b Olorunlogbon Street, after Banex Hotel, Anthony Village, Lagos.

BUSINESS DATA ANALYSIS AND MICROSOFT EXCEL PRODUCTIVITY COURSE

JUNE 2018

Friday 8th JUNE 2018, Time: 9am – 5pm Saturday 9th JUNE 2018, Time: 9am – 5pm

Address: Ayalla Hotels Ltd Abuja, No 3 Ibi Close, Off Ayedu st. Ahmadu Bello Way, Area 11,Garki by Sahad Store after Bolten White Hotel

PUBLIC SEMINAR FOR INDIVIDUALS

ABUJA

BUSINESS DATA ANALYSIS AND MICROSOFT EXCEL PRODUCTIVITY COURSE

JUNE 2018

MONDAY 11TH JUNE2018, Time: 9am – 5pm TUESDAY 12TH JUNE 2018, Time: 9am – 5pm

Address: Ayalla Hotels Ltd Abuja, No 3 Ibi Close, Off Ayedu st. Ahmadu Bello Way, Area 11,Garki by Sahad Store after Bolten White Hotel

BUSINESS DATA ANALYSIS AND MICROSOFT EXCEL POWER QUERY ( GET AND TRANSFORM)

JUNE 2018

Monday 4th June 2018, Time: 9am – 5pm Tuesday 5th June 2018 Time: 9am –5pm

Address: Kristina Jade Learning Center, 70b Olorunlogbon Street, after Banex Hotel, Anthony Village, Lagos.

BUSINESS DATA ANALYSIS AND MICROSOFT EXCEL PRODUCTIVITY COURSE

JUNE 2018

WEDNESDAY 13th JUNE2018, Time: 9am – 5pm THURSDAY 14TH JUNE 2018, Time: 9am – 5pm

Address: Ayalla Hotels Ltd Abuja, No 3 Ibi Close, Off Ayedu st. Ahmadu Bello Way, Area 11,Garki by Sahad Store after Bolten White Hotel

Why Microsoft Excel?

The Microsoft Excel is one of the most valuable productivity tools in today’s workplace. In addition to making it possible for office workers to perform tasks for which many have neither training nor talent, it makes performing such tasks extremely quick, effortless and error free. Skill in Excel is a necessity in any organization whose employees’ time is valuable and errors are costly.

Making decision based on gut feelings is outdated, Today’s managers are using Microsoft Excel and other spreadsheets to create financials models to understand the financial impact of various options available to them and run a variety of sensitivity around them. Financial modelling using Microsoft Excel enables better decision making, as it allows you to run simulations and projections faster, better and in real time. Microsoft Excel and financial Modelling skills are necessary for business executives, entrepreneurs and business school students, whether you are building a complex financial model for a hotel chain or managing your household expenses, using Excel and other spreadsheets makes your task easier.

BUSINESS DATA ANALYSIS AND MICROSOFT EXCEL PRODUCTIVITY COURSES

OBJECTIVES

The objective of the training class is to enable professionals to enhance their MS Excel Skills through Exercise, Case Studies and gaining hands – on experience on various techniques & tools. MS Excel Advanced Functions has been exclusively designed for all corporate professionals to hone their skills in Excel.

The program covers step-by-step lessons ranging from basic/start fundamentals likes, working with Calls & Ranges, Chartings, and Writing Iteration loop in Excel, Application of Array functions to advanced features and their application in professional jobs. The course will help delegates gain Excel Proficiency – Calculations, Functions. You’ll find our curated exhibition of Excel functions and formulas most useful in financial modelling.

WHAT YOU’LL LEARN

1. ESSENTIAL TRAINING

We will demonstrate the core features and tools in Excel. The course introduces key Excels skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers preparing documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing

data, charting, and automating and customizing.

TOPICS INCLUDE:

5. Copying and pasting techniques
5. Working with formulas and functions
5. Dealing with formula errors
5. Naming cells ranges
5. Formatting data and worksheets
5. Finding and replacing data

2. MANAGING AND ANALYZING DATA

Large amounts of data can become unmanageable fast. But the data management and analysis features in Excel, you can keep the largest spreadsheet under control. At the workshop, the trainer shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting, adding subtotals, filtering, eliminating duplicate data, data and using Excel’s Advanced filter feature and specialized database functions to isolate and analyze data. With the techniques, you’ll be able to extract important information from your data, in the shortest amount of time.

TOPICS INCLUDE:

5. Preparing data for analysis
5. Multiple – key sorting
5. Sorting by rows or by columns
5. Setting single-and multi-levels subtotals
5. Using text, numeric, and data filters.

3. ADVANCED FORMULAS AND FUNCTIONS

Conquer some of the most daunting features Excel once and all. We will demystify some of the most challenging of the formulas and functions in Excel and shows how to put them to their best use. The topics start with a review of the more basic, building-block functions, and a few critical keyboard shortcuts the will speed up working with Excel data, even on multiple sheets. We’ll then cover how to perform advance searching and data retrieval with lookup functions, tabulate and sort data counting and statistical functions, format data with text and math functions.

TOPICS INCLUDE:

5. Displaying and highlighting formulas
5. Converting formulas to values
5. Understanding the hierarchy of operations in formulas.
5. Creating and expanding the use of nested IF statements
5. Performing basic math

Editing text with functions

Prerequisite

Appropriate for all

System requirement

At least office 2013 is recommended

DURATION

This is a 2—days Essential Microsoft Excel Course for the Workplace Course starts at 9:00am and runs until 5:00pm.

BUSINESS DATA ANALYSIS AND MICROSOFT ADVANCE EXCEL PRODUCTIVITY COURSE

VLOOKUP, HLOOKUP

Objective

This advance Excel training course will teach you to use the advance features of Excel in any version to their full extent. By the end of this course, you will be able to report on data in a list using Pivot tables, edit and analyse complex data using advanced features such as scenarios, Goal seek and solver, incorporate built-in functions into a worksheet.

1. VLOOKUP

VLOOKUP is one of the most requested Excel function tutorials that have received in over eight years of providing corporate training in Microsoft Excel users get caught up in inefficient and problematic workflows, and nested conditionals (nested if statements) are curtaining towards the top of the list. Learn to solve this, and other problems, by utilizing the VLOOKUP, HLOOKUP, and index and match functions.

Some of the abilities you’ll gain by understanding these functions are;

• Eliminate nested conditional (IF) statements
• Pill data from disjointed or broken tables
• Allow for auto fill even when a reference table is transposed
• Create scalable drop-down validation listed

2. Time Valve of Money and some Financial Calculation

We’ll show you how to perform some financial calculations quickly and easily using some financial functions in Excel variables returns

Topics include:

• Analyzing loans, payment, and interest
• Discovering the interest rate of an annuity

E.g. future valve of Lump Sums

We’ll begin with a very simple problem that will provide you most of the skills to perform financial math using Microsoft Excel

An example using compounded value approach with excel commands

To find the future value of this lump sum investment we use the FV function which is defined as FV (Rate, Nper, Pmt,Pv,Type). Keep in that the example below does not detail the whole idea about the subtopic. It is just to give you a fill for some Excel capability. We’ll demystify the whole idea to you at the training, even if you are a novice.

FV (Rate, Nper, Pmt,Pv, Type)

There 5 different types of compounding (1) Monthly compounding (2) Quarterly compounding 93) Semi-Annual Compound (4) Yearly compound.

The example below is based on yearly compounding.

Suppose that you have 500,000 to invest for a period of 5years at an interest rate of 10% per year, how much will have accumulated at the end of this time period? In this problem, the 500,000 is the (PV) i.e. present Value,Nper ( No of periods) is 5, and rate is 10%.

Open a new workbook and enter the data as shown below, but leave B5 blank for now.

Present value	500,000
years	5
Annual Rate	10%
Future Value	805,255.00		=fv(B3,B2,,B1

These formula/functions are already prewritten in Excel will just do it for us. What’s handy about Excel is (that) once you type in a function it will tell you what inputs you need.

3. CHARTS

In this topic, we will show you how to analyze and communicate the value of data with charts in Excel. The topic starts with the foundation: what the parts of chart are, what the different types of charges, and which charts work best for your data. The topic then shows how to create a presentation- ready charts in minutes.

TOPICS INCLUDE:

• Identifying the plot area, chart area, gridlines, legends, and more
• Select the right chart type
• Creating charts instantly with shortcuts
• Choosing a layout
• Dealing with empty and hidden cells
• Switching rows and columns for a different view of the data
• Moving and resizing a chart
• Inserting pictures and shapes
• Adding labels to a chart
• Analyzing existing and future data with trend lines
• Charting a chart’s data source

4. WORKING WITH DATES AND TIME

In Excel: Working with Dates and Times, we share our solutions for optimizing the use of dates and times in Excel. This topic explains what’s going on behind the scenes when Excel stores dates and times, gives tips for entering the scenes when stores date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios.

TOPICS INCLUDE:

5. Understanding how Excel records and stores dates and times
5. Looking at date/time entry options and acceptable alternatives
5. Using the Today and Now functions.
5. Customizing date formats
5. Exploring keyboard shortcuts
5. Formatting time for hours over
5. Calculating differences across dates and times
5. Rounding calculations
5. Working with holidays
5. Validating with dates

5. PIVOT TABLES AND PIVOT CHARTS

You will learn how to use pivot tables summarize, sort, count, and chart your data in Excel. We will show you how to navigate the complexity of Pivot Tables while taking advantage of their power. This topic shows how to build PivotTables from single data, add calculated fields, fields, filter your results and format your layout to make it more readable.

TOPICS INCLUDE:

5. Formatting data for use in a PivotTable
5. Creating a new PivotTable
5. Connecting to data from multiple data sources
5. Creating calculated fields
5. Summarizing field data
5. Sorting and filtering PivotTables
5. Summarizing field data

Sorting and filtering PivotTables

6. ANALYZING SALES DATA

Create a leaderboard

Leaderboard finishing touches

Funnel chart

Quick forecasting

DURATION

This is a 2 – days Advanced Microsoft Excel Course for the Workplace Course starts at 9:00 and until 5:00pm.

BUSINESS DATA ANALYSIS AND EXCEL POWER QUERY (GET AND TRANSFORM)

OBJECTIVE

The course will get you up and running and using Power Query / Get & Transform with CONFIDENCE!

This must have introductory course covers all of Excel’s must – know features for cleaning up, transforming, consolidating and automating your Excel data and reports.

You will learn Excel features such as the Functions & Formulas, Text to Columns, Find & Remove Duplicates, Go to special, Excel Tables, Flash Fill.

No matter if you are a Beginner or an advanced user of Excel, you are sure to benefit from this course which goes through every single data cleaning & consolidation tool that is available in Microsoft Excel.

There are 4 different modules so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real-life business Case Studies.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers!

The course is just over 2 days long so you can become an awesome analyst and advanced Excel user within 1 day.

This course will give you career-building skills that you can use to become better and more efficient at your job.

WHAT ARE THE REQUIREMENTS?

Compatible with Microsoft Excel for Windows 2010, 2013 or 2016

WHAT AM I GOING TO GET FROM THIS COURSE?

Learn the various techniques within Power Query or get &Transform to clean and transform your data & consolidate reports without the need to use formulas or macros.

Learn the various data analytical tools within Excel to easily find & clean your data use Excel formulas & functions to pull data out & reorganize it to your desired outcome.

WHAT IS THE TARGET AUDIENCE?

New users, beginners, intermediates and advanced Excel users

Professionals working in the corporate world or government sectors want to leverage Excel for increased productivity, accurate data management and more.

People who want to change career and apply for a new job

People who work with large volumes of data and want quickly sift through, analyze and chart the data in a professional way

People who prepare reports that require constant updating with new data on a daily/week/monthly basis

Import data into Excel from an external source e.g.ERP system like Oracle, SAP, PeopleSoft, company database, Access, web etc…. and need to quickly & accurately analyze that data and extract valuable information.

DURATION

This is a 2-day Excel BI Course for the workplace

Course starts at 9:00 and until 5:00pm.

Please feel to contact us (08091728713/09050471922) or alvaexcel@gmail.com for further queries and clarification.

There is a class size limit