The increasing complexity and globalization of industry and commerce and
the ensuing competitiveness means that companies must take a more
sophisticated approach towards their decision-making. The quality of
decisions is often based on “hard data” to select the best course of
action. Also management consultants are often required to focus strongly
on quantifying their recommendations wherever they can.
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. Advance MS
Excel Advanced Functions have
been exclusively designed for the 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 loops 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. Also knowing Excel functions and
formulas is the first step in Excel financial modeling and forecasting.
Program Deliverables:
·
a training notepad with pen and a
comprehensive study material
·
practice excel worksheets & cases
·
14hours /2days
·
post training support
·
a training certificate from us (alvaPRO
eSolutions, a registered Microsoft Partner)
·
a tea break and lunch
·
You have to bring your laptop for the
workshop
(1)
Essential Training
We will demonstrate the core features and tools
in Excel. The course introduces key Excel 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 cell ranges
Formatting data and worksheets
Finding and replacing data
(2)
Managing and Analysing Data
Large amounts of data can become
unmanageable fast. But with the data management and analysis features in Excel,
you can keep the largest spreadsheets 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-level subtotals
Using text, numeric, and date filters
(3)
Data Validation
With Excel data validation tools, you can
control how users input data into workbooks and ensure data is entered
consistently and accurately. You can control the dates, the times, even 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 date 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 from single
data, add calculated 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
Working
with Excel 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 topic starts 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 with 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)
Financial
Functions
We will show you how
to perform some financial calculations quickly and easily using some financial
functions in Excel variable returns
Topics include:
Analyzing loans, payments, and interest
Discovering the interest rate of an
annuity
Calculating the future value of an investment with variable returns
(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 foundations: what the parts of a
chart are, what the different types of charts are, and which charts work best
for your data. The topic then shows how to create a presentation-ready chart 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
Changing a chart's data source
(7) Working with Dates and Times
In Excel: Working with
Dates and Times, we will 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 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 standard date/time entry
options and acceptable alternatives
Using the TODAY and NOW functions
Customizing date formats
Exploring keyboard shortcuts
Formatting time for hours over 24
Calculating differences across dates and
times
Rounding calculations
Working with holidays
Validating with dates
(8)Automating
Worksheet Tasks with Macros
Are you ready to build
intelligence into your spreadsheets? By automating routine tasks, you can make
your spreadsheets
run quicker and more efficiently .You will
walk through the process of speeding up worksheets task with macros.
Topics include:
Planning your macro
Recording your macro
Using relative or
absolute reference in Macros
Executing Macros
Outcomesof
the Workshop:
·
Once you attend these
workshops you will be benefited in your day to day work to achieve
newmilestonesby bringing efficiency & accuracy in your work.
·
Navigating through excel efficiently&
effectively
·
Representing and formatting data
·
Plotting various charts
·
Performing
sensitivity analysis
·
Using various analytical tools in excel
·
Using formula's and
functions
·
Organizing and analysing large
volume of data
·
Creating MIS report
using macros
Abuja Venue:Gracious
Hotel, Plot 29, Okemesi Crescent, New Polytechnic Layout(Old FERMA) Off
Mohammed Buhari Way, By Old CBN, Garki 2.
Dates:
3rd and 4th of March (Friday and Saturday) Time:
9:00 a.m. sharp
Lagos Venue: Kristina Jade Learning Center, 70b
Olorunlogbon Street, Off Alade Lawal Street, Anthony Village, Lagos.
Dates: 10th and 11th of March (Friday and
Saturday) Time: 9:00 a.m. sharp
Please feel free to contact us (08091728713/09050471922) or info@alvaexcel.com/ijoshuaolorunjoba@gmail.com for further queries & clarification. There is a class size limit.
0 comments:
Post a Comment