×

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

Resources

About Us

Copyright © CIGNEX, 2020