Starting: Next Saturday 1 feb 2014 6:00PM Every Sat, Mon, Wed from 6:00pm to 9:00 pm Mastering Excel 2013: Comprehensive Course 48 Hours • Pilot • Managing Excel Environment and Excel Options. • Formatting content. • Illustrating data using graphs, charts, and powerview • Transforming data into meaningful info using povotTables – data model • Formulas and functions basics. • Mastering the most important types of Excel Functions: Math, Logical, Lookup, Text, Date and Time, database and power functions. In addition to managing errors in formulas. • Data Validation techniques. • What-if analysis tools: Scenarios – Data tables and goal seek • Creating forms in Excel and using form controls. Introduction to VBA. • Statistical analysis tools Overview: Descriptive statistics, Analysis of variance, Correlation and regression. • Operation research models using Excel Solver add-in. • Printing and sharing workbooks and worksheets, getting data in, spreading data out. Instructor: Ayman Hassan Microsoft Office Master Specialist Microsoft Certified Trainer Location: Orange Training Centers 11 Ahmed Wafiq st., next to Family Market, Roxy Square. Tel: 01012155065 - 01011121456 Please register via this link: https://docs.google/forms/d/1pIJW8ZczckNnG76a5AsAM0X45sgPpredBa4ojaHCTGQ/viewform
Posted on: Mon, 27 Jan 2014 08:25:10 +0000
Trending Topics
Recently Viewed Topics
© 2015