Data Analysis In Excel - Course Gate

12/20/2018

Data Analysis In Excel - Course Gate

LOGIN

HOME / COURSE / MICROSOFT OFFICE / EXCEL / VIDEO COURSE / DATA ANALYSIS IN EXCEL

Data Analysis In Excel ( 1 REVIEWS ) 580 STUDENTS 

HOME

CURRICULUM

REVIEWS

Description: 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

https://coursegate.co.uk/course/data-analysis-in-excel/

1/13

12/20/2018

Data Analysis In Excel - Course Gate

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 di erent features to visualise or analyse your data in the most convenient way, which allows you take the right business decisions for your company.

Who is this Course for?

Data Analysis In Excel is perfect for anyone trying to learn potential professional skills.

As there is no experience and quali cation required for this course, it is available for all students from any academic background.

Requirements Our Data Analysis In Excel is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful.

You will be able to add our quali cation to your CV/resume which will help you to stand out in the competitive job industry.

Modifying a Worksheet



Working with Lists



Analyzing Data



Visualizing Data with Charts



Using PivotTables and PivotCharts



Working with Multiple Worksheets and Workbooks



Using Lookup Functions and Formula Auditing



Automating Workbook Functionality



https://coursegate.co.uk/course/data-analysis-in-excel/

2/13

12/20/2018

Data Analysis In Excel - Course Gate

Creating Sparklines and Mapping Data



Forecasting Data



5   1 ratings

5 STARS

0

4 STARS

0

3 STARS

0

2 STARS

0

1 STARS

0

NO REVIEWS FOUND FOR THIS COURSE.

OTHER STUDENTS ALSO BOUGHT

https://coursegate.co.uk/course/data-analysis-in-excel/

3/13

12/20/2018

Data Analysis In Excel - Course Gate

Advanced Microsoft Data Analysis

£489.00  

https://coursegate.co.uk/course/data-analysis-in-excel/

525

4/13

12/20/2018

Data Analysis In Excel - Course Gate

Microsoft Office 2007 PowerPoint Advanced

FREE  

https://coursegate.co.uk/course/data-analysis-in-excel/

783

5/13

12/20/2018

Data Analysis In Excel - Course Gate

MS Azure - Deploying Websites

£489.00  

https://coursegate.co.uk/course/data-analysis-in-excel/

453

6/13

12/20/2018

Data Analysis In Excel - Course Gate

Microsoft Azure Automation and Log Anayltics

£489.00  

https://coursegate.co.uk/course/data-analysis-in-excel/

533

7/13

12/20/2018

Data Analysis In Excel - Course Gate

Become a Motivational Speaker

£489.00  

https://coursegate.co.uk/course/data-analysis-in-excel/

428

8/13

12/20/2018

Data Analysis In Excel - Course Gate

Microsoft Office 2007 Excel Beginners

FREE 496

 

TAKE THIS COURSE

£199.00

1 YEAR INTERMEDIATE COURSE BADGE COURSE CERTIFICATE NUMBER OF UNITS https://coursegate.co.uk/course/data-analysis-in-excel/

    32 9/13

12/20/2018

Data Analysis In Excel - Course Gate

0

NUMBER OF QUIZZES



4 HOURS, 58 MINUTES

Gift thi s course









580 STUDENTS ENROLLED

VIDEO COURSES Adult Psychology Course

  ( 7 REVIEWS )

371 STUDENTS

Advanced Diploma in Psychology Level 4

  ( 8 REVIEWS )

698 STUDENTS

https://coursegate.co.uk/course/data-analysis-in-excel/

10/13

12/20/2018

Data Analysis In Excel - Course Gate

An Introduction to PCs Using Windows 8

  ( 7 REVIEWS )

552 STUDENTS

An Introduction to Windows Vista for End Users

  ( 8 REVIEWS )

442 STUDENTS

Animation Designing Certi cate Course

  ( 7 REVIEWS )

501 STUDENTS

BEST RATED COURSE Professional Presenter Training

  ( 9 REVIEWS )

688 STUDENTS

Business Administration and Management

 

https://coursegate.co.uk/course/data-analysis-in-excel/

11/13

12/20/2018

Data Analysis In Excel - Course Gate

( 8 REVIEWS )

538 STUDENTS

Complete WordPress Web Design Diploma

  ( 8 REVIEWS )

627 STUDENTS

VIDEO COURSES Adult Psychology Course

BY ADMIN

Advanced Diploma in Psychology Level 4

BY ANDREW JONES

An Introduction to PCs Using Windows 8

BY NEAL SMITH

An Introduction to Windows Vista for End Users

BY COURSE GATE

https://coursegate.co.uk/course/data-analysis-in-excel/

12/13

12/20/2018

Data Analysis In Excel - Course Gate

Animation Designing Certi cate Course

BY CAMERON DALLPORT

CERTIFICATE CODE

Enter Certi cate Code

VALID ATE

IMPORTANT LINKS

About Blog Terms & Conditions Privacy Policy Contact

© COURSE GATE EDUKITE LTD, REG NO: 11378092

https://coursegate.co.uk/course/data-analysis-in-excel/

13/13