Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,155,230 members, 7,825,892 topics. Date: Monday, 13 May 2024 at 05:23 AM |
Nairaland Forum / Entertainment / Events / Advanced Microsoft Excel Training. 15th-19th/02/2021 (298 Views)
Today's Date - 22.02.2022 : a Palindrome & Ambigram / Lady Releases Sultry Photos To Mark Her 19th Birthday / Enugu State Baby Of The Year 2003 Celebrates 15th Birthday With Stunning Photos (2) (3) (4)
(1) (Reply)
Advanced Microsoft Excel Training. 15th-19th/02/2021 by FINERESULTS(m): 8:40am On Dec 25, 2020 |
FineResults Research Services would like to invite you to take part in our upcoming workshops on Information Communication & Technology courses at our FineResults Services training facilities in Nairobi, Kenya. Date: Event 15th-19th/02/2021 : Advanced Microsoft Excel Training 22nd- 26th/03/2021: Advanced Microsoft Excel Training 19th- 23rd/04/2021 : Advanced Microsoft Excel Training Venue: FineResults Research Services, Nairobi, Kenya Training Centre. Click to Register: Physical class USD 800 : Online Training USD 700 Contact us: email: training@fineresultsresearch.org or Cell phone (+254 759 285 295) 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 TRAINING CUSTOMIZATION This training can also be customized for your institution upon request. You can also have it delivered your preferred location. For further inquiries, please contact us through Mobile: (+254 759 285 295) or Email: training@fineresultsresearch.org REQUIREMENTS Participants should be reasonably proficient in English. During the trainings, participants should come with their own laptops. TRAINING FEE The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits. ACCOMMODATION Accommodation is arranged upon request. For reservations contact us through Mobile: (+254 759 285 295) or Email: training@fineresultsresearch.org PAYMENT Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org CANCELLATION POLICY • All requests for cancellations must be received in writing. • Changes will become effective on the date of written confirmation being received. Visit our website for more details View related courses Collection and management of Research data using ODK and Kobo Toolbox Microsoft Excel Dynamic Dashboards for Management Reporting Microsoft Excel Skills for Business Accounting and Analysis Mobile Phone Based Data Collection for M&E Training Course on Adobe Illustrator Training Course on Adobe Photoshop Website design and development using Joomla CMS Website Design and Development using WordPress CMS Course The most popular courses Result-based Monitoring and Evaluation of Agricultural Projects Better and Timely Data Collection, Analysis and Visualization using ODK, SPSS/Stata/R and QGIS GIS and Remote Sensing in Agriculture, Food Security and Climate Change Enhancing Efficient Project Implementation and Evaluation Using Logical Frameworks and Project Cycle Management Accounting & Finance for Non-Financial Professionals using QuickBooks Application of Social Protection in Adapting Against Vulnerability Payment should be transferred to FineResults Research Services account through bank on or before C.O.B. 12th February 2021 Send proof of payment to training@fineresultsresearch.org View our Information Communication & Technology course Catalogue For any registration of 3 or more participants; we offer a discount of up to 10%. Click here now to Register. For further inquiries email training@fineresultsresearch.org or contact us on Tel: +254 759 285 295 |
(1) (Reply)
I Must Travel Abroard: Nigerian Man Beg To Be Deported After Spending 5yrs In It / What Technology Tools Are Event Planners Using To Manage Their Events? / Gender Analysis And Integration In Agriculture
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 12 |