Go Back   2020-2021 StudyChaCha > StudyChaCha Discussion Forum > General Topics

Old September 20th, 2013, 04:55 PM
Super Moderator
Join Date: Apr 2013
Default Re: Free Advanced Excel Courses

There are so many sites on the net which provided free advanced Excel Courses ,Here I am providing you with the detail of the Free Advanced Excel Courses

SECTION 1: Getting Started

Lecture 1:
Working Files

Lecture 2:
How Advanced Does The Advanced Get?

Lecture 3:
Using the Files Included

Lecture 4:
How to obtain your Certificate

Lecture 5:
New In 2010 - The Sparkline

SECTION 2: The IF Function

Lecture 6:
The Syntax Of IF

Lecture 7:
Nesting The IF Statement

Lecture 8:
Use The AND Operator

Lecture 9:
Use The OR Operator To Reduce

Lecture 10:
The NOT Operator Within

Lecture 11:
SUMIF For Selective Adding Up

Lecture 12:
COUNTIF For Selective Counting

Lecture 13:
AVERAGEIF For The Mean Of Cells

Lecture 14:
Multiple Criteria Within The Same

SECTION 3: Performing Lookup

Lecture 15:
VLOOKUP Explained

Lecture 16:
Applied Examples for VLOOKUP

Lecture 17:
HLOOKUP Explained

Lecture 18:

Lecture 19:
Looking For A Near Match In A Lookup

Lecture 20:
Checking For Missing Data In A Lookup

Lecture 21:
Extending The Size Of A Lookup Table

Lecture 22:
Nested LOOKUPs

SECTION 4: Data Functions

Lecture 23:
The MATCH Function Explained

Lecture 24:
The INDEX Function Syntax

Lecture 25:
How To Stop Nonexistent Row

Lecture 26:
The CHOOSE Lookup Function

SECTION 5: Math Functions

Lecture 27:
Working With TIME In Excel

Lecture 28:
Rounding To Fractional Values

Lecture 29:
MOD For Working Out Remainders

Lecture 30:
Generating A Random Number

Lecture 31:
Pick A List Item At Random

Lecture 32:
Calculating Loan Repayments Using

Lecture 33:
Investment Calculations Using

Lecture 34:
Working Out Depreciation

Lecture 35:
Working Out Different Parts

SECTION 6: Arrays

Lecture 36:
What Is An Array And An Array

Lecture 37:
Creating And Using An Array Formula

Lecture 38:
Conditional Evaluation

Lecture 39:
The Very Clever TRANSPOSE Array

SECTION 7: Functions For Working With Text

Lecture 40:
LEN And TRIM Two Very Useful Text

Lecture 41:
Using LEFT And RIGHT For String

Lecture 42:
FIND And MID Working Together

Lecture 43:
Build Strings From Multiple Cells

Lecture 44:
Changing The Case Of Text In Cells

Lecture 45:

Lecture 46:
Formatting Numeric Values With A Text

Lecture 47:
Extracting The Values From The...

SECTION 8: Other Useful Functions

Lecture 48:
Welcome To IS Functions

Lecture 49:
Error Checking With ISERR ISERROR

Lecture 50:
The OFFSET Formula Explained

Lecture 51:
Dynamic Named Ranges Using

Lecture 52:
Use The INDIRECT Function To Build

Lecture 53:
Dealing With INDIRECT Errors

Lecture 54:
Use Formulas To Determine An Excel

SECTION 9: Sparklines

Lecture 55:
Creating A Sparkline

Lecture 56:
Change The Design Of Sparklines

Lecture 57:
Dealing with Empty Cells

Lecture 58:
Comparing One Sparkline

Lecture 59:
Removing Sparklines From A Sheet

SECTION 10: Outlining

Lecture 60:
Outlining Explained

Lecture 61:
Creating An Outline Automatically

Lecture 62:
Creating An Outline Manually

Lecture 63:
Manually Removing Data

Lecture 64:
Removing The Outlining

Lecture 65:
Adjusting A Grouping Created

SECTION 11: Custom Views

Lecture 66:
Creating A Custom View Of A Worksheet

Lecture 67:
Changing From One Custom

Lecture 68:
Editing A Custom View

Lecture 69:
How To Delete A Custom View
Reply With Quote
Old January 2nd, 2015, 12:16 PM
Default Re: Free Advanced Excel Courses

Kerala University Of Health And Allied Sciences Website
Reply With Quote
Old January 2nd, 2015, 12:20 PM
Super Moderator
Join Date: Apr 2013
Default Re: Free Advanced Excel Courses

Kerala University of Health Sciences is a medical university in the city of Thrissur in Kerala, India.
The Univ was established in 2010.
The Univ is approved by

Kerala University of Health Sciences website has following sections at the left side of the page:

Top left of page

About KUHS
Governing Council
Academic Council
Board of Studies
Contact KUHS

Research Desk

Research Desk
PhD Notifications
Ethics Committee
Workshop on Scientific Writting
Online Classes

Bottom left of page

Image Gallery
RTI Officers
Diary of Events
News Corner


Cultural Fest
Literary Fest
Sports and Games
Social Service


Senate Election
College Union
Governing Council
Statutory Councils
University Union

Kerala University Of Health And Allied Sciences
Thrissur, Thangaloor, Kerala 680596
0487 220 7664

Answered By StudyChaCha Member

Last edited by Aakashd; August 4th, 2018 at 12:48 PM.
Reply With Quote

Reply to this Question / Ask Another Question
Your Username: Click here to log in


All times are GMT +6.5. The time now is 06:51 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8