Course date: 23/01/2023 to 27/01/2023 |
Duration: 5 Days |
Course fee: USD 1,000, KES 90,000 |
---|
INTRODUCTION Excel has powerful tools that enable busy users to set up systems that simplify data management, analysis and presentation. 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 in your workplace functions. We look at data entry and management, pivot tables, formulae, graphics for results presentation and useful shortcuts. 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 OBJECTIVES By the end of the training, participants should be able to: · Familiarize with advanced formulas and functions in Microsoft Excel · Combine data, link and export data · Create key outputs from data (tables and graphs) · Reduce the amount of time spent in delivering output through Microsoft Excel through time-saving keyboard shortcuts · Easily summarize, analyse and present data through pivot tables and charts.
TOPICS TO BE COVERED Module 1: Introduction • Navigating within the sheet • Making selection (Shift+Spacebar; Ctrl + spacebar) • Entering data • Data management in Excel (Text to column, filtering, sorting, flashfill, remove duplicates, data validation) • Deleting unwanted data • Find errors, conditional formatting and data validation
Module 2: 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 • Referencing in Excel • Working with Structured tables (Ctrl + T) • Excel Formula Basics • Keyboard shortcuts in Excel
Module 3: Pivot Table and Pivot Charts • Preparing data for use with Pivot Table • Creating Pivoting Tables • Summarizing PivotTable Data • Sorting and Filtering Pivot Table • Formatting PivotTable • Applying Conditional Formatting • Working with Calculated Fields • Grouping Data • Filters and Advanced Filter • Advanced Data Field Settings • Creating Pivot Chart • Power Query • Printing Pivot Tables and Pivot Charts • GETPIVOTDATA function
Module 4: Excel Functions • Lookup/Ref Functions • String/Text Functions • Date/Time Functions • Math/Trig Functions • Statistical Functions • Logical Functions • Information Functions • Financial Functions • Database Functions • Engineering Functions
Module 5: Practical application of Excel • Project assignment involving huge application of Pivot Tables, Formulae and Shortcuts • Recap of entire course • Course evaluation • Action planning
*************************** 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 732 776 700 or +254 759 285 295. You can also email us on: 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 and lunch.
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 bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org
CANCELLATION POLICY
|
Course Date: 23/01/2023 to 27/01/2023 |
Duration: 5 Days |
Course fee: USD 1,000 , KES 90,000 |