MS Excel Advance Course Certification
Want to grow your career? Learn Advanced MS Excel and make your work smarter and faster. ExcelR’s course will teach you useful tools, formulas, and reports that companies need every day. Get practical training, a valuable certificate, and support from our 5000+ hiring partners to find better job opportunities.
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
Excel Fundamentals
- Quick start, Intro to Excel
- Quick Access Toolbar
- Rows & columns, Name Box & Formula Bar
- Saving and Opening Excel sheet
- 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, Shapes, Charts
- Inserting Images
- Inserting Excel Shapes
- Formatting Excel Shapes
- Working with Excel SmartArt
- Creating an Excel Column Chart
- Adding and Modifying Data on an Excel Chart
- Formatting an Excel Chart
- Working with Excel Pie Charts
Worksheet Printing
- 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
Working with Excel List
- Inserting Images
- Inserting Excel Shapes
- Formatting Excel Shapes
- Working with Excel SmartArt
- Creating an Excel Column Chart
- Adding and Modifying Data on an Excel Chart
- Formatting an Excel Chart
- Working with Excel Pie Charts
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
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
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.
- 1. Arithmetic Formulas
- 2. Logical Formulas
- 3. Lookup and Reference Formulas
- 4. Date and Time Formulas
- 5. Text Formulas
- 6. Financial Formulas
- 7. Statistical Formulas
- 8. Engineering Formulas
- 9. Database Formulas
- 10. Array Formulas
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
- NOT function
- If with AND Function In Excel
- If with OR Function In Excel
- Nested If Function
- Assignments
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
- LOOKUP Function
- VLOOKUP Function
- HLOOKUP Function
- INDEX Function
- MATCH Function
- INDEX with MATCH Function
- Choose Function
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