0.00 (0 Rating)

Spreadsheet: Microsoft Excel & Google Sheet (Beginner to Intermediate)

Wishlist Share
Share Course
Page Link
Share On Social Media
Course Info
Curriculum
Reviews

About Course

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

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…

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

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 with 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.

More Concepts and guides delivered in this course:

  • Understanding the environment of Microsoft Excel and Google Sheet
  • How to create, save, and open a workbook.
  • Data entry, cell formatting, working with multiple worksheets and
  • Discover how to format dates and numbers.
  • Discover the essentials of using formulas and functions.
  • How to rename, insert, move, and reference an Excel worksheet.
  • Discover how to create charts and graphs
  • Learn practical methods to sort and filter your data
  • Learn to visualize data with charts and SmartArt
  • Discover how to analyze data with a Pivot table and pivot chart
  • And more

What Will You Learn?

  • Spreadsheet 101-Understand the concepts of Spreadsheet software
  • How to create, organize, analyze, manipulate data with Microsoft Excel and Google sheet
  • How to use Autosum, Subtotal, 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 more

About the instructor

instructor avatar
Digital Mentor / Lifestyle Entrepreneur
Hi, my name is Emmanuel Onyewuchi aka ChuksEmma, Ex-computer Engr/ Instructor turned Digital Mentor, I'm the lead trainer/founder learnvale.com. With over a decade of experience in ICT cum 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 by building online businesses to create freedom for themselves and impacts in the world. I hope to achieve this by creating courses, trainings and programs on computer and digital optimization ideas and skills. You can learn more about me on my blog at digitaltopnotch,com, where I share my thoughts, knowledge, and skills on topics on digital skills, online business, Internet marketing and lifestyles.

Course Curriculum

Getting Started
Welcome to the spreadsheet mastery course

  • Getting Started
    00:12:58
  • What Is a Spreadsheet Software?
    00:4:57

Microsoft Excel Spreadsheet
In this section, you will learn how to create, manipulate, visualize and analyze data with Microsoft Excel.

  • Intro to Microsoft Excel
  • Overview Of Microsoft Excel
    00:9:43
  • Data entering and Organizing With Excel
    00:17:20
  • How to Modifying Rows, Column and Cell
    00:9:15
  • Text Formatting In Excel
    00:14:44
  • How Access An Existing And New Workbook
    00:17:20
  • Different Ways To Save Workbook In Excel
    00:13:21
  • Working With Multiple Worksheet
    00:15:51
  • How to Format Date and Numbers
    00:9:16
  • Formula in Spreadsheet: Applying Simple Formula In Excel
    00:9:27
  • Applying Complex Formula
    00:10:26
  • Relative And Absolute Cell Reference
    00:9:31
  • Autosum Function
    00:15:19
  • Working With The If Function
    00:17:18
  • Working With Image, SmartArt And Shapes
    00:12:7
  • Page Layout Setup And Printing Spreadsheet
    00:22:55
  • Sorting And Filtering Data In Excel
    00:8:5
  • Working With Chart
    00:17:9
  • Analyzing Data With Pivot Table And Pivot Chart
    00:9:16
  • Working With Subtotal Function
    00:13:29
  • How To Lock Formulas In Cells
    00:7:55
  • How To Password Protect Worksheet And Workbook
    00:6:14
  • Working With Template In Excel
    00:13:24
  • Intro To Macro- How To Create And Run Your First Macro In Excel
    00:14:11

Google Sheet
In this section, you will learn how to create, manipulate, visualize and analyze data with Google Sheet.

  • Intro to Google sheet
    00:6:12
  • How To Access Google Sheet Through Google Drive
    00:12:53
  • Overview Of Google Sheet
    00:7:52
  • Formatting Cells and Data In Google Sheet
    00:11:11
  • Working With Column, Rows And Cell In Google Sheet
    00:10:40
  • Working With Multiple Worksheet In Google Sheet
    00:5:15
  • Formula And Simple Formula In Google Sheet
    00:11:17
  • Working Complex Formula In Google Sheet
    00:12:47
  • Functions And Autosum Functions Google Sheet
    00:13:12
  • Sorting And Filtering In Google Sheet
    00:8:31
  • Conditional Formatting In Google Sheet
    00:8:36
  • Working With Chart In Google Sheet
    00:7:52
  • Working With Pivot Table In Google Sheet
    00:6:12
  • Google Sheet Miscellaneous
    00:13:00

Student Ratings & Reviews

No Review Yet
No Review Yet

Material Includes

  • 30 days money-back guarantee
  • 7.5 hours of on-demand video
  • Full lifetime access
  • Access to course at your convenient
  • Software for practical steps
  • Certificate of completion

Requirements

  • 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

Audience

  • 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
Open chat
Need help?
or scan the code
Hello!
Do you need help?
Contact our team on WhatsApp