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

Builds upon the foundational Microsoft Office Excel knowledge & skills you’ve already acquired & sets you on the road to creating advanced worksheets that will deepen your firm’s business intelligence

Course Content: 

Outline

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

Learning Outcomes: 

  • Students will be able to: Use advanced formulas. etc.
  • Organize worksheet & table data using various techniques.
  • Create and modify charts.
  • Analyze data using PivotTables, Slicers, & PivotCharts.
  • Insert and modify graphic objects in a worksheet. Customize and enhance workbooks.
تحديث بتاريخ 08 November, 2015

نبذة عن معهد Rural Food Skillnet

Skillnets actively supports and works with businesses in Ireland to address their current and future skills needs.

they believe that training and up-skilling are key elements in keeping Irish companies competitive.

they fund groups of companies in the same region/sector, and with similar training needs, through training networks that deliver subsidised training to Irish businesses. 

Employer needs are addressed through both the preservation and growth of jobs, focusing on skills to maintain businesses and protect jobs as theyll as the enhancement of new skills to create new jobs.

The needs of unemployed people are addressed through activation and conversion by focusing on integrated training with employees and dedicated conversion ctheirses and work placement in areas of employment potential.

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

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

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

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

أو