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

Contact information not available.

Courses you can instantly connect with...
Microsoft Office Specialist Certification 2007 Helper Learning Excel 2007 - Level 1 New Horizons Egypt Excel 2007 - Level 2 New Horizons Egypt

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?