Advance Excel Course APP
Microsoft Excel - Excel from Beginner to Advanced Course
Learn Microsoft Excel Course from beginning to Advanced. Learn Advance Excel Course with 50+ Excel Formulas such as VLOOKUP, Index & Match , Logical Formulas , Financial Formulas, cells formatting, macro and many more.
Microsoft Excel Fundamentals
Quick start
Intro to Excel
Customizing the Excel Quick Access Toolbar
Rows & columns, Name Box & Formula Bar
Cells
Working with Cell References
Formatting
Saving an Excel Document
Opening an Existing Excel Document
Tables
Marksheet
Common Excel Shortcut Keys
Charts
Formulas & functions
PivotTables
Formulas & functions
5+ Projects
Excel Fundamentals Quiz
Modifying an Excel Worksheet
Moving and Copying Data in an Excel Worksheet
Inserting and Deleting Rows and Columns
Changing the Width and Height of Cells
Hiding and Unhiding Excel Rows and Columns
Renaming an Excel Worksheet
Deleting an Excel Worksheet
Moving and Copying an Excel Worksheet
Formatting Data in an Excel Worksheet
Working with Font Formatting Commands
Changing the Background Color of a Cell
Adding Borders to Cells
Excel Cell Borders Continued
Formatting Data as Currency Values
Formatting Percentages
Merging and Centering Cells
Using Conditional Formatting
Inserting Images and Shapes into an Excel Worksheet
Inserting Images
Inserting Excel Shapes
Formatting Excel Shapes
Working with Excel SmartArt
Creating Basic Charts in Excel
Creating an Excel Column Chart
Adding and Modifying Data on an Excel Chart
Formatting an Excel Chart
Working with Excel Pie Charts
Advance Excel Course 50+ Formulas
Advanced Excel is the use of more complex functions and tools within Microsoft Excel to analyze and manipulate data in more sophisticated ways. Some of the advanced features of MS Excel include:
These functions can be accessed through the Formulas tab in Excel, or by typing their names into a cell preceded by an equal sign (=).
There are many categories of Excel formulas, but here are some of the most common ones:
1. Arithmetic Formulas: Used for basic mathematical operations like addition, subtraction, multiplication, and division.
2. Logical Formulas: Used for evaluating logical conditions like IF statements, AND, OR, NOT, etc.
3. Lookup and Reference Formulas: Used for finding and referencing specific data within a worksheet or across multiple worksheets.
4. Date and Time Formulas: Used for calculating and manipulating dates and times.
5. Text Formulas: Used for manipulating text strings, including concatenating, separating, and formatting text.
6. Financial Formulas: Used for calculating financial data, including interest rates, loan payments, and investment returns.
7. Statistical Formulas: Used for analyzing statistical data, including mean, median, mode, standard deviation, and variance.
8. Engineering Formulas: Used for performing engineering calculations, including calculations related to electricity, mechanics, and materials science.
9. Database Formulas: Used for working with data stored in a database.
10. Array Formulas: Used for performing calculations on a range of cells rather than a single cell.
Working with Excel's Conditional Functions
Using Excel's IF() Function
Nesting Functions with Excel
Excels AND() Function
Excels OR() Function
Excel's IF() Function with AND() Function
Excel's IF() Function with OR() Function
Lookup Function
In Microsoft Excel, the LOOKUP function is used to search for a value in a range of cells or an array, and return a corresponding value in the same position from a different range or array. There are few types of LOOKUP functions in Excel:
Microsoft Excel Lookup Function
Microsoft Excel Vlookup Function
Microsoft Excel Hlookup Function
Excel Index Function
Excel Match Function
Microsoft Excel INDEX() and MATCH() Function Combined
Choose Function
Financial Formula
PMT ( EMI Calculate)
IPMT (Interest Calculate)
PPMT (Principle Amount Calculator)
PV (Present Value)
FV (Future Value)
Read more
Learn Microsoft Excel Course from beginning to Advanced. Learn Advance Excel Course with 50+ Excel Formulas such as VLOOKUP, Index & Match , Logical Formulas , Financial Formulas, cells formatting, macro and many more.
Microsoft Excel Fundamentals
Quick start
Intro to Excel
Customizing the Excel Quick Access Toolbar
Rows & columns, Name Box & Formula Bar
Cells
Working with Cell References
Formatting
Saving an Excel Document
Opening an Existing Excel Document
Tables
Marksheet
Common Excel Shortcut Keys
Charts
Formulas & functions
PivotTables
Formulas & functions
5+ Projects
Excel Fundamentals Quiz
Modifying an Excel Worksheet
Moving and Copying Data in an Excel Worksheet
Inserting and Deleting Rows and Columns
Changing the Width and Height of Cells
Hiding and Unhiding Excel Rows and Columns
Renaming an Excel Worksheet
Deleting an Excel Worksheet
Moving and Copying an Excel Worksheet
Formatting Data in an Excel Worksheet
Working with Font Formatting Commands
Changing the Background Color of a Cell
Adding Borders to Cells
Excel Cell Borders Continued
Formatting Data as Currency Values
Formatting Percentages
Merging and Centering Cells
Using Conditional Formatting
Inserting Images and Shapes into an Excel Worksheet
Inserting Images
Inserting Excel Shapes
Formatting Excel Shapes
Working with Excel SmartArt
Creating Basic Charts in Excel
Creating an Excel Column Chart
Adding and Modifying Data on an Excel Chart
Formatting an Excel Chart
Working with Excel Pie Charts
Advance Excel Course 50+ Formulas
Advanced Excel is the use of more complex functions and tools within Microsoft Excel to analyze and manipulate data in more sophisticated ways. Some of the advanced features of MS Excel include:
These functions can be accessed through the Formulas tab in Excel, or by typing their names into a cell preceded by an equal sign (=).
There are many categories of Excel formulas, but here are some of the most common ones:
1. Arithmetic Formulas: Used for basic mathematical operations like addition, subtraction, multiplication, and division.
2. Logical Formulas: Used for evaluating logical conditions like IF statements, AND, OR, NOT, etc.
3. Lookup and Reference Formulas: Used for finding and referencing specific data within a worksheet or across multiple worksheets.
4. Date and Time Formulas: Used for calculating and manipulating dates and times.
5. Text Formulas: Used for manipulating text strings, including concatenating, separating, and formatting text.
6. Financial Formulas: Used for calculating financial data, including interest rates, loan payments, and investment returns.
7. Statistical Formulas: Used for analyzing statistical data, including mean, median, mode, standard deviation, and variance.
8. Engineering Formulas: Used for performing engineering calculations, including calculations related to electricity, mechanics, and materials science.
9. Database Formulas: Used for working with data stored in a database.
10. Array Formulas: Used for performing calculations on a range of cells rather than a single cell.
Working with Excel's Conditional Functions
Using Excel's IF() Function
Nesting Functions with Excel
Excels AND() Function
Excels OR() Function
Excel's IF() Function with AND() Function
Excel's IF() Function with OR() Function
Lookup Function
In Microsoft Excel, the LOOKUP function is used to search for a value in a range of cells or an array, and return a corresponding value in the same position from a different range or array. There are few types of LOOKUP functions in Excel:
Microsoft Excel Lookup Function
Microsoft Excel Vlookup Function
Microsoft Excel Hlookup Function
Excel Index Function
Excel Match Function
Microsoft Excel INDEX() and MATCH() Function Combined
Choose Function
Financial Formula
PMT ( EMI Calculate)
IPMT (Interest Calculate)
PPMT (Principle Amount Calculator)
PV (Present Value)
FV (Future Value)
