- مدة الدورة التدريبية: 16 Hours
تفاصيل الدورة
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.
OUTLINES Section 1: Efficiency and Risk
- Templates
- Increasing Efficiency and Reducing Risk
- Data Validation
- 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.
تحديث بتاريخ 26 August, 2018- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- MS Office 365 Core Apps Skill-Up22 USD
222 USDمدة الدورة التدريبية: Upto 1 Hour - Linear Regression Analysis In MS Excel StudyPlex17 USD
180 USDمدة الدورة التدريبية: Upto 3 Hours