Duration
2 days
Training Objectives
- Create a perfect workflow of collaboration process
- Transform data into intelligent analytical business report in just 3 minutes
- Automate tedious & time consuming tasks using functions & formulas
- Craft Professional & engaging report presentations
Training Outlines
- Grouping & Linking Data
- Range Name
- Create From selection
- Name Manager
- Grouping Sheets 3D References
- Grouping Data in multiple sheets
- Using Math Functions across multiple sheets
- Data Consolidation o Consolidation Data in Multiple sheets
- Consolidation Data in multiple workbooks
- The Process of Collaboration
- Data Validation
- Setting for data validation
- Creating drop-down list
- Creating indirect drop-down list
- Protection
- Protect Sheet & Protect Workbook
- Mark As Final
- Password to protect and edit file
- Protect sheet and hide the formula
- Allow users to edit ranges
- Allow range to edit
- Share & Merge
- Track Changes
- Share & Merge multiple workbook of data
- Functions & Formula
- Format Cell & References
- Absolute, Relative and Mix Reference
- Format cell to different number format
- Lookup Functions
- V&H Lookup
- Index & Match
- IFERROR & IFNA
- Logical Functions
- IF
- And / Or
- Nested IF
- Information Function (ISERR, ISERROR, ISEVEN etc...)
- Data Functions
- SumIF, CountlF etc...
- DSUM, DCOUNT etc...
- Text Functions
- Case Change
- Substitute & Replace
- Concatenate & Text to Column
- Transpose
- REPT, LEN & TRIM
- Date Functions
- Short Cut Keys for Date & Time
- TODAY & NOW
- DATEDIF
- DAY, MONTH, YEAR
- WORKDAY & NETWORKDAYS
- Pivot Table
- Create a Pivot Table
- Drill To Data
- Grouping of Row & Column Data
- Value Field Settings
- Show Value as
- Report Filter Pages
- Designing a pivot table report
- Pivot Charts
- Pivot Chart vs Normal Chart
- Combo Charts
- Dual Axis Chart
- Use of Slicer
- Creating a dashboard like data report
- Filter & Sort using slicer
- Slicer Tools
- Presenting the Data
- Format Cell & References
- Creating Slides with a blink of an eye using outline view Media Tools & Animations
- Applying video, audio together with animations
- Presenting Data using a Smart Art Diagram
- Linking Table or Chart from Excel
- Protect your presentation with password to open and edit
- Tips & Trick during a Professional Presentation
- Free Professional Template sharing to add the "wow' effect on your presentation
- Assessment:
- On-line assessment
- Pre & Post assessment
- Training Report
- 90 day back end support (1 to 1)
- Presentation by training provider:
Programme scope, delivery arrangements and suitability are confirmed during enquiry.