Bundle Course - Data Analysis with Microsoft Excel and Google Sheets

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.

Reed courses certificate of completion

Digital certificate - Included

Uplatz Certificate of Completion

Digital certificate - Included

• Microsoft Excel - all lectures 6:32:58

  • 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

• Google Sheets - all lectures 2:44:42

  • 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

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

Everyone

Passion & determination to achieve your goals!

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

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