Data Analysis with Microsoft Excel & Google Sheets
Data Analysis with Microsoft Excel & Google Sheets, available at $54.99, has an average rating of 3.6, with 36 lectures, 2 quizzes, based on 77 reviews, and has 6659 subscribers.
You will learn about End-to-end knowledge of both MS Excel and Google Sheets Understand which spreadsheet software to use and where Master Microsoft Excel and Google Sheets from basic to expert level Become a top-notch analyst or consultant Understand the difference between MS Excel and Google Sheets Unique capabilities of both software and leverage the best of each Menu, Ribbons & Options, Different Tabs Formatting including Conditional Formatting Fonts and Alignments Sorting & Filtering Formulas and Functions VLookup, HLookup, Pivot Tables Charts & Graphs Sharing, Security, Working simultaneously on same spreadsheet Prepare for Data/Business Analyst jobs with complete mastery and command over both Microsoft Excel and Google Sheets This course is ideal for individuals who are Data Analysts or Consultants and Managers or Marketing & Financial Analysts or Anyone wishing to make a career as Analyst/Consultant or Newbies and University/College Students or Business Analysts or Data Scientists or Administrators and Data Entry Specialists or Sales Analysts & Consultants or Data Governance and Master Data Analysts or IT Consultants or Support Engineers or IT Developers & Software Engineers or Test Analysts or Project Managers and Coordinators It is particularly useful for Data Analysts or Consultants and Managers or Marketing & Financial Analysts or Anyone wishing to make a career as Analyst/Consultant or Newbies and University/College Students or Business Analysts or Data Scientists or Administrators and Data Entry Specialists or Sales Analysts & Consultants or Data Governance and Master Data Analysts or IT Consultants or Support Engineers or IT Developers & Software Engineers or Test Analysts or Project Managers and Coordinators.
Enroll now: Data Analysis with Microsoft Excel & Google Sheets
Summary
Title: Data Analysis with Microsoft Excel & Google Sheets
Price: $54.99
Average Rating: 3.6
Number of Lectures: 36
Number of Quizzes: 2
Number of Published Lectures: 36
Number of Published Quizzes: 2
Number of Curriculum Items: 38
Number of Published Curriculum Objects: 38
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- End-to-end knowledge of both MS Excel and Google Sheets
- Understand which spreadsheet software to use and where
- Master Microsoft Excel and Google Sheets from basic to expert level
- Become a top-notch analyst or consultant
- Understand the difference between MS Excel and Google Sheets
- Unique capabilities of both software and leverage the best of each
- Menu, Ribbons & Options, Different Tabs
- Formatting including Conditional Formatting
- Fonts and Alignments
- Sorting & Filtering
- Formulas and Functions
- VLookup, HLookup, Pivot Tables
- Charts & Graphs
- Sharing, Security, Working simultaneously on same spreadsheet
- Prepare for Data/Business Analyst jobs with complete mastery and command over both Microsoft Excel and Google Sheets
Who Should Attend
- Data Analysts
- Consultants and Managers
- Marketing & Financial Analysts
- Anyone wishing to make a career as Analyst/Consultant
- Newbies and University/College Students
- Business Analysts
- Data Scientists
- Administrators and Data Entry Specialists
- Sales Analysts & Consultants
- Data Governance and Master Data Analysts
- IT Consultants
- Support Engineers
- IT Developers & Software Engineers
- Test Analysts
- Project Managers and Coordinators
Target Audiences
- Data Analysts
- Consultants and Managers
- Marketing & Financial Analysts
- Anyone wishing to make a career as Analyst/Consultant
- Newbies and University/College Students
- Business Analysts
- Data Scientists
- Administrators and Data Entry Specialists
- Sales Analysts & Consultants
- Data Governance and Master Data Analysts
- IT Consultants
- Support Engineers
- IT Developers & Software Engineers
- Test Analysts
- Project Managers and Coordinators
A warm welcome to the Data Analysis with Microsoft Excel & Google Sheetscourse by Uplatz.
Microsoft Excel is one of the most popular tools used in today’s fast paced business environment. It is used in almost every job role, across a huge range of industries including manufacturing, finance, logistics, hospitality, healthcare and engineering. It enables you to work with numbers in rows and columns, perform calculations, analyze data and produce superb charts.
Google Sheets is a free online spreadsheet program provided by Google and is part of their G Suite software applications. All you need to access the power of Google sheets is a google account and a browser. Learn how to quickly create a google spreadsheet, store numbers and information, format and design a report and also collaborate with others in real time.
Uplatz provides this bundled course including Microsoft Excel training and Google Sheets training, the two most powerful and popular spreadsheet programs. The unique feature of this course is to help you get trained on both MS Excel and Google Sheets so that you will be able to leverage the best features of each and conduct data analysis in the best possible manner. This MS Excel and Google Sheets bundled training will equip you with the knowledge required to become a successful analyst/consultant in any domain.
From creating spreadsheets and writing reports to business intelligence analysis, this training will help you to process, analyse and share business critical information.
The primary objectives of this training include providing you skills to –
-
Organize and manipulate your Excel data quickly and easily
-
Work more efficiently by utilizing the many tools and functions available in Excel
-
Be more confident so that you can take on more responsibility in your job role
-
Gain a comprehensive knowledge of how to create a Google Sheet and fill it with data
-
Build formulas, dynamic functions, vlookup, hlookup, pivot tables, charts & graphs
-
Harness the power of functions such as Google Translate in Google Sheets
This bundled training by Uplatz will help you apply for jobs that require strong analytical and data crunching skills by mastering Microsoft Excel and Google Sheets.
Microsoft Excel course curriculum
-
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
Google Sheets course curriculum
-
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
Course Curriculum
Chapter 1: Introduction to Microsoft Excel
Lecture 1: Introduction to Microsoft Excel
Chapter 2: Key in Data
Lecture 1: Key in Data
Chapter 3: Font and Alignment
Lecture 1: Font and Alignment
Chapter 4: Cut, Paste, Format Painter
Lecture 1: Cut, Paste, Format Painter
Chapter 5: Ctrl + Keys
Lecture 1: Ctrl + Keys
Chapter 6: Home Tab and Clipboard
Lecture 1: Home Tab and Clipboard
Chapter 7: File Tab
Lecture 1: File Tab
Chapter 8: Sorting and Filtering
Lecture 1: Sorting and Filtering
Chapter 9: Formulas
Lecture 1: Basic Formulas
Lecture 2: Text Formulas
Chapter 10: VLOOKUP and HLOOKUP
Lecture 1: VLookup – part 1
Lecture 2: VLookup – part 2
Lecture 3: HLookup
Chapter 11: Pivot Tables
Lecture 1: PivotTable – part 1
Lecture 2: PivotTable – part 2
Lecture 3: PivotTable – part 3
Lecture 4: PivotTable – part 4
Chapter 12: Charts
Lecture 1: Charts – part 1
Lecture 2: Charts – part 2
Lecture 3: Column Charts
Lecture 4: Bar Charts
Lecture 5: Line Charts
Chapter 13: Introduction to Google Sheets
Lecture 1: Introduction to Google Sheets
Chapter 14: Menu Options
Lecture 1: Menu Options – File
Lecture 2: Menu Options – Edit
Lecture 3: Menu Options – View
Lecture 4: Menu Options – Insert
Lecture 5: Menu Options – Format
Lecture 6: Menu Options – Data & more
Chapter 15: Entering Data and Editing
Lecture 1: Entering Data and Editing
Chapter 16: Functions
Lecture 1: Functions – Numeric Function
Lecture 2: Functions – Text Function
Lecture 3: Functions – Date Functions
Chapter 17: Charts and Conditional Formatting
Lecture 1: Charts and Conditional Formatting
Chapter 18: Pivot Tables
Lecture 1: Pivot Tables
Chapter 19: Saving, Sharing, Collaboration
Lecture 1: Saving, Sharing, Collaboration
Chapter 20: End of Course Quiz – Excel
Chapter 21: End of Course Quiz – Google Sheets
Instructors
-
Uplatz Training
Fastest growing global Technology & Cloud Training Provider
Rating Distribution
- 1 stars: 3 votes
- 2 stars: 7 votes
- 3 stars: 20 votes
- 4 stars: 22 votes
- 5 stars: 25 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024