By Course Gate
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
Course Overview
This Data Analysis In Excel aims to introduce Data Analysis in Excel 2016. You'll learn how to best enter and organize data, sort and map data, perform calculations with simple functions, format the appearance of your data and cells, and build charts and PivotTables for data analysis. You will know how to validate data, search and remove invalid data. The course covers Lookup information using VLOOKUP, and INDEX-MATCH, data forecasting and cleansing, providing external and 3D references and inserting sparklings, so that you have a great foundation in the world's most popular spreadsheet program.
Finally, you will learn different features to visualise or analyse your data in the most convenient way, which allows you take the right business decisions for your company.
Who should take this course
Data Analysis In Excel is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background.
Accreditation
CPD
Course content
Modifying a Worksheet:
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
Working with Lists:
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Analyzing Data:
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
Visualizing Data with Charts:
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
Using PivotTables and PivotCharts:
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks:
- Use Links and External References
- Use 3-D References
- Consolidate Data
- Using Lookup Functions and Formula Auditing
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
- Automating Workbook Functionality
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Creating Sparklines and Mapping Data:
- Create Sparklines
- MapData
- Forecasting Data
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
About Course Provider
What’s the most important thing we could possibly have on our mind? The answer to that is easy: your learning needs. Years ago, we thought about what and how people wish to learn. Since then, we have worked tirelessly to create a platform on which we offer a range of detailed, excellent quality, and competitively priced online courses available to all people irrespective of their geographical location, skills and experience, and learning level and ability. Coursegate is now synonymous with all of this.
How to enroll?
You can book the course instantly by paying on GulfTalent.