Advance Excel Course with 50+ Formulas

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
  • 40+ hours Live Lecture
  • Android App
  • 50+ downloadable resources
  • Certificate of completion

What you will learn

  • Master MS Excel from Beginner to Advanced
  • 50+ Excel functions used in the Office
  • Maintain large sets of Excel data
  • Create dynamic reports 
  • PivotTables & Charts
  • Dashboard & Micro
Basic MS Excel Course

Excel Fundamentals

  • Quick start
  • Intro to Excel
  • Customizing the Excel Quick Access Toolbar
  • Rows & columns, Name Box & Formula Bar
  • Cells & Cell References
  • Basic Formatting Excel
  • Saving an Excel Document
  • Opening an Existing Excel Document
  • Tables & Marksheet
  • Common Excel Shortcut Keys
  • Charts
  • Formulas & functions
  • Pivot Tables

Modifying 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 Excel

  • Working with Font Formatting Commands
  • Changing the Background Color of a Cell
  • Adding Borders to Cells
  • Numbers Groups
  • Formatting Data as Currency Values
  • Formatting Percentages
  • Merging and Centering Cells
  • Conditional Formatting in Excel

Inserting Images and Shapes

  • Inserting Images
  • Inserting Excel Shapes
  • Formatting Excel Shapes
  • Working with Excel SmartArt

 

MS Excel Charts

  • Creating an Excel Column Chart
  • Adding and Modifying Data on an Excel Chart
  • Formatting an Excel Chart
  • Working with Excel Pie Charts

 

Excel Worksheet Printing

  • Viewing your Document in Print Preview
  • Changing the Margins, Scaling and Orientation
  • Excel Worksheet Margins
  • Working with Page Layout View
  • Adding Header and Footer Content
  • Printing a Specific Range of Cells

 

Working with Excel List

  • Sorting a List Using Single Level Sort
  • Sorting a List Using Multi-Level Sorts
  • Using Custom Sorts in an Excel List
  • Filter an Excel List
  • Using Conditional Formatting to Find Duplicates
  • Removing Duplicates
  • Creating an Excel Data Validation List

 

Excel Pivot Tables

  • Creating an Excel Pivot Table
  • Modifying Excel PivotTable Calculations
  • Formatting PivotTable Data
  • Creating Pivot Charts
  • Filtering PivotTable Data
  • Filtering with the Slicer Tool

 

Large Sets of Excel Data

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

 

Excel If Analysis

  • Mastering Excel’s “What If?” Tools
  • Working with Excel’s Goal Seek Tool
  • Building Effective Data Tables in Excel
  • Creating Scenarios in Excel

 

Printing Option

Advance Excel Course

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

  • File Tab
  • Home Tab
  • Insert Tab
  • Page Layout Tab
  • Formula Tab
  • Data Tab
  • Review Tab
  • View Tab
  • Remove Duplicate
  • Data Validation  
  • Transpose 

Basic Functions

  • Sum Function
  • AutoSum
  • Subtraction 
  • Multiplication Function 
  • Product Function
  • Division  Function 
  • Percentage Calculate
  • Average
  • Max
  • Min
  • Count

Logical Functions

  • If Function In Excel
  • AND Function
  • OR Function
  • If with AND Function In Excel
  • If with OR Function In Excel
  • Nested If Function

Cell References

  • What is Reference in Excel?
  • Relative Cell Reference
  • Absolute Cell Reference
  • Mixed Cell Reference
  • Assignment

Lookup Functions

  • LOOKUP Function 
  • VLOOKUP Function 
  • HLOOKUP Function  
  • INDEX Function
  • MATCH Function
  • INDEX with MATCH Function
  • Choose Function 

Statistical Functions

  • SUM
  • SUMIF Function 
  • SUMIFS Function 
  • COUNTIF Function 
  • COUNTIFS Function 
  • AVERAGEIF Function 
  • AVERAGEIFS Function 

Count Functions

  • COUNT Function
  • COUNTA Function
  • COUNTIF Function
  • COUNTIFS Function
  • COUNTBLANK Function
  • Assignments

Text Functions

  • UPPER & LOWER Function 
  • PROPER Function
  • LEFT & RIGHT Function
  • MID Function 
  • LEN Function In Excel
  • TRIM Function in Excel
  • CONACATENATE Function

Financial Formula

  • PMT Function (EMI Calculate)
  • IPMT Function (Interest Calculate)
  • PPMT Function (Principle Amount Calculator)
  • PV Function (Present Value)
  • FV Function (Future Value)

Other Functions

  • Frequency Function
  • Product Function
  • SUMPRODUCT Function
  • Subtotal Function 
  • REPT Function
  • SUBSITUTE Function
  • ABS Function

Data Related Settings

  • Data Sorting
  • Data Validation
  • Data Consolidation
  • Pivot Table
  • Dashboards Creation
  • Slicers Use
  • Remove Duplicates
  • Linking Sheets
  • Macros Use in Excel
  • Page Setup With Printing Options
  • Data Security
  • Password Protection
  • Calculate Age in MS Excel
  • Calculate Percentage in MS Excel
  • Convert Binary to Decimal Number
  • Add country code before mobile no
  • Calculate compound interest
  • Convert number to text