MS EXCEL
Training
Online
*Indicative price
Original amount in INR:
₹ 8,786
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
Uplatz is well known for providing instructor-led training and video-based courses on SAP, Oracle, Salesforce, AWS, Big Data, Machine Learning, Python, R, SQL, Google & Microsoft Technologies, and Digital Marketing.
SAP and AWS training courses are currently the most sought-after courses globally.
An SAP consultant on an average earns a package of $80,000 ($100,000) per annum based on the skills and experience.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- SAP
- MS Excel
- Ms Office
- Ms Word
- Excel Files
- Excel Formula
- Excel Sheet
- Excel for Accounting
- Analytics
- Arrays
- Text
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
*Indicative price
Original amount in INR:
₹ 8,786