Working Smart with Microsoft Excel

Learn efficient Excel techniques for everyday tasks.

Course Objectives:

Improve productivity with spreadsheets.

Audience:

Administration Staff Financial Executive Operational Staff Resource and planning team Supervisors Engineers

Course Outlines:

Module 1: Keeping dynamic data range as Table

Create Table
Quick insert of new row
Quick Formatting using Table Style
Turn on quick summary with Subtotal
Cleaning Up Duplicate Entry
Convert Table as Range

Module 2: Getting a summary to meet specific criteria

Adding up value with SUMIF / SUMIFS
Finding number of entry with COUNTIF / COUNTIFS
Average up value with AVERAGEIF / AVERAGEIFS
return an alternative result with IFERROR

Module 3: Rules to control user input in a cell

Dropdown list to limit entries
Restrict value entry for number and date
Custom user defined restriction

Module 4: Quick search, compile and compare data from multiple sheets / workbooks

Vertical search for exact matching data using VLOOKUP
Horizontal search for matching data using HLOOKUP
VLOOKUP as alternative for Nested IF function
Multiple searches with INDEX and MATCH

Module 5: Identify data trends and patterns

Highlight Cell Rules
Using Data Bars
Using Icon Sets
Creating New Rules with Formula

Courses You May Like

Your RFQ submission has been received

Our representative will be in touch with you soon