TRAINING IN ADVANCED EXCEL FOR DATA MANAGEMENT, GRAPHICS AND ANALYSIS 14th To 18th February 2022-Email: [email protected] Call+254727446544
David Onkware
Learning & Development| Business Development| Corporate Training| Organizational Development| Knowledge Management| | Proposal writer| Trainer
TRAINING IN ADVANCED EXCEL FOR DATA MANAGEMENT, GRAPHICS AND ANALYSIS?14th To 18th February 2022-Email [email protected] Call+254727446544
EVENT:?TRAINING COURSE DATA MANAGEMENT, GRAPHICS AND STATISTICAL ANALYSIS?USING ADVANCED EXCEL
DURATION:?5 Days
VENUE:?SID Institute Training Center; Nairobi, Kenya
EVENT DATE:?14-02-2022 TO 18-02-2022
Course Description
This course is designed to give an insight into some of the more advanced features in Excel and will be of particular interest to those who want to build or work with financial models, carry out detailed data analysis and automate tasks by recording macros.
Who should attend?
? All employees working with Excel
Learning Objectives
? Create and use defined names in a workbook
? Work with logical function in Excel
? Use a variety of data validation techniques
? Use a range of lookup and reference functions
? Create summaries in your spreadsheets using subtotals
? Understand and create simple PivotTables
? Construct and operate PivotTables using some of the more advanced techniques
? Perform a variety of analytical tasks using PowerPivot
? Use the Data Consolidation feature to combine data from several workbooks into one
? Create and work with scenarios and the Scenario Manager
? Use Solver to solve more complex and intricate problems
? Import data into Excel and export data from Excel
? Create and use a range of controls in a worksheet
? Create recorded macros in Excel
? Import data into Excel and export data from Excel
MODULES 1: .What-if Analysis
? Using the Scenario Manager
? Creating and editing scenarios
? Creating a Scenario Report
? Using Goal Seek
MODULES 2: Data Tables
? The single-variable data table
? The two-variable data table
? Adding conditional formatting
MODULES 3: Working with Outlines
? Applying an outline
? Automatic outlining
领英推荐
? Displaying and collapsing levels
? Modifying outline settings
? Creating subtotals
MODULES 4: Analyzing Data with Pivot Tables
? Creating a pivot table
? Defining the source range
? Inserting. Moving and deleting fields
? Showing and hiding fields
? Grouping and ungrouping fields
? Renaming fields
? Defining field properties
? Formatting a pivot table
? Refreshing a pivot table
? Drilling down
MODULES 5: Excel Macros
? About macros and VBA
? Macro security
? Recording macros
? Running a Macro
? Absolute and relative reference
? Saving and distributing macros
? Assigning a macro to a button
? Editing macro code
? Automatic macros
If you opt to have this course delivered in-house, the content above can be tweaked and changed to ensure the course meets your specific needs.
For further inquiries, please contact us on?
Tel:?+254 727 446 544
Mob:?+254 727 446 544.
EMAIL: [email protected]
Website:?www.sidinstitute.com
REQUIREMENTS AND TRAINING VENUE
The training will be held at?SID Institute Training Center. Delegates should be reasonably proficient in English.?Applicants must live up to SID Institute admission criteria.
ACCREDITATION
Upon successful completion of this training, participants will be issued with a certificate.
CUSTOMIZED/TAILOR- MADE
We will customize this training to fit your professional and institution expected outcome.?You can have it delivered at SID Institute or at a convenient location.
Kindly Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and delivery methodology?