Invitation toInvitation to Advanced Excel Formulas and Functions Workshop Nairobi Kenya Sep 2022
outreach at fdc-k.ngo
outreach at fdc-k.ngo
Thu Aug 4 14:35:03 AEST 2022
<http://email.fdc-k.ngo/tracking/click?d=ykOh4e7rxS1IvR93-RI6YGWgaBjyAQBTQ_PUiLg2Ac_-wu74KQE95hD4uS7K3zj7316sCvR_0HNalejL6P_iYhLWpmxdLQ9nB7G453tHagj6uGbqiWkgqGvuXGCLAiU_lNXgB5FUB48JuJnaxDlB2uAOoIShNG7UXsB2WKcTXIZ3pAMVbkrLmkfcgGoK8VZ7sD-5VrEyM8H_tM2te2Za74XFQT6QOnCdCe5l14D2DDWd4Dp4hdUH1Cgd56_aTlo1zQ2>
Invitation
to Advanced Excel Formulas and Functions Workshop
12/09/2022 To 16/09/20225
DaysNairobi
KenyaUSD
1,000
<http://email.fdc-k.ngo/tracking/click?d=St0z54lGDU-981K9dLJkS4V9hC_V14H2NWgnNtnGNolvsIyrYlzR-DGm0P9Amr2U111Xe45nm8owo4IlwWd5zqkxjyc3rrKKp7Swzxp0uEs1WXGWKcXoyQtjwPPr8w6tXmIBM9X9FgbW9ba1_zTEOpSIYQ1tkOxu1N2oXIujusnfsYmkLs05dxASfTIC3uce0-6E1mXItqcpkyX11BVusPAxMpgYVwHU1696Ec-V9Ere7S_g7hsPEMwkjWmiibKUHMzFAjXfEz_W7M58ZCigPSY1>
Register
As Individual
<http://email.fdc-k.ngo/tracking/click?d=O0dMO2AxWtIN_WOIIZBqrF_QWhsiOPjeRQ3sSNhOrVF0NfslLVlx_5Ld4d--ttR7VTmW8ny2so5Rk-TGwsRlzxhVFxAh_-LwDve8whacRX0OYQA3o5T72hBt48ZyzSO1Zctu-ZZnbn2SzFz2Fv87hoWZ7HySFQnxzdnFK41UWTw0Sgo4w5BkwNnQ8DZFlVlT4c7GQdYR5IjjDrclrXWle93rcKN96D5T_Kl6CDY-h3FfkFThb_UyR2i33CEFT-TOGS9VwuaOa0cGSta7GCgJzcw1>
Register
For Online Training
<http://email.fdc-k.ngo/tracking/click?d=vfSddfA6CRniJhOulAb_NjknrEEHx7tNXz-Ff4buqwNV-BnOUeG7q5IBg3TNdeB5BBxsBJ7u-R0g5eH_0nxxwwHQYDxjp3RFW67Okn6Pf0OxjFA-ZmUTBy_TZsLMBz_HEukYvPh3DOonwQVU50KzTXXiOMZMlNHEGZ7MvWC74nXZsrKxGjQ8xfbxd4Uz1i-2JFgra6v22GxKAj03_oiDVAxIv2CujrC4BGUD8wWJM3KxLC9Onc4V91VCNifmqIGaKuOacmZDlajv3jxeWNAzB041>
Register
As A Group
·
Reach
out to us training at fdc-k.org or call +254712260031
·
<http://email.fdc-k.ngo/tracking/click?d=l6zfFP-hckb-RlvQdgDdhzm17lV7LEgp_YSHcG-I-AZwgz5H_0yRzo8-StWB0Ym9I6LyYwsQawLPWj9shsTJUn9ipT3cAD-4x7obCfcbZHiMzMg39rKsoiCQc4umJVsfj3pFjNdlxDjT5kweySGmXZk1>
WhatsApp
our consultant or
<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctLJosandtugvt1R4h5NUqO_2_NaUeDLg8rsVbPaKrX6pcHipSFuWzeyC0-BxCCswpwcWT0P5oJX969Gpx9OKNCVANSWI02WYimPXVgoEnlo8AEF4d685BshWI3gL0Za-EUk1>
Fill
form here
·
<http://email.fdc-k.ngo/tracking/click?d=nL2O3Cv7wz_EvWeaEkei-IKDTDbA2LQaHZuyJ-xpWcQCka1azKj_0Aowcxbci9BEussJ-lWeDYF0v4SsFCh3ToVOFvqG9lxeADPLJMrRoOQ7-GMZuTjXcxbxdCWIczE-nv0xQn0ugvPN54DRYKQGlfg1>
Online Training
Course
·
<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctNGY7Sp0mjHuz8tTmB3CrhuT0N5uGghlxahTHHRjmgkqqRXeyFt1_wdS15WgGhZFlgksF2Nkxx49xWwXNcVkhoG1-Hf5-K5LnWmhEEF64V7WHWXYi1KK35H_MAYBkfIzSvc1>
Professional Short
Training Courses
·
<http://email.fdc-k.ngo/tracking/click?d=TGc6SPNa6wsf0a20tv6iVc7ytTTqLPPJRFjjUrh-NGqMznux-NAb9L1ZqOpRr88BZfkB8lf3xwFR876slwSaO2UrfOx3PixjFRQq_xaolBslalJOyDq2MsALiv-f6tqTevSwaJLgWsI8wk4k-p6cD1hPDbAQUM84rIQkd7RKjDLefZefDaluyL-yqxHEBELb9A2>
Download
our Admission form
·
<http://email.fdc-k.ngo/tracking/click?d=w_VfFLiyHQlY_GhWiKD2-ThljEiimsYT9cHU2GKZFhf8peMC2sb0bGjPt6mOx1VJPcOamMv5I-GPF45NCe1pGzq2yiGAcPzWY4EbfthL8-yptt7RBU6g2UmxNkrQjzeXilfT99Koerfoe5bz_ZIvNDH7hWXqiB0lRIpZAQXHLW29kN63kdycK2GZpIWLALDNYw2>
Download
pre-training form to fill and share with us
·
<http://email.fdc-k.ngo/tracking/click?d=Igc_mk9-YF1Xi-sKmLzoETPspB6EZyE9HrHaWRKJ4HMXRI9MfzblTHE1NDcGOl__1tWiPPn1WfYZ4AjaF7KKWfGFsZ_BOrU0aKc1d4yatPQd5-xY6Negu1jpIf11mKmz5NkNw_TDVPYmAf9b7fywSD8wKGrljQrPOyUgf_XqjhoB0>
Download
our Calender 2022
·
FOSCORE
DEVELOPMENT CENTER
<http://email.fdc-k.ngo/tracking/click?d=yic_nxDoLAWK-PAnm7nPI2g-UVYf8xAYH0q2uxXwLg839IzuvNjaysUqlKC_peNYxUm3Hsscho0zAraKrBjpGFhkobJwv2o7Q6TcKIpgbWVDRFo_Lj1XbovsG2UPfXFt6VDcOpJ29PVajVo_Cl2up7NmnbecIR1Fyb3u2sRbcRZzX-Ud9YIQ5IwVpo8JPNTLYA2>
www.fdc-k.org
Introduction
The course
focuses on those aspects that are important in everyday day operation of
organization. Intermediate users will also benefit from this course as it covers
the in-depth topics of Complex Charts, PivotTables, Pivot Charts and management
Dashboards. The program explores an advanced approach t data validation and
excel. Participants will be able to boost their excel reporting expertise as a
result of this training program.
DURATION
5
days
WHO SHOULD
ATTEND?
Accountants,
senior and junior accountants, business analysts, accounting and finance
professionals, research professionals, marketing and sales, administrative
staff, supervisors, general business professionals and staff from any function
who need to learn and apply state-of-the-art techniques to their daily business
reporting, reconciliations, and analysis.
COURSE
OBJECTIVES
By
the end of this course the participants will be able to:
· Understand
business analytics and its importance to business
· Learn the
functions of excel analytics
· Learn the use
of different datasets using slicers and pivotal tables
· Understand
solving of problems using Excel tools
· Learn the
application of statistical tools and concepts such as ANOVA and regression
analysis using Excel
· Use tables, and
charts to represent the results
· Learn the use
of Power BI
DURATION
5
Days
WHO SHOULD
ATTEND
This
course targets professionals who are utilizing Excel and want to learn more on
reporting, preparation, and analysis. The course also targets individuals who
want to learn about business analytics via the use
of Advanced Excel.
COURSE
OUTLINE
Module
one:LOGICAL FUNCTIONS
· Understanding
Logical Functions
· Using IF With
Text
· Using IF With
Numbers
· Nesting IF
Functions
· Using
IFERROR
· Using TRUE and
FALSE
· Using
AND
· Using
OR
· Using
NOT
· SUMIF &
SUMIFS
· COUNTIF &
COUNTIFS
Module
Two: LOOKUP FUNCTIONS & Project Plan (Gantt
Chart)
· Understanding
Data Lookup Functions
· Using
CHOOSE
· Using
VLOOKUP
· Using VLOOKUP
for Exact Matches
· Using
HLOOKUP
· Using
INDEX
· Using
Match
· Understanding
Reference Functions
· Using ROW and
ROWS
· Using COLUMN
and COLUMNS
· Using
ADDRESS
· Using
INDIRECT
· Using
OFFSET
Module
Three:WHAT-IF ANALYSIS
· Scenario
Manager
· Goal
Seek
· Data
Table
Module
Four:FORMULA AUDITING
· Show
formulas
· Errors
checking
· Evaluate
formula
· Trace
precedents
· Trace
dependents
· Remove
arrows
Module
Five:Solver
· Understanding
How Solver Works
· Installing the
Solver Add-In
· Setting Solver
Parameters
· Adding Solver
Constraints
· Performing the
Solver Operation
· Running Solver
Reports
Module
Six:VALIDATING DATA
· Validating
Data
· Understanding
Data Validation
· Creating a
Number Range Validation
· Testing a
Validation
· Creating an
Input Message
· Creating an
Error Message
· Creating a Drop
Down List
· Using Formulas
as Validation Criteria
· Circling
Invalid Data
· Removing
Invalid Circles
· Copying
Validation Settings
Module
Seven:DATA CONSOLIDATION
· Understanding
Data Consolidation
· Consolidating
Data with Identical Layouts
· Creating a
Linked Consolidation
· Consolidating
Data with Different Layouts
· Consolidating
Data Using the SUM Function
Module
Eight:PIVOT TABLES& DASHBOARD MANAGEMENT
· understanding
Pivot Tables
· Recommended
Pivot Tables
· Creating Your
Own PivotTable
· Defining the
PivotTable Structure
· Filtering a
PivotTable
· Clearing a
Report Filter
· Switching
PivotTable Fields
· Formatting a
PivotTable
· Understanding
Slicers
· Creating
Slicers
· Inserting a
Timeline Filter
· Dashboard
Management
Module
Nine:TIME SERIES SALES FORECASTING USING ADVANCED EXCEL
· Understanding
Time series concept
· Historical
sales data management
· Historical data
analysis
· Time series
plot
· Understand
trend components
· The irregular
component in time series
· Design with
graph quarterly time series forecasts
Module
Ten:INTRODUCTION TO MODELS IN EXCEL
· Definition
· Keys Models and
Use
· Practical
Exercises
Module
Eleven: Business
Analytics using Excel
· Solver
Addin
· Histogram
· Goal
Seek
· Data
Table
· Scenario
Manager
· Descriptive
Statistics
Module
Twelve:Statistical Analysis using Excel
· Testing
hypothesis
· ANOVA
· Covariance
· Correlation
· Regression
Module
Thirteen:Excel VBA
· MsgBox
· VBA
variables
· Events
· Array
· VBA
functions
· Application
Object
Module
Fourteen:Power BI
· Power
Pivot
· Power
View
· Power
Query
· Power
Map
General
Notes
· All
our courses can be Tailor-made to participants' needs
· The
participant must be conversant in English
· Presentations
are well-guided, practical exercises, web-based tutorials, and group work. Our
facilitators are experts with more than 10 years of experience.
· Upon
completion of training the participant will be issued with a Foscore development
center certificate (FDC-K)
· Training
will be done at the Foscore development center (FDC-K) centers. We also offer
inhouse and online training on the client schedule
· Course
duration is flexible and the contents can be modified to fit any number of
days.
· The
course fee for onsite training includes facilitation training materials, 2
coffee breaks, a buffet lunch, and a Certificate of successful completion of
Training. Participants will be responsible for their own travel expenses and
arrangements, airport transfers, visa application dinners, health/accident
insurance, and other personal expenses.
· Accommodation,
pickup, freight booking, and Visa processing arrangement, are done on request,
at discounted prices.
· Tablet
and Laptops are provided to participants on request as an add-on cost to the
training fee.
· One-year free
Consultation and Coaching provided after the course.
· Register
as a group of more than two and enjoy a discount of (10% to 50%)
· Payment
should be done before commence of the training or as agreed by the parties, to
the FOSCORE DEVELOPMENT CENTER account, so as to enable us to prepare better for
you.
· For
any inquiries reach us at training at fdc-k.org or
+254712260031
· Website:
<http://email.fdc-k.ngo/tracking/click?d=9i8NH0YxugT77q2FrIW15frp8_rxP3qYLjMng5Mp38EP0yXf_uMNNxygT4zC0SoQgnzYxqgTgyRSTqReK8e8X2xcU52TUH8sqKZDvizPAtOueaSBSsCg0BV03yEf_yevqQ2>
www.fdc-k.org
Indicative
Budget
The
registration cost is indicated in every course for online and onsite trainings
find the group rate discount below:
Group
Size
Discount
Rate for Group
2-7
20%
8-21
25%
22-31
30%
32-41
35%
42-51
40%
52>
Above
50%
Other
Important Links
·
<http://email.fdc-k.ngo/tracking/click?d=KLljWUOzVpfxObUaI_1vCVpT3bxpxhBT8aqxNNoEmGqleAl-liL9NRGd80ejkepbAnzKurNqz6BAQJM-NRGuZN-z_mEH_JnaNAhWFDY08RKY3-i9Rwb1G7PMeG1ximU4_ujhWebIuOc83P-jYiJAxxSz8FHbMAwf69UmwfrmNm550>
Humanitarian
and Social Development professional short courses
·
<http://email.fdc-k.ngo/tracking/click?d=iiOi7TnNqvix6G3iLEcxMmcdSHV3pSiLzX3n2WmpqcsCRLFFCt4X4Mdnj-28nasMPC-VCQBp1hn2bq0bdo7TCGs8fj0MPmJHxxuc8M-8I3x-clklVpMm1pfeZcCo2yQ_kp-hVC9smeK9XAgRhxJm523TrI2RuKeb2TV-iIPI0Rrl0>
Monitoring
and Evaluation professional short courses
·
<http://email.fdc-k.ngo/tracking/click?d=5KMl_woZI3Kx63y1WPA5sc3xOBCX04pu-FvhlXc0sEm3w2Tg_93W4uwM2TXEBmboKSlFJ0AIaZ-Dg9uzxL3sE6m_nWnxCMzMy-oFUINDQ1WWYC_O78cMHJa2A0HkRpAJOmxLs5c6-GEmzkqcdrVpXTtQCrApalFlorxbAyemlTTN0>
Research
and Data Analysis professional short courses
·
<http://email.fdc-k.ngo/tracking/click?d=nz09lGE-ZUGyT5DqYahGI1hIO4YwTRlmiyb7-jBZESaQ_2CpPufQC3jtpopvbUzvGZk5fwocVFV4fGJ1rmu9_w6oKMJBvxcCYYXtO57w5ANrz4OoJL5mFwQP7q1V2lvGOFQGJEwAj0SZWHdKT6dtZBV5J7Blqq_MwsWS34pjglO00>
Information
Technology professional short courses
·
<http://email.fdc-k.ngo/tracking/click?d=lJAwHq4FttzgxqoBHE2OjeaWUGkzl-sSpWfHfOjrqGOuIRc9kBlheoI8_doEdkJzP5-1tGknzxoPSGH3cr1oLCTQjq9MsU33TRWDgKi7t3mVDlPSKeqvyZEf8UP3M5bPHgV3OfXjAtEyMi5ULoUyVins4N4CWAgqiu0OHQ28DzIs0>
Agriculture
professional short courses
·
<http://email.fdc-k.ngo/tracking/click?d=2j4YqRryr19io-Urn5g1VOQ5-UokqjMMohE0BKbg2Vrhkm9ZW6Z3pc40O59tcifa_9IJ5qnYwYz2EwyWJb89dGwJ2x8izbX2XGJjGnnoLTXd5UKZSuOoeaICTrfmxypzK7DzLThs06-z8eW9-SOeKOk1>
GIS
& Remote Sensing professional short courses
·
<http://email.fdc-k.ngo/tracking/click?d=VzI73Il7O4Dg8UQVZcGIrfdrTzWTfJwEzEipX1YLeJc8SKbf6lc4d5HufYfhO2KdKI1JRVBf1w0Zdt4BZwcBc7i-p0lm9fHiiIeQ59ifNRSL2K9z8vym0U3W7Szv4URtfB8x-bTN6-9xezT3FtCUyxi7RGIR8-mnDrcIDAiWAKLl0>
Business
and Governance professional short courses
·
<http://email.fdc-k.ngo/tracking/click?d=nL2O3Cv7wz_EvWeaEkei-IKDTDbA2LQaHZuyJ-xpWcQCka1azKj_0Aowcxbci9BEgNoe5ytJ_U99gTNvTWo4XREF5PTcWwEZHHm1LPYnvY8CVRTKcX8vVN_z1lLNYfQ9zREoglsKISHLKKM1i3t7tsY1>
Online
Training Course
·
<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctNGY7Sp0mjHuz8tTmB3CrhuT0N5uGghlxahTHHRjmgkqWnHVkrRg6BAIDtLhfQLWslp4cJOeR463D9tcLVsWuRcn-1e8gfXKjE9vJZWBBdFQKI404qvQzoSkVWeHQkVtrXg1>
Professional
Short Training Courses
·
Reach
out to us training at fdc-k.org or call +254712260031
·
<http://email.fdc-k.ngo/tracking/click?d=l6zfFP-hckb-RlvQdgDdhzm17lV7LEgp_YSHcG-I-AZpXcDuT9eLtLdphsTO9o0B5e3j4BkhbuH3tNMH0lY2xg2ZnjlMEURE1jghEyI0tN1sb2GRp5GuCovSGXEvThrwRrEqYD41CnC1qAf4d2CcQR01>
WhatsApp
our consultant
or
<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctLJosandtugvt1R4h5NUqO_2_NaUeDLg8rsVbPaKrX6pLplZjxePnDxt9oPJTxCI3eN9TYtgUTc6hNPAI0JfIeIJ10ksee8j7HfTTjsW8heqgwrI-T_1oUzyd8H8_S7tHP01>
Fill
form here
Kind
Regards
Jackson
Munene
Training
Manager
Foscore
Development Center www.fdc-k.org
Email:
jackson at fdc-k.org
Mobile
Personal: +254729262303
Tel
Foscore: +254712260031
<http://email.fdc-k.ngo/tracking/unsubscribe?d=WJul6AXagTIWKn--VUHxSPZ2vah1dHBvA5B18oVBszRZtOh5W3CzR9Mavu4cgzHPk3Unw7bSHHtG3JwJrd0S6XEbgDMaf_TTooLgvC_8dMYNEkUixIigTr_S3SdU4YSz6w2>
UNSUBSCRIBE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ozlabs.org/pipermail/linux-accelerators/attachments/20220804/c91e30a3/attachment-0001.htm>
More information about the Linux-accelerators
mailing list