Excel 2013 Intermediate Malayalam Tutorial

  • 5 rating
  • (1 Reviews)
  • 9 students enrolled

Excel 2013 Intermediate Malayalam Tutorial

Master Intermediate Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2013)

  • 5 rating
  • (1 Reviews)
  • 9 students enrolled
  • 499.00₹
  • 2000.00₹
  • Course Includes
  • 181 Minutes On - Demand Video
  • 14 Lessons
  • 14 Video Lessons
  • Study Progress
  • Full Life Time Access
  • Access on Mobile and Web
  • Certificate of Completion


Whatlearn

  • • Copying formulas. • Absolute and relative reference. • 3dformulas. • Auto-sum. • Displaying formulas. • Debugging...
  • • Vlookup & Hlookup. • Vlookup Exact Match. • Nesting of Vlookup. • Vlookup large table. • Match function. • Choose...
  • • If function. • Nesting of if functions. • Compound if.
  • • Date arithmetic. • Today. • Weekday functions.
  • • Cell. • Istext. • Isformula. • Iserror.
  • • Aggregate. • Convert. • Mod. • Round functions. • Trunc and int.
  • • Countif and Sumif. • Countifs. • Median and Mode. • Writing Flies and Folders.
  • • Count and Counta. • Count Blank. • Large and small. • Rank.
  • • Frequency.
  • • Concatenate. • Find and Search. • Replace and Substitute. • Proper. • Left and Right. • Text and Rept.
  • • What is macros • Create a Macro. • Assign a macro to Quick Access Tool Bar. • Assign a macro already created to an...
  • • Using do loop in macros
  • • How to use Do untill loop in macros • Use of for loop in macros • When one for loop comes in another at macros
  • • Use for loop to create conditional formatting • Describes what is absolute and relative reference • How to save a ma...

CourseContent

14 sections • 14 lectures • 02h 54m total length
Arithmetic Operators

Get to know the different Arithmetic Operators in Execl

preview 28:53min
Functions

Learn the different Lookup Functions in excel like HLookup and VLookup Functions

21:05min
More Functions

Learn more important Functions in excel like If and Related functions 

17:31min
More Functions

Get to know more functions in Excel like Date and Time Functions 

8:36min
More Functions

Get to know more Functions in excel like Information functions

9: 54min
More Functions

Get to know the Math Functions in Excel.

15:42min
More functions

Get to know the Power Functions in Excel

8:26min
More Functions

Get to know the Statistical functions in Excel

4 : 42min
More Functions

Get to know the different Array Functions in Excel

1 : 11min
More Functions

Get to know the different Array Functions in Excel

14 : 49min
Macros in Excel

Learn to create Macros in Excel

11 : 10min
Statements and Loops in Macros

Learn the different Statements and loops in macros using Excel.

15 : 38min
For Loops

Learn the different loops in Excel

preview 12min
More Loops

Learn the different Loops in macros using Excel.

11 : 33min

Requirements

  • Microsoft Excel Software

Description

Intermediate Excel is a comprehensive tutorial that provides a good insight into the latest features available in Microsoft Excel 2013. It has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner. This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.

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

hi

Student Feedback

5
Course Rating
100%  
100%  
100%