Advanced Excel

,

Duration: 2 Days

Course fee:$1,199.00 (₹86154.13)

Request for Quote

Request for Quote

Please fill this form, we'll get back to you as soon as possible!

Additional Information

Day 1

Functions Intro

– Absolute and Relative Referencing
– Error types

Functions – Conditional Calculation, Lookup

– SUMIFS, COUNTIFS
– VLOOKUP

Functions – Logical

– IF, Nested IF

Functions – Text, Date

– Text Operations, Text to Columns, Flash Fill
– Date Calculations

Working with Large Tables

– Sorting & Filtering Data
– SUBTOTAL Function

Day 2

Working with Templates

– Creating & Saving Templates
– Creating data validation
– Protecting your worksheets & workbooks

Reporting

– Conditional Formatting
– Pivot Tables
– Charts

Reviews

There are no reviews yet.

Be the first to review “Advanced Excel”

Contact Us

Please fill this form, we'll get back to you as soon as possible!

TOP mautic is open source marketing automation