Agnhub - Best Computer training institute in jaipur

Introduction of MS Excel

Find & Replace in MS Excel

Font in MS Excel

Undo and Redo Command in MS Excel

Add Border

Text Alignment & Indent Options in MS Excel

Orientation in MS Excel

Format Painter in MS Excel

Wrap Text in MS Excel

Format Numbers

Conditional Formatting in MS Excel

Format Table & Cell Styles Option in Excel

Insert Column & Row in MS Excel

Change Row Height and Column Width in MS Excel

How to Hide & Unhide Row and Column in MS Excel

Rename and Copy Worksheet in MS Excel

Autofill Dates

Sort Numbers & Data Using Sort Filter Option in MS Excel

How to use Mini Toolbar & Shortcut Menu in MS Excel

What is Quick Access Toolbar in MS Excel

Status Bar to find Sum

Remove Formatting

Sum Formula in Excel

Clipboard in MS Excel

Paste Special to Copy Formula & Format in MS Excel

Conditional Format in MS Excel

How to Transpose Data in MS Excel

Data Validation in MS Excel

Create Drop Down List with Data Validation in MS Excel

How to Set Limit for Date & Time Using Data Validation Option in MS Excel

Preventing Duplicate Entries & Allow Text

How To Add Data Of Multiple Sheets & Workbook By Consolidate Option In MS Excel

Learn To Insert & Delete Image From Background Of Data In MS Excel

How To Navigate Between Sheets Of A Workbook Using Go To Option In MS Excel

How to Use Print Option for Printing Worksheet & Setting Orientation

How To Print Title Or Heading On Every Page By Print Titles Option In MS Excel

How to use the LOOKUP Function in Excel

How to Use Vlookup Formula to Find Particular Data in Same

How To Check Column & Row Number Of A Cell By Column & Row Formula In Excel

How to Check Number of Columns or Rows in A Table Using Columns & Rows Formula in Excel â€

How To Get Multiple Results By Using Vlookup Formula For Single Time In Excel

Use of Hlookup Formula to Find Data from Database in Same

How To Freeze & Unfreeze Multiple Rows And Columns In Excel

Generate Random Numbers Using Rand And Randbetween Formula In Excel

Learn To Calculate EMI Using PMT Formula In MS Excel

Use Of Goal Seek Formula To Know Estimated Down Payment Amount In MS Excel

How To Insert Chart & Change Its Color

How to calculate interest & principal amount of loan using IPMT & PPMT function in Excel â€

How to use Averageif & Averageifs in MS Excel to calculate average based on different conditions

How to create template in Excel with font style

How to use COUNT

How to remove different types of formula errors in MS Excel

How to use concatenate formula and "&" sign to combine data of 2 or more cells in Exce

How to change case (upper

How to use FV formula to calculate future value of an investment in Excel

How to protect a complete worksheet or a part of worksheet with password in MS Exce

How to use clean formula in MS Excel for removing non-printable characters from data

How to calculate running total in MS Excel

How to split full name to first and last name in microsoft excel

How to use Dsum in MS Excel to add numbers of particular column based on a condition

How to use Dget in Excel to search a record from a database according to a conditio

How to use Daverage in MS Excel to find average of a data of a column based on condition

How to use sumproduct in Excel to find sum of the products of one or more cell range

How to use ceiling

How to use Forecast formula in MS Excel

How to find & remove duplicate data

How to use Edate formula to find the name of the day of any future or past date in Excel

How to calculate lowest common multiple using LCM formula in MS Excel

How to calculate GCD and find ratio of numbers using GCD in MS Excel

How to calculate overtime hours in MS Excel

Calculate age using datedif formula in Excel

How to calculate Simple Interest in MS Excel

How to make compound interest calculation chart in MS Excel

How to use power formula in Excel

How to calculate Compound Interest using a formula in MS Excel

How to count numerical values of a column based on a condition using Dcount in MS Excel

How to use Spelling & Thesaurus option in MS Excel to check spellings & find synonyms

How to do addition of a column

How to use TRIM function to remove extra space & SUBSTITUTE to replace characters in Excel

How to use replace formula to replace a part of a text in MS Excel

How to use Dcounta to count filled cells of a column according to a condition in Excel

How to use Sumifs to add values of column

How to use Frequency in Excel to check that how many times a record repeats in a table

How to use Rank Formula in MS Excel

How to use large function in Excel to find top largest values from list & their addition

How to use small function to find some smallest values from the list in Excel

How to use Dmax & Dmin to find largest or smallest number based on a condition in Excel

How to use round

Using iferror function in Excel to hide errors that occur due to formula

How to use Vlookup function with iferror formula in MS Excel

How to use vlookup with match function to perform two-dimensional Vlookup in MS Excel

How to use index+match function in Excel

How to use choose formula with Vlookup to search a value from multiple tables in Excel

How to use array function in MS Excel to perform multiple calculations in one time

How to convert rows into columns & columns into rows using an array function in Excel

How to use max formula as an array function in MS Excel

How to convert Vlookup in array function to search multiple data simultaeously in Excel

How to use DB formula to calculate depreciation in Excel

How to use scenario manager to compare multiple scenarios of data sets in Exce

How to use nested if formula for checking multiple conditions in MS Excel

Split full name into first

How to use Fuzzy Lookup in Microsoft Excel

How to use iseven & isodd formula to check whether a number is even or odd in Excel

How to organize data using recommended pivot table in microsoft Excel

How to create & customize a pivot table in MS Excel

How to insert and customize a pivot chart in MS Excel

How to create a pivot chart using a pivot table in Microsoft Excel

How to use isblank formula with if function in MS Excel

How to calculate square root & cube root in Microsoft Excel

How to reverse a list in Microsoft Excel

How to use istext & isnontext formulas in Excel to check if cell contains text or not

How to merge data of different cells into one cell separated by comma in MS Excel

How to view multiple excel workbooks

How to use the CHAR function in Excel

How to extract required details from huge data using concatenate & char formula in Exce

How to insert a blank row in between two data rows in MS Excel

How to use hyperlinks in MS Excel

How to insert & resize picture in Microsoft Excel

How to use indirect formula in Excel

How to use flash fill for splitting full name

How to use left

How to block actions performed on the worksheet of Excel Workbook

How to create & use the named range in Excel

How to use Group & Ungroup options in Excel

How to protect Excel workbook with password

How to use indirect formula to find sum

How to make only first letter of a sentence capital in Microsoft Excel

How to insert & customize shapes in MS Excel

How to insert & customize smartart in Excel

How to record macro in MS Excel for doing repetitive calculations & tasks

How to insert screenshot in Excel

MS Excel

Course Overview

Topics