MS EXCEL AND GOOGLE SHEETS
Training
Online
*Indicative price
Original amount in INR:
₹ 2,197
Description
-
Type
Training
-
Level
Intermediate
-
Methodology
Online
-
Duration
1 Month
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
This course covers advanced options, features, formulas, graphs, computations in MS Excel and Google Sheets with a fair introduction to VBA programming.
Facilities
Location
Start date
Start date
About this course
Anyone can do this course. Absolutely no prerequisites! (Just the enthusiasm and zeal required)
Reviews
Subjects
- Excel
- MS Excel
- Ms Office
- Excel Files
- Excel Formula
- Excel Sheet
- Excel for Accounting
- Ms PowerPoint
- Weather
- Text
- Analytics
- Lookup
Course programme
- Easily build dynamic tools & Excel dashboards to filter, display and analyse your data
- Design your own formula-based formatting rules
- Join datasets from multiple sources in seconds with lookup, index & match functions
- Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)
- Manipulate dates, time, text, and arrays
- Automate tedious and time-consuming analytics tasks using cell formulas and functions in Excel
- Lookup/Reference functions
- Statistical functions
- Formula based formatting
- Date & Time functions
- Logical operators
- Array formulas
- Text functions
- Powerful analytics tools and formulas like INDIRECT, HYPERLINK, WEBSERVICE & FILTERXML
- Filtering & Sorting
- Conditional Formatting
- Pivot
- Charts and Graphs
- VBA (Visual Basic for Applications) basics – let’s get started
- Excel Shortcuts – for everyday use. Make yourself super-efficient and fast
- Tips & Tricks
- Commonly used formatting techniques, fonts, designs, and best practices
- Handling huge data sets
- Introduction to G Suite and Google Sheets
- Difference between Google Sheets and MS Excel
- Best practices and commonly used functions in Google Sheets
MS EXCEL AND GOOGLE SHEETS
*Indicative price
Original amount in INR:
₹ 2,197