Microsoft Excel Course
Course Features
- Course Instructor: Experienced Teachers
- Category: Office Productivity
- Exam: Online
- Certificate: Government Approved
Course Details
Learn Advanced Microsoft Excel step by step. This course covers Beginners, Intermediate, and Advanced Levels to cater to the needs of everyone who wants to learn Excel in-depth.
The Advanced Microsoft Excel Training Course includes:
- Creating and editing spreadsheets
- Working with functions and formulas
- Pivot tables, VLOOKUP, HLOOKUP
- Charts, graphs, and other features to improve productivity in Excel
- Syllabus for Microsoft Excel Training Course
- Excel User Interface
- Auto Series
- Basic Arithmetic Operations: Addition, Subtraction, Multiplication, Division
- Conditional Formulas:
- IF Formula
- Complex Conditional Formula (IF, AND, OR Functions)
- Fix Reference
- Working with Dates & Times
- Cell Formats & Conditional Formatting
- Advanced Editing Features:
- Paste Special
- Charts and Graphs
- Filtering & Sorting Data
- Pivot Tables & Advanced Filters:
- Slicer and Timeline Filters
- Spark Lines & Power View
- Sheet Protection & Data Validation
- Removing Duplicates
- Lookup Functions:
- VLOOKUP, HLOOKUP
- Importing Data & Navigating Sheets
- Excel Contingency Table
- Printing Sheets & Page Break Management
- Flash Fill
- Financial Formulas:
- Loan EMIs (PMT), Fixed Deposits (FV), Recurring Deposits (FV), Investment (PV), Interest Rate
- Goal Seek
- Statistical Functions:
- MIN, MAX, AVERAGE, COUNT
- Miscellaneous Functions
- Navigation Shortcuts & Powerful Excel Tricks
- Macros in Excel & Many More