• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
No Classes Available in this Courses.

91015: Microsoft Office Excel 2013: Part 2 Course 

Regardless of whether you have to do the math for deals, stock, IT, HR, or another specialty unit, the capacity to get the correct data to the ideal individuals at the ideal time can make an intense upper hand in an intricate market condition. This course expands upon the foundational Microsoft® Office Excel® 2013 information and aptitudes you've officially gained and sets you making progress toward making propelled exercise manuals and worksheets that will extend your association's business knowledge. You'll take in a ton of things about Excel 2013, including how to make propelled recipes and arrange your information into tables. You'll find the energy of PivotTables and PivotCharts and how slicers can make information sifting as simple as clicking a couple of catches. At its heart, this course is around one straightforward thought: asking your information inquiries and utilizing Excel 2013 to discover the appropriate responses. 

91015: Microsoft Office Excel 2013: Part 2 Audience Profile 

91015: Microsoft Office Excel 2013: Part 2 course is intended for people who as of now have foundational learning and aptitudes in Excel 2013 and are prepared to propel their information investigation aptitudes and capacities through the utilization of cutting edge Excel 2013 usefulness, for example, propelled recipe creation, tables, outlines, PivotTables and PivotCharts. 

91015: Microsoft Office Excel 2013: Part 2 At Course Completion 

In 91015: Microsoft Office Excel 2013: Part 2 course, you will: 

  • Make propelled equations. 
  • Investigate information with sensible and query capacities. 
  • Sort out worksheet information with tables. 
  • Picture information by utilizing graphs. 
  • Breaking down information with PivotTables, slicers, and PivotCharts. 
  • Embed realistic items. 
  • Improve exercise manuals.

91015: Microsoft Office Excel 2013: Part 2 Course Outline

Lesson 1: Creating Advanced Formulas 

  • Point A: Apply Range Names 
  • Point B: Use Specialized Functions 

Lesson 2: Analyzing Data with Logical and Lookup Functions 

  • Point A: Leverage Questions and Testing to Write Formulas 
  • Theme B: Use Logical and Lookup Functions to Find Answers to Questions 

Lesson 3: Organizing Worksheet Data with Tables 

  • Theme A: Create and Modify Tables 
  • Theme B: Sort and Filter Data 
  • Theme C: Use Summary and Database Functions to Calculate Data 

Lesson 4: Visualizing Data with Charts 

  • Theme A: Create Charts 
  • Theme B: Modify and Format Charts 
  • Theme C: Create a Trendline 
  • Theme D: Create Advanced Charts 

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts 

  • Theme A: Create a PivotTable 
  • Theme B: Filter Data by Using Slicers 
  • Theme C: Analyze Data by Using PivotCharts 

Lesson 6: Inserting Graphics 

  • Theme A: Insert and Modify Graphic Objects 
  • Theme B: Layer and Group Graphic Objects 
  • Theme C: Incorporate SmartArt 

Lesson 7: Enhancing Workbooks 

  • Theme A: Customize Workbooks 
  • Point B: Manage Themes 
  • Theme C: Create and Use Templates 
  • Theme D: Protect Files