Google Sheets + MS Excel Course: Basic to Advance Level
Master Google Sheets & Excel - Learn Complex Data Analysis. Become an Expert: Learn Pivot Tables, QUERY & many more
Ratings 4.43 / 5.00
What You Will Learn!
- Good understanding of Google Sheets and Microsoft Excel at MIS level
- Expertise in Text, Logical and Math Function
- Expertise in Lookup and Reference Function
- Expertise in Date and Time Function
- Mastery in Pivot Table and Chart Preparation
- Mastery in 'What if Analysis' tools
- Data Validation, Filter and Conditional Formatting
- Managing data protection and data sharing in Excel
- Work with Macro Recording
- Working with Named Ranges and Link
- Working Knowledge of Financial Functions
- Creating amazing Google Forms
- Get to learn two most used Spreadsheet from basic to advance
Description
When its come to open source cloud based Spreadsheet solution Google sheet has no competition, however in the desktop based scenario MS Excel has the dominance. Even though both are have many similarities, the differences also need attention and required training. In this 14 hours of training with 127 lectures videos, you will be taken through the fundamentals of Excel and Google sheets till the Expertise level.
Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk or from your smartphone or tablet on the go Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.
In this course you will learn the fundamentals as advance topics of Google Sheets (much of which can be used in MS Excel as well). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like TEXT Function, LOGICAL Function, TEXT Function, LOOKUP Function and many more.
Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. Here you will trained from the very basic till the most advance level in the version 2010.
Who Should Attend!
- Seeking career in MIS and Data Management
