OVERVIEW
This course is for all who need the power of Excel for data analysis and reporting features not available in other project management software tools. This training course is a fast-paced, hands-on workshop. Every student will be provided with a computer running Excel. Guided by an expert instructor, you’ll leave this training course with the real-world experience you need to fully harness the powerful tools Excel has to offer back in your workplace.
COURSE METHODOLOGY
The format of the three-day workshop is a series of brief lectures followed by discussion and hands-on exercises. Case studies and real-life examples are used to illustrate success and failure.
COURSE OBJECTIVES
This course allows the delegate to experience the power of Excel 2019
COURSE DETAILS
COURSE DURATION | LANGUAGE | CERTIFICATE |
3 Days Online: 6 sessions (18 hours) | English | DISS |
| *Please notify us if an interpretation is required |
COURSE OUTLINE
| DAY 1 | DAY 2 | DAY 3 |
| CONTROL DATA • Format Cells • Data Validation and input control • Paste Special • Painter • Conditional Formatting • Some usable functions for controlling inputs. • Working with Texts in Excel | DATA ANALYSIS • Worksheet Backgrounds • AutoFill a Series • Removing Duplicates • Pivotable and Data summarization • Search in Data by Functions • Adding Formula and Calculating financial Factors (PV, FV, NPV, IRR, PMT, IMPT) • COUNTIF & COUNTIFS • SUMIFS • Index, Match, Indirect, and offset practical usage. • Conditional Sorting and Filtering • Useful Functions in Management and Financial Analysis • Intelligent Scoring Model for various analysis • Advanced Grouping and Filters | PROJECT DASHBOARD • Chart Types • Pivotables and Charts • Data summarization and reporting • Gauge Chart • Sparklines and Data Analysis • Dynamic Charts and Dynamic Lists |
| SCHEDULE ANALYSIS • Creating Dynamic Gant chart in Excel • Advanced Schedule Data Analysis | AUTOMATION • Inserting Hyperlinks • Creating a Macro • Assign a Macro to a Button or Shape • Run a Macro upon Opening a Workbook • Smart Art and Graphs • Page Orientation • Page Breaks • Print Area • Create Dynamic Auto-filled letters and Lists. | |
| DATA TRANSFORMATION AND LOOKUP • Creating Formulas • Common Formulas • Searching for Formulas • V-look-up and H-look-up functions • Creating the Lists and Combo Box • Indirect, Offset, Index, and other lookup functions. | FORECASTING THE FUTURE • Scenario Analysis in Project Management • What-If Analysis and Goal Seek • Data Table and Goal Seek. • Using a solver tool to optimize calculations and forecasts. • Forecasting the future with various tools | PIVOTABLE • Summarize Data with Pivotables • Using Pivot charts to create dynamic charts. • Advanced settings on Pivotable |
| BI in EXCEL • Introduction to BI • Introduction to BI tools in Excel (Power Query, Power PIVOT and Power View) |
COURSE TYPE: VIRTUAL CLASSROOM
Upcoming Course Schedule
QUICK REGISTER
TESTIMONIAL
Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Meet THE INSTRUCTORS
Instructor Name
Profession
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Instructor Name
Profession
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Related Courses
