Beginner Level
Data Analysis with Tables and PivotTables in Microsoft Excel 2013
39,979Learners already enrolled
3-4 Avg Hours
CPD Accredited
Data Analysis with Tables and PivotTables in Microsoft Excel 2013
Learn all about tables and PivotTables and how to perform data analytical techniques with this free online Excel 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 ... 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!
COURSE PUBLISHER SimonSezITBusiness & technical software leaders
What You Will Learn In This Free Course
- Identify how to create a table, nam...
- Recognize how to insert rows and co...
- Discuss the use of table styles, re...
- Identify the basic principles of a ...
- Identify how to create a table, name a table and remove duplicate rows
- Recognize how to insert rows and columns into tables
- Discuss the use of table styles, reference and selection
- Identify the basic principles of a PivotTable
- Recognize how to create a PivotTable
- Recognize how to filter in PivotTables
- Identify how to perform data analysis using a PivotTable
- Discuss how to use the Scenario Manager
- Outline how to use Goal Seek
- Discuss how to use the Solver tool in Excel
![]()
Knowledge & Skills You Will Learn
Knowledge & Skills You Will Learn No internet? No problem! Download any course on the Alison App and learn on the go. đČ Download Courses & Learn Without Internet Coming soon to iOS
Complete This CPD Accredited Course & Get Your certificate!
![]()
Certify Your Skills
A CPD accredited Alison Diploma/Certificate certifies the skills youâve learned![]()
Stand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competition![]()
Advance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities
Learner Reviews & Feedback For Data Analysis with Tables and PivotTables in Microsoft Excel 2013
Learners should be able to skip questions while doing assessment
Great course!
Great Course
Murungi D. ![]()
Alison Graduate
Alison Graduate what a wonderful course, glad im to be part of it
This was so eye opening and nice to study
View 10 More Reviews
Back to course information
Want to create a customised learning path for your team?
Our dedicated Learning Advisors are here to help you curate a customised learning path tailored to your organisation's needs and goals.
Not sure where to begin?
Discover the career most suitable for you and get started in the field with a step-by-step plan.
Get your Plan
More Free Online Courses by This Publisher
Learners Who Took This Course Also Enrolled In
- Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
- Mastering Data Analysis Using Microsoft Excel
- Microsoft Excel Formulas and Functions
- Basics of Data Analysis with Excel
- Introduction to Data Analysis
- Data Entry Tools and Techniques
- Fundamental Data Analysis using Power BI
- Microsoft Excel 2013 - Advanced: Master Spreadsheets
