Microsoft Excel
COURSE FEATURES
Course Instructor : Experience Teachers
Category : Office Productivity
Exam : Online
Certificate :Government Approved
COURSE DETAILS
Learn Advanced Excel Certification Course through Step by Step. This course covers Beginners Level, Intermediate as well as Advance Level that caters need of everyone who wants to learn Microsoft Excel in depth.
This Advance Microsoft Excel Training Course covers creating and editing spreadsheets, working with functions and formulas, pivot table, v lookup, h lookup, charts and lot many features that improves your overall productivity in MS Excel.
Syllabus for Microsoft Office Excel Training Course
Advance Microsoft Excel Training
Excel User Interface
Auto Series
Addition and Subtraction
Multiply and Divide
Conditional Formula – IF
Complex Conditional Formula IF
AND OR Function
Fix Reference
Working with Date
Working with Time
Cell Formats
Conditional Formatting
Paste Special
Charts and Graphs
Filter and Sorting
Pivot Table
Slicer and Timeline Filters
Spark lines
Power View
Freeze Pane
Protecting Sheets
Data Validation
Removing Duplication
V and H Lookup
Importing Data
Navigating
Working with Sheets
Excel Contingency Table
Printing Sheets
Page Break
Flash Fill
Loan EMI’s (PMT)
Fixed Deposits (FV)
Recurring Deposits (FV)
Investment (PV)
Interest Rate
Goal Seek
Min and Max
Average Function
Count Function
Misc. Functions
Navigation Shortcuts
Powerful Tricks
Macros in Excel
You will also get Practice Files for Excel. They are Pre-Designed Excel Documents filled with data and information relevant to each topics covered in Advanced Excel Certification Course.
After completion of this course, you will be able to work effectively and productively in Microsoft Excel. You can also learn other applications in Office Productivity Category.
Stop paying for Microsoft for Office or Windows. Get Free LICENSE for Windows and Office and bypass payments to Microsoft.