Create Excel Formulas And Automated Sheets

I am an Excel Expert with More than 10 years of experience in Handling Excel Worksheet of many international Clients.

Prepared Budgeted cashflows and income statement of my clients as per their needs.

Filling cells by using advanced Fill Series options

Protecting worksheets and cell ranges

Referencing data in other workbooks

Creating custom number formats

Configure data validation

Group and ungroup data

Calculate data by inserting subtotals and totals

Remove duplicate records

Create custom conditional formatting rules

Create conditional formatting rules that use formulas

Managing conditional formatting rules

Performing logical operations by using nested functions including the IF(), IFS(),SUMIF(),AVERAGEIF(),COUNTIF(), SUMIFS(),COUNTIFS(),AND(), OR(), and NOT() functions

Looking up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions

Referencing date and time by using the NOW() and TODAY() functions

Summarizing data from multiple ranges by using the Consolidate feature

Performing what-if analysis by using Goal Seek and Scenario Manager

Forecasting data by using the AND(), IF(), and NPER() functions

Calculating financial data