NOTICE: Many events listed here have been canceled or postponed due to the Covid-19 emergency. It is best to call ahead or check with organizer's websites to verify the status of any local event.

Change Location × Nairobi, Kenya

    Recent Locations

      Advanced Microsoft Excel Training in Nairobi


      • Advanced Microsoft Excel Training Photo #1
      1 of 1
      August 10, 2020 - August 14, 2020

       

      Nairobi, Nairobi Municipality

      Performers:
      • No Performers Listed
      EVENT DETAILS
      Advanced Microsoft Excel Training

      Dear all,
      RE:Advanced Microsoft Excel Training

      FineResults Research Services would like to invite you to high impact training on Advanced Microsoft Excel Training to be held in Nairobi from 10/08/2020 to 14/08/2020

      Event information
      Course Name : Advanced Microsoft Excel Training
      Venue : FineResults Research, Nairobi, Kenya
      Event Date : 10/08/2020 to 14/08/2020
      Course Fee : KES 65000 or USD 800
      Registration : REGISTER HERE

      INTRODUCTION
      Excel has powerful tools that enable busy users to set up systems that simplify data analysis and interpretation. Effectively using Excel allows users to devote their time more profitably to making decisions about and acting on results, with more effective outcomes. This course gives practical experience in the use of Microsoft Excel for data summary, presentation and for other basic statistical work. It concentrates on areas where Excel really can excel, such as array functions. We look at data entry and management, pivot tables, and graphics. We also review Excel's facilities for statistical analysis, advising on their use and limitations, and we show how add-ins can be used to enhance Excel's capabilities. Participants will learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office. In addition to the practical component, all participants will also receive a manual describing all the techniques learned.
      Duration
      5 days
      COURSE OUTLINE
      Module 1
      •Introduction to Excel FORMATING
      • Adjusting Numeric Formats
      • Controlling Fonts, Borders and Cell Color
      • Alignment Tools & Other formatting Tools
      • Row, Column and Sheet Adjustment & Adding Picture
      • Excel Formula Basics
      Module 2
      • Introduction to Pivot Table
      • Creating Pivoting Tables
      • Summarizing PivotTable Data
      • Sorting and Filtering Pivot Table
      • Formatting PivotTable
      • Applying Conditional Formatting
      • Printing Pivot Tables and Pivot Charts
      • The “if” Function
      Module 3
      • Printing Pivoting Tables
      • Using Date and Time Functions
      • Look Up functions
      • Data Validation
      • Data Validation Exercises
      • Linking Sheets
      Module 4
      • Creating Forms
      • Introducing Macros
      • Sorting and Filtering data
      • Formatting Dashboards
      • Macros continued
      • Macros - Advanced
      Module 5
      • Introduction to VBA
      • Basics of VBA Programming
      • VBA Conditional Statements
      • VBA Loops Statements
      • VBA Message Box and input
      • VBA Miscellaneous & Macros
      NB: We are offering you a half day, fun and interactive team building event!
      ACCOMMODATION
      Accommodation is arranged upon request. For reservations contact us through Mobile: +254 732 776 700 / +254 759 285 295 or Email: training@fineresultsresearch.org
      PAYMENT
      Payment should be transferred to FineResults Research Services Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org

      Visit our website for more details

      How to participate
      Individual Registration
      Contact information
      Email:training@fineresultsresearch.org
      TEL: +254 732 776 700 / +254 759 285 295
      Website: fineresultsresearch.org/training/
      Visit our face book page
      Visit our linkedin page
      Visit our twitter account

      Categories: Education | Business & Networking | Organizations & Meetups

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.

      Hotels and Airbnbs near Advanced Microsoft Excel Training. Book your stay now!