Features
- 16 hours of business focused Excel
- Using advanced graphs and presentation techniques to maximize impact
- How macros and VBA automate your spreadsheets and increase interactivity
- How superpower functions can solve complex problems
- Using PivotTables and PowerPivot to turn raw data into clear information that supports key decisions.
Ooutlines
Section 1: Efficiency and Risk
- Templates
- Increasing Efficiency and Reducing Risk
- Data Validation
Section 2: Advanced Techniques
- Functions with Superpowers
- Array Formula
- Tables
- Advanced Range Names
- What If Analysis
- Problem Solving
Section 3: Excel Interactivity
- Form Controls
- Visual Basic and Macros
Section 4: Spreadsheet Impact
- Conditional Formatting
- Charts that Inspire
- Sparklines
- Graphics Tricks and Techniques
Section 5: Turning Data into Decisions
- Working with External Data
- Advanced Uses of PivotTables
- PowerPivot
- Reporting with PowerPivot
- Course Plenary
Section 6: Course Plenary
Certificate
Log In Certificate of Completion will be provided to delegates who attend and complete the course.
Twitter
Studied or Worked here? Share Your Review
Please do not post:
Thank you once again for doing your part to keep Edarabia the most trusted education source.