Excel at Excel
Register here!

Google pay/Phone pe :
7780741024

Share your Payment Status

Whatsapp : +91 8367700222
Email : info@skillsigma.com

Advance Excel

Efficient data handling techniques with Excel


What will you learn?


  • Statistical Functions
  • Formula based Formatting
  • Macros
  • Transformation of data
  • Excel advance features in Office365

Key Highlights

  • Mentors with 15+ years of experience of corporate training with more than 50 MNCs.
  • Hands-on Practical Training
  • Realtime scenarios
  • Coding exercises
  • Program materials.
  • Recordings made available online post session also.
  • Recognized course completion certificate
  • Mentors with 15+ years of experience of corporate training with more than 50 MNCs.
  • Hands-on Practical Training
  • Realtime scenarios
  • Coding exercises
  • Program materials.
  • Recordings made available online post session also.
  • Recognized course completion certificate

Course Includes

Introduction to Advanced Excel

  • Introduction to Excel
  • Excel interface
  • Creating open workbook
  • Saving & Sharing Books
  • Cells basic
  • Modifying column
  • Function of excel

Conditiontional Statements

  • IF Statement
  • Implementing AND/OR/NOT Operators

Excel Statical Functions

  • SMALL/LARGE/RANK
  • Using RAND
  • Implementing SUMPRODUCT,COUNTIFS,SUMIFS,AVERAGEIF

Lookup Functions

  • Implemening ROW,COLUMN,VLOOKUP,HLOOKUP
  • INDEX
  • MATCH
  • CHOOSE

Text Functions

  • UPPER,LOWER,PROPER,TRIM,CONCATENATE
  • SEARCH & FIND,RIGHT,LEFT,LEN

Date & Time Functions

  • Using AutoFill Feature
  • Using YEAR,MONTH,DAY,HOUR
  • Using WEEKDAY,WORKDAY
  • DATEDIFF Function

Formula-Based Formatting

  • Highlight Rows based on function
  • Format Based on value of cell
  • Format Cell using Text & Logical Operators
  • Grouping Data in the Sheet

Dynamic Array Formula

  • Spill Range Properties
  • SORT Function
  • SORTBY Function
  • UIQUE& FILTER Function

Advance Feature of Excel

  • Filter Function in Office 365
  • Creating Excel data using Picture in Office 365
  • Format Data Using Power Pivot
  • Implementing Macro in the Excel

Certification

After completing course you will get a course completion certificate