## Ace it Training

Price: AED 1,200

### Course details

Introduction

• History and Introduction of spreadsheets
• Prevent data loss in the Event of System

Crash

Didn't Save a Workbook? Don't Worry- Save a Workbook

Basic Formula & Function

• Applying Relative, Absolute & Mixed Referencing
• Defining Names & Using them in Functions

Formatting Techniques

• Customized Number Formatting
• Working with Pictures, Objects and Smart Art

Dates & Times

• The Science of Dates in Excel & Date Functions
• Working of Time in Excel and Useful Time  Functions
• Prepare Daily and Monthly Schedules

Efficient Handling of Data

• Quick Data Selection Techniques
• Quick Data Entry Techniques
• Use of Special Paste
• Accelerating Copy Paste
• Managing a Large Quantity of Data
• Flash Fill & Quick Analysis
• Summarizing Data with Sorting and filtering
• Advanced Use of Find & Replace

Analyzing Data with Conditional Formatting

• Highlighting Values based on Criteria
• Applying & Managing Formatting Rules
• Using the Data Bars, Icon Sets & Color Scales

Charts & Graphs

• Creating a Chart in no Time!
• Most Commonly Used Charts
• DO's & Don'ts of Excel Chart Formatting
• Charts Formatting

Working with Tables

• Exploring the Power of Excel Tables
• Creating Dynamic Ranges with Tables

IF Function with AND & OR

• Applying the Powerful IF Function
• Simple IF & Nested IF Function AND Function Combined with IF Function  OR Function Combined with IF Function

Lookup Functions

• VLOOKUP and HLOOKUP & its Limitations
• Alternate to VLOOKUP: Combining Index- match
• SUMIF, AVERAGEIF, COUNTIF & INDIRECT Functions
• SUMIFS, AVERAGEIFS & COUNTIFS & OFFSET Functions

Pivot Tables

• A Powerful Reporting Tool
• Analyzing Data with Pivot Tables
• Walking Through Report Builder Layout
• Managing & Presenting Pivot Tables Data
• Working with Pivot Charts
•    Excel Advanced New Feature: Slicers & Timeline

Data Validation

• Creating Drop down List
• Regulating and Managing the Entry of Data
• Custom Input Message and Error Alert

What-If Analysis

• Using the Brilliant Goal-Seek Feature
• Use of Data Tables to Display Probable Results
• Using Scenario Manager to Summarize Results

• Identifying the Source Cell
• Tracking changes made to Data

Managing Worksheets

• Consolidating Data
• Lining Worksheets & Workbooks
• Calculating Across Worksheets with "3-D Formula"

Printing & Security

• Techniques
• Restricting Editing in Data
Macros

• What is a Macro?
• Recording & Running/Executing a Macro
• Assigning Macros to Objects
• Adding Interactive Form Controls to Worksheet

Updated on 06 December, 2017

### Course Location

Ace it Training, Dubai, is a leader in providing IELTS Training,Certified Supply Chain and Logistics Professional,Certified Human Resource and Competency Professional,  and Spoken English Training.

Our goal is to continuously improve organizational skills in facilitating an efficient training environment by implementing well-thought-out strategies in the areas of management education. Ace it Training offers a range of highly regarded executive and corporate development programmes, including courses specially tailored for our corporate clients. Our courses range from basic Computer Applications to Logistics, Supply Chain Management, Customer Service, Marketing Skills, Accounting, Secretarial Skills, Languages and IELTS test preparations.

See all Ace it Training courses
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.
See all courses