Interactive Excel Training - B1: Intermediate Course

Description

Table of Contents

Unit 0: Introduction B1

Unit 1: Text Functions
• RIGHT and LEFT
• SEARCH - FIND
• MID
• REPLACE - SUBSTITUTE
• CONCAT
• TEXTJOIN
• TEXTBEFORE - TEXTAFTER
• TRIM
• PROPER - UPPER - LOWER
• LEN
• Summary & Glossary 3
• Control 1

Unit 2: Time and Date Functions
• Sum Time
• Convert Time Units
• TIME
• HOUR – MINUTE – SECOND
• NOW - TODAY - TODAY+N
• DATE - DAY - MONTH - YEAR
• EDATE - EOMONTH
• DATEDIF
• WORKDAY
• NETWORKDAYS
• WORKDAY.INTL
• NETWORKDAYS.INTLS
• Summary & Glossary 2
• Control 2

Unit 3: Outline
• Group
• Auto Outline
• Subtotals
• Summary & Glossary 3
• Control 3

Unit 4: Data Forecast
• Show Scenarios
• Create Scenarios
• Goal Seek
• Create Forecast
• Data Table
• Summary & Glossary 4
• Control 4

Unit 5: PivotTable
• Pivot Table and its characteristics
• Create Pivot Tables, Drag and Sort fields
• Pivot Table Options
• Refresh Pivot Table
• Working with tables for Pivot Table design
• Value Field Settings
• Filter and Sort Pivot Tables
• Design and Move Pivot Tables
• Manual and Automatic Groupings
• Protection of Pivot Tables
• Summary & Glossary 5
• Control 5

Unit 6: Pivot Charts
• Create Interactive Charts from Tables
• Create Pivot Chart
• Pivot Chart tools
• 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