Advanced Excel

Course Content (2 days - 2 Participants)

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

Get a Quote

Let us get back to you by entering the details below

CIGNEX is a global consulting company offering solutions, services and platforms on Open Source, Cloud and Automation technologies. Since 2000, CIGNEX has been delivering enterprise class solutions, which are built using leading platforms & can easily be integrated with existing systems to achieve unparalleled results. By leveraging multiple delivery models, we help organizations around the world to increase revenue, achieve business goals, gain competitive advantage, and maximize customer satisfaction while significantly reducing the cost of doing business.

As a leading System Integrator, CIGNEX provides end-to-end services on Liferay | UiPath | Kafka – Confluent | Sitecore | Red Hat | Appian | Salesforce | Servicenow | MongoDB | Drupal

For any questions, RFP or to get in touch, you can email us at info@cignex.com

Solutions

Services

Staffing Services

Resources

About Us