MS Excel Advanced Malayalam Tutorial

  • 3.2 rating
  • (3 Reviews)
  • 51 students enrolled

MS Excel Advanced Malayalam Tutorial

Advanced syllabus for Microsoft Excel

  • 3.2 rating
  • (3 Reviews)
  • 51 students enrolled
  • 999.00₹
  • 9999.00₹
  • Course Includes
  • 278 Minutes On-Demand Course
  • 9 Total Lessons
  • 49 Videos
  • Other study materials
  • Study progress
  • Full lifetime access
  • Access on mobile and web
  • Certificate of completion


Whatlearn

  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • Build Excel formulas to analyze dates, text fields, values and arrays
  • Create dynamic reports by mastering one of the most popular tools, Pivot Tables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

CourseContent

9 sections • 61 lectures • 04h 13m total length
IF Function
preview 03:10min
SUMIF Function
02:05min
Count If Function
02:05min
Nested IF Function
05:58min
IF with OR & AND
05:56min
IS Functions
05:09min
IF Function - Worksheet
0.00722mb
SUMIF & COUNTIF - Worksheet
0.00691mb
Nested IF Function - Worksheet
0.00777mb
SUMIFS Function
10:56min
COUNTIFS Function
02:19min
ABS Function
05:50min
SUMPRODUCT Function
02:53min
SQRT Function
00:57min
5 Ways to Add Zeros Before Numbers
04:13min
SUMIFS Function - Worksheet
0.0082mb
COUNTIFS Function - Worksheet
0.00793mb
VLOOKUP Function
04:07min
VLOOKUP Vs HLOOKUP function
15:05min
INDEX Function
06:05min
MATCH Function
05:36min
INDEX MATCH Function
11:51min
VLOOKUP Function - Worksheet
0.0585mb
VLOOKUP Vs HLOOKUP function - Worksheet
0.011mb
UPPER function
00:50min
LOWER function
00:07min
PROPER function
01:20min
LEFT Function
01:21min
RIGHT Function
00:39min
MID Function
01:06min
Trim Function
00:47min
LEN Function
00:58min
REPT Function
00:40min
CONCATENATE Function
01:27min
SUBSTITUTE Function
00:56min
CONCAT & TEXTJOIN Function
04:29min
SMALL & LARGE Function
04:37min
JUSTIFTY Function
02:07min
Unstack Data from one Column to Multiple Columns
03:25min
All text formulas - Worksheet
0.0137mb
Data Validation with whole number
03:01min
Data Validation with Text Length
01:22min
Data Validation with Date
01:36min
Data Validation with Drop down List (Short)
02:23min
Data Validation with Drop down List (Long)
08:34min
Prevent Duplicate Entries with Data Validation
02:07min
Data Validation
0.00742mb
Sub-Total Function in Excel
08:05min
The Magic of Filtering Data
07:42min
Use Sub-Total Filtered Data
02:36min
Data Consolidation Function
17:10min
Sub-Total Function - Worksheet
0.0116mb
Data Consolidation - Worksheet
0.0158mb
Pivot Table Introduction
09:36min
Pivot Table in PPT
12:05min
Automatic Pivot Table
26:37min
Advanced Pivot Table Tricks
15:14min
Pivot Table Tricks - Worksheet
0.0484mb
Major Excel Short Cuts - Part 1
16:00min
Major Excel Short Cuts - Part 2
09:44min
VBA Macro
12:59min

Requirements

  • Basic Knowledge of Excel , This course was created with Excel 2019. But all features will work in Excel 2010, 2013, 2016 and office 365.

Description

This course is exclusively built up and designed specifically for spreadsheet users who are already know the basic understand about the Excel and looking to take their skills to an advanced level. It easy to understand and show the exact steps to get the work done. You can find various Excel topics such as functions, formulas, Pivot tables, charting, conditional formatting, drop down lists, look-ups, subtotal etc..

Recent Courses

blog
  • September, 26th 2022
  • 0

Things to keep in mind while creating or updating a personal brand

  • 99.00₹
  • 3999.00₹
blog
  • September, 20th 2021
  • 4

This course will give you all the tools that you need to be a successful freelancer

  • 99.00₹
  • 3999.00₹
blog
  • August, 13th 2021
  • 0

How to get started, organized, increase efficiency, and maximize productivity while working in your home environment.

  • 79.00₹
  • 800.00₹
blog
  • September, 26th 2022
  • 5

Understand what influence really is and become an influence master

  • 89.00₹
  • 1999.00₹
blog
  • October, 13th 2021
  • 1

Tips for spending your time efficiently and becoming successful

  • 65.00₹
  • 1199.00₹

About Instructor

instructor
About Instructor

I am Mohameed Alfan. I have 13 years experience designing and delivering training courses. I have been working with Microsoft Excel since a really long time as a User, a Developer and a Trainer. 

Student Feedback

3.2
Course Rating
67%  
60%  
67%  

AM
04-10-2023
Anas Muhammed

Course is not accessible, "Source not found" appearing