
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
- 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
- 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
Curriculum
- 3 Sections
- 42 Lessons
- 10 Weeks
- Introduction2
- v Microsoft Excel Training26
- 2.1Intro to Microsoft Excel
- 2.2Overview Of Microsoft Excel
- 2.3Data entering and Organizing With Excel
- 2.4How to Modifying Rows, Column and Cell
- 2.5Text Formatting In Excel
- 2.6How To Access An Existing or New Workbook
- 2.7Different Ways To Save Workbook In Excel
- 2.8Working With Multiple Worksheet
- 2.9Number Formatting In Excel
- 2.10Formula in Spreadsheet And How to Applying Simple Formula
- 2.11Applying Complex Formula
- 2.12Relative And Absolute Cell Reference
- 2.13Working with Autosum Function
- 2.14Working With The If Function
- 2.15Working With Image, SmartArt And Shapes
- 2.16Conditional Formatting In Excel
- 2.17Page Layout Setup And Printing Spreadsheet
- 2.18Formatting Worksheet As A Table
- 2.19Sorting And Filtering Data In Excel
- 2.20Visualize Data With Chart
- 2.21Analyzing Data With Pivot Table And Pivot Chart
- 2.22Working With Subtotal Function
- 2.23How To Lock Formulas In Cells
- 2.24How To Password Protect Worksheet And Workbook
- 2.25Working With Template In Excel
- 2.26Intro To Macro- How To Create And Run Your First Macro In Excel
- Google Sheet Training14
- 3.1Intro to Google sheet
- 3.2Overview Of Google Drive
- 3.3Overview Of Google Sheet
- 3.4Basic Cells and Data Formatting
- 3.5Working With Column, Rows And Cell In Google Sheet
- 3.6Working With Multiple Worksheet In Google Sheet
- 3.7Formula In Spreadsheet & How To Apply Simple Formula In Google Sheet
- 3.8Working Complex Formula In Google Sheet
- 3.9Functions And Autosum Functions Google Sheet
- 3.10Sorting And Filtering In Google Sheet
- 3.11Conditional Formatting In Google Sheet
- 3.12Working With Chart In Google Sheet
- 3.13Working With Pivot Table In Google Sheet
- 3.14Google Sheet Miscellaneous