Tutorialspoint

Spreadsheet From Beginner to Intermediate With Microsoft Excel & Google Sheet

person icon Emmanuel Onyewuchi

Spreadsheet From Beginner to Intermediate With Microsoft Excel & Google Sheet

Learn how to create, manipulate, visualize and analyze data with Microsoft Excel & Google Sheet

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Emmanuel Onyewuchi

architecture icon Microsoft Office,Office Productivity,Google Sheets

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

Do you want to master the Ins and Out of top 2 spreadsheet software in use today, Microsoft Excel and Google Sheet?

Spreadsheet is one of the top office productive tools used in the business world today, it's also one of the top in-demand skills for jobs, professional or career excellence.

This course is designed to take you from a beginner to an intermediate level when it comes to spreadsheet software.

You will learn the environment of the top 2 spreadsheet software that is often used in the workspace today, with insights and skills on these top 2 spreadsheet software you will be able to deal with every other spreadsheet tool that comes your way.

This course is divided into 2 major modules:

1. Microsoft Excel Spreadsheet

In this module, you will learn how to organize, manipulate and analyze data with Microsoft Excel. The lectures in the Microsoft excel module are created with Microsoft Excel 2013 version, but any version of Microsoft office from 2010 to the latest version will be able to follow through this course.

2. Google Sheet

In this Module, you will learn how to organize, manipulate and analyze data with Google Sheet.

This course is perfect for:

  • Graduate and undergraduate who wants to learn Spreadsheet skills and increase employment opportunity in a computer age
  • Professionals who want to learn how to work with spreadsheet software
  • Business owners or entrepreneurs who want to learn data analysis with a spreadsheet software
  • Anyone that wants to learn spreadsheet skills

Goals

What will you learn in this course:

  • Spreadsheet 101-Understand the concepts of Spreadsheet software
  • How to create, organize, analyze, and manipulate data with Microsoft Excel and Google sheet
  • How to use Autosum, Subtotal, and IF functions to perform simple and complex calculations
  • How to sort and filter data with Microsoft Excel and Google sheet
  • How to use chart and pivot table to analyze data
  • How to automate repetitive task with Macro
  • And lotsmore

Prerequisites

What are the prerequisites for this course?

  • Basic Computer operation skills
  • A desktop computer or laptop to practice what you will be learning
  • Determination and commitment to learning new skills
  • Ability to follow instructions and guide
Spreadsheet From Beginner to Intermediate With Microsoft Excel & Google Sheet

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
2 Lectures
  • play icon Getting Started 12:58 12:58
  • play icon What Is a Spreadsheet Software? 04:57 04:57
Microsoft Excel Training
26 Lectures
Tutorialspoint
Google Sheet Training
14 Lectures
Tutorialspoint

Instructor Details

Emmanuel Onyewuchi

Emmanuel Onyewuchi

Digital Mentor & Lifestyle Entrepreneur

Hi, my name is Emmanuel Onyewuchi aka ChuksEmma, an Ex-computer Engr/ Instructor turned Digital Mentor.

With over 10 years of experience in ICT plus 3 years of experience in Internet marketing, be rest assured that you are dealing with an Individual with in-depth experience and knowledge in computer and digital-related skills

I'm on a mission to help 100,000 Knowledge givers ( coaches, trainers, teachers, professionals) optimize their knowledge through the online world to build a business that enables freedom for themselves and impacts for the world.

I hope to achieve this by creating courses, trainings and programs on computer and digital optimization ideas and skills

I'm also the founder of learnvale,com.

Learnvale is the new school online for the next breed of Digital Optimizers, a community of professionals, Knowledge givers and individuals who have decided to make the most of digital tools and resources around them to grow and thrive.

You can learn more about me on my blog at digitaltopnotch,com, where I share my ideas, knowledge, and skills on topics on Lifestyle, digital skills, online business and Internet marketing

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us

1800-202-0515