0(0)

Highly Demanding -Excel

Course level: Intermediate
Share:

Categories Business
Duration 12h
Total Enrolled 0
Last Update November 28, 2020

About Course

This course teaches you basic to advance concepts of Microsoft Excel. This tutorial cover in-depth lessons on how to use various Excel funtions

Description

Microsoft Office Online Training Course covers in-depth training for Microsoft Office including Word, Advanced Excel and PowerPoint Tutorial with Practical Examples and Live Documents. After completing this course, you will be able to work faster and smarter with MS Office 2013 and will improve your overall Office Productivity.

What Will I Learn?

Advanced 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
Sparklines
Power View
Freeze Pane
Protecting Sheets
Data Validation
Removing Duplications
V and H Lookup
Importing Data
Navigating
Working with Sheets
Excel Contingency Table
Printing Sheets
Page Break
Flash Fill
Loan EMIs (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

About the instructor

admin

0 (0 ratings)

8 Courses

3 students

₹399.00

Material Includes

• Free Demo
• Free Training Materials
• 24/7 support
• 1 Year Membership for upgrading the course
• Life time material Access

Requirements

High-speed Internet connection Adobe Acrobat Reader. For best experience, use of computer/laptop is recommended

Target Audience

All levels from beginners to professional level