Data Analysis In Excel

(Instant booking on GulfTalent)
Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$257 $37 only

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.

(Instant booking on GulfTalent)

Frequently asked questions

{{ item.question }}