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.

Course Highlights

Learn online, At your own schedule
30+ hours Live Lecture
Android App
50+ downloadable resources
Certificate of completion

What you'll learn

1. Master Microsoft Excel from Beginner to Advanced
2. Learn the most common Excel functions used in the Office
3. Maintain large sets of Excel data in a list or table
4. Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and 50+ more.
5. Build a solid understanding on the Basics of Microsoft Excel
6. Create dynamic reports by mastering one of the most popular tools, PivotTables

This course includes:

Microsoft Excel Fundamentals

1. Quick start
2. Intro to Excel
3. Customizing the Excel Quick Access Toolbar
4. Rows & columns, Name Box & Formula Bar
5. Cells
6. Working with Cell References
7. Formatting
8. Saving an Excel Document
9. Opening an Existing Excel Document
10. Tables
11. Marksheet
12. Common Excel Shortcut Keys
13. Charts
14. Formulas & functions
15. PivotTables
16. Formulas & functions
17. 5+ Projects
18. Excel Fundamentals Quiz

Modifying an Excel Worksheet

1. Moving and Copying Data in an Excel Worksheet
2. Inserting and Deleting Rows and Columns
3. Changing the Width and Height of Cells
4. Hiding and Unhiding Excel Rows and Columns
5. Renaming an Excel Worksheet
6. Deleting an Excel Worksheet
7. Moving and Copying an Excel Worksheet

Formatting Data in an Excel Worksheet

1. Working with Font Formatting Commands
2. Changing the Background Color of a Cell
3. Adding Borders to Cells
4. Excel Cell Borders Continued
5. Formatting Data as Currency Values
6. Formatting Percentages
7. Merging and Centering Cells
8. Using Conditional Formatting

Inserting Images and Shapes into an Excel Worksheet

1. Inserting Images
2. Inserting Excel Shapes
3. Formatting Excel Shapes
4. Working with Excel SmartArt

Creating Basic Charts in Excel

1. Creating an Excel Column Chart
2. Adding and Modifying Data on an Excel Chart
3. Formatting an Excel Chart
4. Working with Excel Pie Charts

Printing an Excel Worksheet

1. Viewing your Document in Print Preview
2. Changing the Margins, Scaling and Orientation
3. Excel Worksheet Margins
4. Working with Page Layout View
5. Adding Header and Footer Content
6. Printing a Specific Range of Cells

Working with an Excel List

1. Sorting a List Using Single Level Sort
2. Sorting a List Using Multi-Level Sorts
3. Using Custom Sorts in an Excel List
4. Filter an Excel List
5. Using Conditional Formatting to Find Duplicates
6. Removing Duplicates
7. Creating an Excel Data Validation List

Excel Pivot Tables

1. Creating an Excel Pivot Table
2. Modifying Excel PivotTable Calculations
3. Formatting PivotTable Data
4. Creating Pivot Charts
5. Filtering PivotTable Data
6. Filtering with the Slicer Tool

Working with Large Sets of Excel Data

1. Using the Freeze Panes Tool
2. Grouping Data (Columns and/or Rows)
3. Print Options for Large Sets of Data
4. Consolidating Data from Multiple Worksheets

Working with Excel's Text Based Functions

1. Mastering Excel's "What If?" Tools
2. Working with Excel's Goal Seek Tool
3. Building Effective Data Tables in Excel
4. Creating Scenarios in Excel

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.

Basic Excel Functions

 

1. Sum
2. Subtraction
3. Multiplication Function
4. Division  Function 
5. Percentage Calculate 
6. Average
7. Max
8. Min
9. Count

Working with Excel's Conditional Functions

1. Using Excel's IF() Function
2. Nesting Functions with Excel
3. Excels AND() Function
4. Excels OR() Function
5. Excel's IF() Function with AND() Function
6. Excel's IF() Function with OR() Function

Cell referenced :

Cell reference in Excel refers to the way that Excel identifies a cell or range of cells on a worksheet. A cell reference is typically a combination of a column letter and a row number that identifies a specific cell, such as A1, B2, C3, and so on. The cell reference tells Excel which cell to use in a formula or function.

1. Relative
2. Absolute Reference
3. Mixed Reference

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:

1. Microsoft Excel Lookup Function
2. Microsoft Excel Vlookup Function
3. Microsoft Excel Hlookup Function
4. Excel Index Function
5. Excel Match Function
6. Microsoft Excel INDEX() and MATCH() Function Combined
7. Choose Function

Statistical Function In Excel:

In Excel, statistical functions are built-in functions that perform various statistical analyses and calculations on data. These functions are designed to help you analyze and understand data by providing you with tools to summarize and make sense of it.

Here are some common statistical functions in Excel:

1. Sumif In Excel
2. Sumifs Function In Excel
3. COUNTIF Function In Excel
4. COUNTIFS Function In Excel 
5. Averageif Function In Excel 
6. Averageifs In Excel 
7. Product Function
8. Sumproduct Function in Excel
9. Subtotal Function In Excel

6. Count functions :

In Microsoft Excel, there are several COUNT category functions that allow you to count cells based on specific criteria. These functions include:

1. Count Function
2. Counta Function
3. Countif Function
4. Countifs Function
5. Countblank Function

7 Text Functions :

In Microsoft Excel, the TEXT function falls under the category of "Text" functions. This category includes various functions that can be used to manipulate and format text strings. Some of the other functions in this category include:

1. Proper Function In Excel
2. Upper Function In Excel
3. Lower Function In Excel
4. Left Function In Excel
5. Right Function In Excel
6. Mid Function In Excel
7. Len Function In Excel
8. Trim Function in Excel
9. Concatenate Function In Excel

8. Financial Formula

Microsoft Excel has a wide range of financial functions that can be used to perform various financial calculations. Some of the commonly used financial functions in Excel include:

1. PMT ( EMI Calculate)
2. IPMT (Interest Calculate)
3. PPMT (Principle Amount Calculator)
4. PV (Present Value)
5. FV (Future Value)

9. Other Excel Functions

1. Frequency
2. Product Function
3. Sumproduct Function
4. Subtotal Function
5. REPT Function
6. Subsitute Function

10. Data Related Functions:

1. Sorting Data
2. Data Validation
3. Consolidation
4. Pivot Table
5. Dashboards
6. Slicers
7. Drop Down List
8. Transpose
9. Remove Duplicates
10. Linking Sheets
11. Macros
12. Page Setup With Printing Options
13. Data Security
14. Password Protection

Automating Repetitive Tasks in Excel with Macros

1. Understanding Excel Macros
2. Creating a Macro with the Macro Recorder

11. Beyond of Syllabus

1. How to calculate age in MS Excel
2. How to calculate percentage in MS Excel
3. How to convert Binary to Decimal Number in MS Excel
4. How to add country code before mobile no in MS Excel
5. How to calculate compound interest in MS Excel
6. How to convert number to text in MS Excel
7. How to remove duplicate value in MS Excel
8. ABS Function In Excel