0(0)

Highly Demanding -Excel

  • Course level: Intermediate
  • 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

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
0
    0
    Your Cart
    Your cart is emptyReturn to Shop