ACIS Training Testing

Home / Course catalog / ACIS Training Testing

Get this course

BAG/ DSG/ AEG

ACIS Training Testing

Description

Content

Section 1
1 Introduction To Excel
Editing Data
Modifying Cells, Rows and Columns
Grouping Rows and Columns
Name Range
Sort & Filter
Fill Series
Freeze Panes
Section 2
2 Excel Functions and Formulae
2.1 Extract Data from a Spreadsheet using VLOOKUP_ MATCH and INDEX
2.2 Use the INDEX, MATCH Functions to Perform Lookups
2.3 Excel Logical Functions
2.4 IFERROR Function
2.5 How to Use Basic Statistical Functions in Excel 2010 sample
2.6 SumIF-countIF-averageIF functions
2.7 Advanced IF functions in Excel - COUNTIFS and SUMIFS
2.8a String Functions - Part 1
2.8b String Functions - Part 2
2.8c String Functions - Part 3
2.9.a. Date Functions part 1
2.9.b. Date Functions part 2
Excel Functions and Formulas - Assignments
Assignment 1
Section 3
3 Table and Data Manipulation
3.1 Conditional Formatting - Data Bars
3.2 Conditional Formatting - Formulas
3.3 Excel Data Manipulation - Part 1
3.4 Excel Data Manipulation - Part 2
Table and Data Manipulation - Assignments
Assignment 2
Section 4
4 Charts
4.1 Introduction to Pivot Tables, Charts and Dashboards - Part 1
4.2 Introduction to Pivot Tables, Charts and Dashboards - Part 2
4.3 Creating a Dashboard Using Pivot Tables and Charts
Charts - Assignments
Assignment 3
Section 5
5 Form Controls

Completion rules

All units must be completed

Back