Microsoft Excel Level 2 Intermediate 1 Day
Course Overview
The Intermediate Microsoft Excel course provides knowledge of the more advanced functions of Excel for anyone looking to develop their Excel skills further. From Advanced Formulas and Functions, Using Named Ranges and Charting you’ll be equipped with the knowledge and skills you need to work with Excel on a more advanced level.
Prerequisites: A working knowledge of Excel to L1 Introductory level or equivalent working knowledge.
Course Objectives
· Using multiple worksheets, workbooks, and workspaces
· Working with advanced functions
· Use advanced formatting techniques
· Using charts to display data
· Using Excel as a Database
Advanced Functions
- Working with BODMAS
- Defining Relative, Mixed, and Absolute References
- Creating and Using Functions:
- IF and Nested IF
- Sumif and Countif
- Understanding and working with Dates
- VLOOKUP and LOOKUP
- Subtotals
- Flashfill
Protecting and maintaining workbooks
- Saving as a template
- Protecting a Worksheet
- Protecting a workbook
Moving and Copying Data between Worksheets
- Linking Data Between Worksheets
- Creating a 3-D Formula
Named Ranges
- Creating and Using Named Ranges
- Automatically Naming Ranges
- Navigating with Named Ranges
- Using Range Names in Formulas
- Pasting a List of Named Ranges
- Deleting and Editing Range Names
- Creating Named Constants
Working with Lists
- Sorting a List
- Filtering a List
- Advance Filter
- Using Subtotals in a List
- Outlining
- Data Validation
- Dropdown menus using Validation lists
Advanced Formatting
- Creating Custom Number Formats
- Applying an AutoFormat (Table Format)
- Conditional Formats
- Clear conditional formats
Charting
- Creating a Chart
- Changing Chart Type, Style, and Chart Sub-Type
- Change the data in an existing chart
- Filter in charts
- Managing Chart Objects
- Moving and Resizing Chart Objects
- Deleting Chart Objects
- Adding Data Series and Objects to a Chart
- Changing the Chart Type
- Formatting Chart Objects
- Dual Axis
- Saving Chart Template
- Sparklines
Microsoft Excel Level 2 Intermediate 1 Day
Course Overview
The Intermediate Microsoft Excel course provides knowledge of the more advanced functions of Excel for anyone looking to develop their Excel skills further. From Advanced Formulas and Functions, Using Named Ranges and Charting you’ll be equipped with the knowledge and skills you need to work with Excel on a more advanced level.
Prerequisites: A working knowledge of Excel to L1 Introductory level or equivalent working knowledge.
Course Objectives
· Using multiple worksheets, workbooks, and workspaces
· Working with advanced functions
· Use advanced formatting techniques
· Using charts to display data
· Using Excel as a Database
Advanced Functions
- Working with BODMAS
- Defining Relative, Mixed, and Absolute References
- Creating and Using Functions:
- IF and Nested IF
- Sumif and Countif
- Understanding and working with Dates
- VLOOKUP and LOOKUP
- Subtotals
- Flashfill
Protecting and maintaining workbooks
- Saving as a template
- Protecting a Worksheet
- Protecting a workbook
Moving and Copying Data between Worksheets
- Linking Data Between Worksheets
- Creating a 3-D Formula
Named Ranges
- Creating and Using Named Ranges
- Automatically Naming Ranges
- Navigating with Named Ranges
- Using Range Names in Formulas
- Pasting a List of Named Ranges
- Deleting and Editing Range Names
- Creating Named Constants
Working with Lists
- Sorting a List
- Filtering a List
- Advance Filter
- Using Subtotals in a List
- Outlining
- Data Validation
- Dropdown menus using Validation lists
Advanced Formatting
- Creating Custom Number Formats
- Applying an AutoFormat (Table Format)
- Conditional Formats
- Clear conditional formats
Charting
- Creating a Chart
- Changing Chart Type, Style, and Chart Sub-Type
- Change the data in an existing chart
- Filter in charts
- Managing Chart Objects
- Moving and Resizing Chart Objects
- Deleting Chart Objects
- Adding Data Series and Objects to a Chart
- Changing the Chart Type
- Formatting Chart Objects
- Dual Axis
- Saving Chart Template
- Sparklines
