ACIS Training Testing
-
2.5 How to Use Basic Statistical Functions in Excel 2010
- 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_...
- 2.2 Use the INDEX, MATCH Functions to Perform Look...
- 2.3 Excel Logical Functions
- 2.4 IFERROR Function
- 2.5 How to Use Basic Statistical Functions in Exce...
- 2.6 SumIF-countIF-averageIF functions
- 2.7 Advanced IF functions in Excel - COUNTIFS and ...
- 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 Dashb...
- 4.2 Introduction to Pivot Tables, Charts and Dashb...
- 4.3 Creating a Dashboard Using Pivot Tables and Ch...
- Charts - Assignments
- Assignment 3
- Section 5
- 5 Form Controls
- Course info
