Students will build upon the foundational Microsoft® Office Excel® knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.
Lesson 1: Customizing the Excel Environment
- Configure Excel Options
- Customize the Ribbon and the Quick Access Toolbar
- Enable Excel Add-Ins
Lesson 2: Creating Advanced Formulas
- Use Range Names in Formulas
- Use Specialized Functions
- Use Array Formulas
Lesson 3: Analyzing Data with Functions and Conditional Formatting
- Analyze Data by Using Text and Logical Functions
- Apply Advanced Conditional Formatting
Lesson 4: Organizing and Analyzing Datasets and Tables
- Create and Modify Tables
- Sort Data
- Filter Data
- Use SUBTOTAL and Database Functions
Lesson 5: Visualizing Data with Basic Charts
- Create Charts
- Modify and Format Charts
Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Slicers
Founded and headquartered in Anaheim, California, New Horizons Learning Centers was named the world's largest independent training company by IDC.
The Company is both an operator and franchisor of training centers that offer a broad range of Technical Training, Desktop Application, Business Skills and English Language courses for all levels of users in multiple delivery methods and formats.
New Horizons provides approximately three million student days of instruction annually with location around the globe.
New Horizons sets the pace of innovative training programs that meet the changing needs of the industry. With 2400 qualified instructors in over 2100 classrooms at 300 centers in 60 counters around the world.
New Horizons offers more courses, at more times, in more delivery methods than any other training company.See all New Horizons Egypt courses