تفاصيل الدورة

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

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 
تحديث بتاريخ 08 November, 2015

نبذة عن معهد New Horizons Egypt

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.

عرض الجميع دورات New Horizons Egypt
Are you from New Horizons Egypt ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Office ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو