Business Data Analysis and Microsoft Excel in-depth training for the Workplace in Lagos and Abuja | Welcome to Linda Ikeji's Blog





Monday, 17 July 2017

Business Data Analysis and Microsoft Excel in-depth training for the Workplace in Lagos and Abuja

Making decisions 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. Greetings from AlvaPRO esolutions!!!

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 Cells & 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. Here you’ll find our curated exhibition of Excel functions and formulas most useful in financial modelling.

Program Deliverables:
(1) A training notepad with pen and a comprehensive study material (2) Practice excel worksheets and cases (3) 14hours/2days (4) Post training support(5) A training certificate from us (alvaPRO eSolutions, a registered Microsoft Partner) . (6) A tea break and lunch (7) You have to bring your laptop for the workshop

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:
Copying and pasting techniques
Working with formulas and functions
Dealing with formula errors
Creating lookup tables
Naming cells ranges
Formatting data and worksheets
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, and using Excel’s Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you’ll be able to extract the most important information from your data, in the shortest amount of time.
Topics include:
Preparing data for analysis
Multiple-key sorting
Sorting by rows or by columns
Setting single-and multi-levels subtotals
Using text, numeric, and date filters
(3)    Data Validation
With Excel data validation tools, you can control users input data into workbooks and ensure data is entered consistently and accurately. You can control the dates, the times, even the length of the length of text they enter
Topics include:
Testing for whole numbers and decimals
Using the input message box
Sequencing and placing lists
Creating multitiered lists
Setting data and time limitations
Limiting text length
Locating data validation rules
Requiring entries to be unique
(4)    Pivot Tables and Pivot Charts
You will learn how to use PivotTables to summarize, sort, count, and chart your data in Excel. We will show you how to navigate the complexity of PivotTables while taking advantage of their power. This topic shows how to build PivotTables 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:
Formatting data for use in a PivotTable
Creating a new PivotTable
Connecting to data sources
Consolidating data from multiple data sources
Creating calculated fields
Summarizing field data
Sorting and filtering PivotTables
Summarizing field data
Sorting and filtering PivotTables
Working and Excels slicers
Formatting PivotTables with styles and formats
Applying conditional formats
Creating PivotCharts
(5)    Advanced Formulas and Functions
Conquer some of the most daunting features in Microsoft Excel once and for 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 that will speed up working with Excel data, even on multiple sheets. We then covers how to perform advanced searching and data retrieval with lookup functions, tabulate and sort data counting and statistical functions, format data with text and math functions.
Topics include:
Displaying and highlighting formulas
Converting formulas to values
Creating 3D formulas to gather data from multiple sheets
Understanding the hierarchy of operations in formulas
Using absolute and relative references
Creating and expanding the use of nested IF statements
Looking up information with VLOOKUP
Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
Performing basic math
Editing text with functions
(6)    Time Value of Money and some Financial Calculation
We will show you how to perform some financial calculations quickly and easily using some financial functions in Excel variables returns
Topics include:
Analyzing loans, payments, and interest
Discovering the interest rate of an annuity
For Example – Future Value 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 will use the FV function which is defined as FV (rate, nper, pmt, pv, type). Keep in mind that the example below does not detail the whole idea about the subtopic. It is just to give you a fill for some Excel capabilities. 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) Daily compounded (1) Monthly compounding (2) Quarterly compounding (3) Semi-Annual compounding (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.

This formulas/Function are already prewritten in Excel, 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.

(7)    Charts
In this topic, we will show how to analyze and communicate the value of data with charts in Excel. The topic starts with the foundation: what the parts of a 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
Selecting 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 trendlines
Charting a chart’s data source    
(8)    Working with Dates and Times
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 date dates and times, gives tips for entering the scenes when stores dates and times, give tips for entering dates and times, and shows options for 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:
Understanding how Excel records and stores dates and times
Looking at date/time entry options and acceptable alternatives
Using the Today and Now functions
Customizing date formats
Exploring keyboard shortcuts
Formatting time for hours over.
Calculating differences across dates and times
Rounding calculations
Working with holidays
Validating with dates
(9)    Automating Worksheet Tasks with Macros
Are you ready to build intelligence into your spreadsheets? By automating routine tasks, you make your spreadsheets run quicker and more efficiently. You will walk through the process of speeding up worksheets tasks with macros.
Topics include:
Planning your macro
Recording your macro
Using relative or absolute reference in Macros
Executing Macros

Outcomes of this workshop:
1.       Once you attend these workshops you will be benefited in your day to day work to achieve new milestones by efficiency & accuracy in your work.
2.       Navigating through excel efficiently & effectively
3.       Representing and formatting data
4.       Plotting various charts
5.       Performing sensitivity analysis
6.       Using various analytical tools in excel
7.       Using formula’s and functions

(1)    “The training was rewarding and a time well spent, my biggest challenge was the data analysis using pivottables. Little did I know that it was some idea [that] I was lacking. The trainer demystify it in few moments. I can now apply it well at my workplace better.” A participant from ERICSON NIGERIA
(2)    “If I had got this knowledge before, especially the aspect of in-depth formulas and functions, I would have done far better in the World bank project I was involved in.Great training!” A participant from Ministry of Justice
(3)    “With the trainer’s demonstration, life in Excel is a lot easier in Excel. I also found the handbook very comprehensive, a lot of practices files to work with. Great job!” A participant from Health Assurance Consultants, Lagos.

Lagos Venue: Kristina Jade Learning Center, 70b Olorunlogbon Street, after Banex Hotel, Anthony Village, Lagos.
Dates: 28th and 29th of July (Friday and Saturday) Time: 9:00 a.m. Prompt

Abuja Venue: Gracious Hotel, Plot 29, Okemesi Crescent, New Polytechnic Layout(Old FERMA) off Mohammed Buhari Way, By Old CBN, Garki 2.
Dates: 4th and 5th of August (Friday and Saturday) Time: 9:00a.m. Prompt

Please feel free to contact us (08091728713/09050471922) or for further queries and clarification. There is a class size limit.

No comments:

Recent Posts