public inbox for dwz@sourceware.org
 help / color / mirror / Atom feed
* RE: Invitation toInvitation to Advanced Excel Formulas and Functions Workshop  Nairobi Kenya Sep 2022
@ 2022-08-04  3:10 outreach
  0 siblings, 0 replies; only message in thread
From: outreach @ 2022-08-04  3:10 UTC (permalink / raw)
  To: dwz


<http://email.fdc-k.ngo/tracking/click?d=ykOh4e7rxS1IvR93-RI6YGWgaBjyAQBTQ_PUiLg2Ac_-wu74KQE95hD4uS7K3zj7316sCvR_0HNalejL6P_iYhLWpmxdLQ9nB7G453tHagj6uGbqiWkgqGvuXGCLAiU_lNXgB5FUB48JuJnaxDlB2u9bleuwnbd0GUgDmEDhfQQQA2kOfZxdGnzIHEWLwEWMwvVY9QyAOiTuki-QswsHu8CvkGbv_FmiXlLZRsp8-flNN1zSMz-Er5vV3CjkekzORA2>
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_zTEOpSIYQ1tkOxu1N2oXIujuslYc5hgANm3fypJXmc_eemykk3hp1hzY9gDT1OYP_vykJs51sEv4nZSW0L1ksGptr-ps_fcb5Prn2jNXRpDyNBczgissVPb7d6hi2ORulAbxJ41>
Register 
      As Individual
<http://email.fdc-k.ngo/tracking/click?d=O0dMO2AxWtIN_WOIIZBqrF_QWhsiOPjeRQ3sSNhOrVF0NfslLVlx_5Ld4d--ttR7VTmW8ny2so5Rk-TGwsRlzxhVFxAh_-LwDve8whacRX0OYQA3o5T72hBt48ZyzSO1Zctu-ZZnbn2SzFz2Fv87hoWZ7HySFQnxzdnFK41UWTygBniNuXJJY2XpZAC_YxFyvd4yA_pwfx3MPSF0jTsP9PqBN2Jqnzl4vrPJxtCjhN8kEN_rq-OBFZtdaMTxYIavSVMz3jQn7huvu1zGsuaomSM1>
Register 
      For Online Training
<http://email.fdc-k.ngo/tracking/click?d=vfSddfA6CRniJhOulAb_NjknrEEHx7tNXz-Ff4buqwNV-BnOUeG7q5IBg3TNdeB5BBxsBJ7u-R0g5eH_0nxxwwHQYDxjp3RFW67Okn6Pf0OxjFA-ZmUTBy_TZsLMBz_HEukYvPh3DOonwQVU50KzTXXiOMZMlNHEGZ7MvWC74nULq_4Qd6yuEBuC6NHia4NAeBrcsJvfTe7qOqRXX1DdPcKZ-UiqCJk7NH1PpccsVEG4YyQ8ZcdzUkJdwSX7bczM1zyIAHg09WE6eiX_MJYBlyY1>
Register 
      As A Group
·         
    
Reach 
out to us training@fdc-k.org or call +254712260031
·         

<http://email.fdc-k.ngo/tracking/click?d=l6zfFP-hckb-RlvQdgDdhzm17lV7LEgp_YSHcG-I-AZn1zuIUYQxvMIdimuE3aWwo0mcUWqJt3NlNIXDv2GAD_zww9o876fLdUtMKHrTiw_3LbQM-X0fN7k4h4xKYorIyn-avgReK-Nd38Tonn3LNGY1>
WhatsApp 
our consultant or 
<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctLJosandtugvt1R4h5NUqO-V8xATIgdsnCq3Ud9otU3mPxUd4KPol_V2nr97kaWY60Myyu-DgYPqnowWgaepmIH3g2MPRobqcOVZdAgIR3QvuDWBuQ4dCBNu0brMYpuYrzU1>
Fill 
form here
·         

<http://email.fdc-k.ngo/tracking/click?d=nL2O3Cv7wz_EvWeaEkei-IKDTDbA2LQaHZuyJ-xpWcTf5xmUP20v6ORbewB-LG2_jW7C5QjiMVJ_JaVPDDh41d80Wngt5Q0EVKg_yAlQMzB8GuXEywR-A_Vqi_Nf4r1lv5WJFuTCoVymz9XJ6krYiiM1>
Online Training 
Course
·         

<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctNGY7Sp0mjHuz8tTmB3CrhsrRJ3rgxAwQ4dhdDo3wF-Pfy6e878S2nAnamT5Yq-OW54-QPdRHf0TzMvO2PNrCb28adGzPGU_bjYGB4EpWc3ft-kaSY1631M3k3RZpFKppGo1>
Professional Short 
Training Courses
·         

<http://email.fdc-k.ngo/tracking/click?d=TGc6SPNa6wsf0a20tv6iVc7ytTTqLPPJRFjjUrh-NGqMznux-NAb9L1ZqOpRr88BZfkB8lf3xwFR876slwSaO7Ym7Q-WZ3qdTKRc_HP5yMST_Jb5o2BGZHMtPCNy2jSyaCz5RcRVX2Rsgtmu5pzfY_9PGuFNj8iKzM5bCyEY1BumLNlzAx2wSifinSV4yAmCag2>
Download 
our Admission form
·         

<http://email.fdc-k.ngo/tracking/click?d=w_VfFLiyHQlY_GhWiKD2-ThljEiimsYT9cHU2GKZFhf8peMC2sb0bGjPt6mOx1VJPcOamMv5I-GPF45NCe1pG8jQyrZEZ1F1XdYbTJAayWCn14YPtvKsF6XdCGdnLCLv2tFzp3kVnZuPDN9wzD5VChVkE3hldUn0sOcEW4LcRipzz1QFt2jFv9bM7ZyctEL5sw2>
Download 
pre-training form to fill and share with us
·         

<http://email.fdc-k.ngo/tracking/click?d=Igc_mk9-YF1Xi-sKmLzoETPspB6EZyE9HrHaWRKJ4HMXRI9MfzblTHE1NDcGOl__54uHO0cdSY5E_H5FbAZMJFA0XhHUpDX3eaoZ0g_ctwlsiVA-Lw5BV8nyLER7G37PeVi0M4b0fGFXPH5QRWty7At4qUtvh6WoSw9HME4AzTf60>
Download 
our Calender 2022
·         
FOSCORE 
DEVELOPMENT CENTER 
<http://email.fdc-k.ngo/tracking/click?d=yic_nxDoLAWK-PAnm7nPI2g-UVYf8xAYH0q2uxXwLg839IzuvNjaysUqlKC_peNYxUm3Hsscho0zAraKrBjpGOWJfDDU0bJo2ZQdvFaGBXI_nkP8UJ5AZ5FYzbdpulmMWzKpieOkL25KaW1Lp0q5rjt0r01kVglKlGvASpV3dDuCzK4HgjmhHSt3IQOhHHdVtQ2>
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@fdc-k.org or 
+254712260031
 
·         Website:
<http://email.fdc-k.ngo/tracking/click?d=9i8NH0YxugT77q2FrIW15frp8_rxP3qYLjMng5Mp38FsjYtzl1rE4Qsh93EFZHZ9ngWmmjuVuqfupa9ST5c1w-67TjCY_lBZEI7AePUglDy8Hv3uKYAbVCrSZeb1HTL7bA2>
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-liL9NRGd80ejkepbc989RIRr4CLczmIzqJsbzVysnytunP16EENYtryglBH8sw3kg2QhRThyHUkA8w5It2UBkFHbghhnlNFubHK-RQu7HGTKKxfwmcpjTzQlx17E0>
Humanitarian 
and Social Development professional short courses
·         

<http://email.fdc-k.ngo/tracking/click?d=iiOi7TnNqvix6G3iLEcxMmcdSHV3pSiLzX3n2WmpqcsCRLFFCt4X4Mdnj-28nasMPC-VCQBp1hn2bq0bdo7TCBmWK7obo57wWPOEVQJvhzXa2y4SpV1HuDlAxt2tX4jsqQIC3kF2TmBjeiotvX0WBUXri6T5-Zi7KGiFS48LSa9V0>
Monitoring 
and Evaluation professional short courses
·         

<http://email.fdc-k.ngo/tracking/click?d=5KMl_woZI3Kx63y1WPA5sc3xOBCX04pu-FvhlXc0sEm3w2Tg_93W4uwM2TXEBmboKSlFJ0AIaZ-Dg9uzxL3sExoxg7Ol1rUJ95Vba2fJgHvbfCvirlsoTzlYEF75ocN9CWVkowmi_mIB620qqCvnyTtdkoa9b3ln-a22bELqDY2N0>
Research 
and Data Analysis professional short courses
·         

<http://email.fdc-k.ngo/tracking/click?d=nz09lGE-ZUGyT5DqYahGI1hIO4YwTRlmiyb7-jBZESaQ_2CpPufQC3jtpopvbUzvjXZozw0TvOrK5lQmoWebndZ8l1sFPiRWpTKLoc0AHL_1Xp4XGFUjUyTBKxVFvVr6uBIgsKtu41-c6ROPUBw_LGMoFQ79LjhiRIIqqJ9CtQsB0>
Information 
Technology professional short courses
·         

<http://email.fdc-k.ngo/tracking/click?d=lJAwHq4FttzgxqoBHE2OjeaWUGkzl-sSpWfHfOjrqGOuIRc9kBlheoI8_doEdkJzNrckwYKBwFekQsQOthxgVAGtHEACq0NNPUHallZs9qP7lqXYl2b00inemGlbu4KecWH_MjETOSWzvo-1oTpfyLdRLJ24yaHuA-NxFE3HQVI40>
Agriculture 
professional short courses
·         

<http://email.fdc-k.ngo/tracking/click?d=2j4YqRryr19io-Urn5g1VOQ5-UokqjMMohE0BKbg2Vo-MPJ1jeJJfPLadcF9HFzyfPqJymdZBSIGpNm-0AJZw6p9I0fzZDu7YfXMVy0Y4gGod3aH9MA5aE-4x8QslYEJ4PN1ys-MWJBK_WSrol4v0iM1>
GIS 
& Remote Sensing professional short courses
·         

<http://email.fdc-k.ngo/tracking/click?d=VzI73Il7O4Dg8UQVZcGIrfdrTzWTfJwEzEipX1YLeJc8SKbf6lc4d5HufYfhO2KdKI1JRVBf1w0Zdt4BZwcBc50W3yVnT8Jxc7mIzMd8tFN8qOmXbgmggai1sSzYuuqxLymiVzQIfuVJ123F9Z8D1nD2bz27Zv3gX6NGjhm02Scx0>
Business 
and Governance professional short courses
·         

<http://email.fdc-k.ngo/tracking/click?d=nL2O3Cv7wz_EvWeaEkei-IKDTDbA2LQaHZuyJ-xpWcTf5xmUP20v6ORbewB-LG2_0Lp0O8ZyWOdbV-PlfNGZclBmd9-Sd_TU9hQXp_igdX3eI8Z7e85BXKNH3KAjUfHwSNFv0nwkbJ25WVZ-3MnvVXw1>
Online 
Training Course
·         

<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctNGY7Sp0mjHuz8tTmB3CrhsrRJ3rgxAwQ4dhdDo3wF-PxLwrsovwtL45Wh7W0e-D-A-Xlir_zACPJIh0KuKuSKfezdZKeaJwNRxBtg8VhToOKAKHt5wzNJJDq_TPYJq-omQ1>
Professional 
Short Training Courses
·         
Reach 
out to us training@fdc-k.org or call +254712260031
·         

<http://email.fdc-k.ngo/tracking/click?d=l6zfFP-hckb-RlvQdgDdhzm17lV7LEgp_YSHcG-I-AZn1zuIUYQxvMIdimuE3aWwOs2I1mMh7nEJDJ5rc8kRihcALeAdjmSYGO2nwSYtM1JpC4F0-90SC91XpwxxAeojO1_32RcmzK1o_mzMNuHiDa81>
WhatsApp 
our consultant 
or 
<http://email.fdc-k.ngo/tracking/click?d=onnMgZrG2lzEYMT-KggctLJosandtugvt1R4h5NUqO-V8xATIgdsnCq3Ud9otU3mmMeLMSSlFaAniqVr4me7R-xuC-Q4efQ1pRLRcK3gA0HZjVDHvL1QHzE-ZxrNDvlmnrl523PBsTJwZ_Dwih_aEvc1>
Fill 
form here
 
Kind 
Regards
Jackson 
Munene
Training 
Manager 
Foscore 
Development Center www.fdc-k.org
Email: 
jackson@fdc-k.org
Mobile 
Personal: +254729262303
Tel 
Foscore: +254712260031

 
<http://email.fdc-k.ngo/tracking/unsubscribe?d=zvi9SDTuX36m-aj7d7imnXegLgi6ahcHdaGHTisdW7ICcfS5sjIgaINM_yRzFgJu3RaTwbkprcySMay6cLHqRrh8uwT_5mTP1SU_00WNyAyd0>
UNSUBSCRIBE

^ permalink raw reply	[flat|nested] only message in thread

only message in thread, other threads:[~2022-08-04  3:10 UTC | newest]

Thread overview: (only message) (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2022-08-04  3:10 Invitation toInvitation to Advanced Excel Formulas and Functions Workshop Nairobi Kenya Sep 2022 outreach

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).