Skip to content
Play overlay
Preview this course

Bundle Course - Data Analysis with Microsoft Excel and Google Sheets

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate


Uplatz

Summary

Price
£26 inc VAT
Study method
Online, On Demand What's this?
Duration
9.3 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
  • Uplatz Certificate of Completion - Free

1 student purchased this course

Add to basket or enquire

Overview

Uplatz offers this comprehensive bundle course on Data Analysis with MS Excel and Google Sheets consisting of a combo of video courses on all topics that are associated with Microsoft Excel and Google Sheets. You will be awarded Course Completion Certificate at the end of the course.

Uplatz provides this comprehensive bundle course on Data Analysis with Microsoft Excel and Google Sheets. It is a self-paced bundle course consisting of video lectures.

Data Analysis with MS Excel

The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. In this course, you will learn how to perform data analysis using Excel's most popular features.

Data Analysis with Google Sheets

Google Sheets is a free, web-based spreadsheet program offered by Google as part of its complete office suite called G Suite. Google Sheets provides collaborative, smart, secure spreadsheets for agile organizations. It is available on all devices and platforms, all you need is an internet connection and a web browser or the Sheets mobile app in case of mobiles. Since Sheets is an online spreadsheet software, you can share and collaborate with multiple people on the same document, tracking revisions, changes, and suggestions all in real time.

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Uplatz Certificate of Completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Curriculum

2
sections
38
lectures
9h 18m
total
    • 1: Introduction to Microsoft Excel 19:49
    • 2: Key in Data Preview 12:47
    • 3: Font and Alignment 13:52
    • 4: Cut Paste and Format Painter 07:21
    • 5: Control plus Keys 23:41
    • 6: Home Commands and Clipboard 20:09
    • 7: File Tab 12:50
    • 8: Sorting and Filtering 26:10
    • 9: Basic Formulas 23:01
    • 10: Text Formulas 32:49
    • 11: VLookup - part 1 26:40
    • 12: VLookup - part 2 06:21
    • 13: HLookup 14:22
    • 14: VLookup Function with Exact Match (False 10:27
    • 15: VLookup Function with Approximate Match (True) 05:02
    • 16: Pivot Tables - part 1 15:17
    • 17: Pivot Tables - part 2 07:14
    • 18: Pivot Tables - part 3 23:38
    • 19: Pivot Tables - part 4 11:47
    • 20: Charts - part 1 09:06
    • 21: Charts - part 2 21:01
    • 22: Column Charts 30:28
    • 23: Bar Charts 09:08
    • 24: Line Charts 09:58
    • 25: Introduction to Google Sheets 02:32
    • 26: Menu Options - File 08:41
    • 27: Menu Options - Edit 03:31
    • 28: Menu Options - View 04:49
    • 29: Menu Options - Insert 04:59
    • 30: Menu Options - Format 10:21
    • 31: Menu Options - Data and more 18:17
    • 32: Entering Data and Editing 07:12
    • 33: Functions - Numeric Function 15:24
    • 34: Functions - Text Function 30:38
    • 35: Functions - Date Functions 06:22
    • 36: Charts and Conditional Formatting 22:13
    • 37: Pivot Tables 23:21
    • 38: Saving - Sharing 06:22

Course media

Description

Data Analysis with MS Excel - Course Syllabus

  • Introduction to Microsoft Excel
  • Key in Data
  • Font and Alignment
  • Cut, Paste, Format Painter
  • Ctrl + Keys
  • Home Tab and Clipboard
  • File Tab
  • Sorting & Filtering
  • Formulas - General, Financial, Logical, Text, Date & Time, Statistical, Array, more
  • Dynamic Formulas
  • VLookup & HLookup
  • Pivot Tables
  • Charts & Graphs

Data Analysis with Google Sheets - Course Syllabus

  • Introduction
  • Menu Options - File
  • Menu Options - Edit
  • Menu Options - View
  • Menu Options - Insert
  • Menu Options - Format
  • Menu Options - Data and more
  • Entering Data and Filtering
  • Functions - Numeric Function
  • Functions - Text Function
  • Functions - Data Functions
  • Charts and Conditional Formatting
  • Pivot Tables
  • Saving, Sharing, Collaboration

Who is this course for?

Everyone

Requirements

Passion & determination to achieve your goals!

Career path

  • Data Analyst
  • Data Consultant
  • Financial Analyst
  • Marketing Analyst
  • Project Manager

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.