Interactive Excel Training - A2: Elementary Course

Description

Table of Contents

Unit 0: Introduction A2

Unit 1: Intro to Functions
• What is a Function?
• Create a Function
• Advantages
• Operations within functions
• Errors
• Summary & Glossary 1
• Control 1

Unit 2: Mathematical and Statistical Functions 1
• ROUND Function
• SUM Function
• COUNT and COUNTA Function
• COUNTBLANK Function
• MAX and MIN Functions
• Functions within Functions
• Summary & Glossary 2
• Control 2

Unit 3: Mathematical and Statistical Functions 2
• AVERAGE, MEDIAN and MODE.SNGL functions
• SUMPRODUCT Function
• LARGE and SMALL Functions
• RAND and RANDBETWEEN Functions
• More mathematical Functions
• Summary & Glossary 3
• Control 3

Unit 4: Logical and Conditional Functions 1
• If Function
• AND / OR Functions
• Nesting IF, AND, OR Functions
• SUMIF Function
• COUNTIF Function
• COUNTIFS Function
• SUMIFS Function
• IFERROR Function
• IFS Function
• Summary & Glossary 4
• Control 4

Unit 5: File Protection
• Create a Table
• Table Styles
• Sort and Filter
• Slicer
• Convert and Resize Table
• Table Style Options
• Summary & Glossary 5
• Control 5

Unit 6: File Protection
• Chart Essentials
• Creation and elements of a chart
• Chart Formatting
• Bar Charts
• Line Charts
• Combo Charts
• Pie Chart
• Doughnut Charts
• Funnel Charts
• Sparklines
• Summary & Glossary 6
• Control 6

FINAL EXAM

System Requirements

Please note the following minimum requirements for an optimal course experience:

>Stable internet access with a minimum speed of 100 Mbps.
>A modern browser (such as Chrome or Firefox).
>Windows 10 or higher operating system.
>Allow access to domains.

Author

Ninja Excel

7 Courses