Data Analysis with Tables and Pivot Tables in Microsoft Excel 2013

About Course

  • This free online Data Analysis in Excel course featuring the expert tutor from Simon Sez IT will teach you about the essentials of setting up Tables and PivotTables in Excel. You will learn how to create and name a table, remove duplicate rows, and insert rows and columns into tables. This course will also discuss the use of the Scenario Manager, Goal Seek, Solver Tool, when the use of these data analysis tools are most appropriate, and more!

What I will learn?

  • Creating Tables and Naming Tables.
  • Removing Duplicate Rows
  • Inserting Rows & Columns into Tables
  • Use of Table Styles, Reference and Selection
  • Principle of Pivot Table
  • Creating Pivot Table
  • Filtering Pivot Table
  • Data Analysis using pivot table
  • Use of Scenario manager
  • Use of goal seek
  • Use of Solver tool in Excel
Free
Start Free Course

Material Includes

  • Self-paced learning
  • Video tutorials
  • Unlimited access
  • Recognised certification

Course Detail

  • Hours : 4
  • Level : Beginner
  • Certification : Free

Platform : Edx

Instagram Facebook Whatsapp Twitter Youtube

Tags

Data Analysis Data Analysis For Excel Excel Data Analysis