Excel Course: Master Microsoft Excel 365 Intermediate Level
Welcome to the ultimate Excel Course, where you’ll truly master Microsoft Excel 365 at an intermediate level. Whether you’re a clerk, officer, executive, supervisor, or manager, this course is tailored to enhance your Excel skills to an intermediate level. If you’ve already got a basic understanding of Excel, this is your next step towards becoming a spreadsheet pro.
What to Expect in Our Excel Course
In this interactive course, you’ll dive deep into Excel’s functionalities. Learn to create complex formulas and functions, including AVERAGEA, AVERAGEIFS, SUMIF, SUMIFS, IF functions, and even nested functions. Master data validation, sorting, and filtering techniques for more efficient data management. Discover how to visualize data with conditional formatting, data bars, icon sets, and create stunning charts that tell a compelling data story.
Why Choose Our Excel Course
At Info Trek, we’ve been honing our training and development expertise for over two decades. Our commitment to staying at the forefront of technology means you’ll be learning the latest Excel techniques. Join us in our modern training facilities equipped with high-end computing systems and flexible exam facilities. Don’t miss out on the opportunity to excel in Excel. Enroll in our Microsoft Excel 365 Intermediate course today!
Course Details
Course Code: EX365I-1; Instructor-led
Audience
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Prerequisites
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
- Have attended Microsoft Excel – Foundation Level; OR
- Able to create a spreadsheet with simple formatting
- Able to print a spreadsheet with headers and footers added
- Able to apply Freeze Pane command
- Able to create basic formulas – Addition, Subtraction, Multiplication and Division
- Able to use basic functions – AutoSum, Count, Max, Min and Average functions.
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to:
- Create formulas and functions, like:
- Date and Time Functions
- Change Case Functions
- Lookup Functions
- Conditional Functions
- Useful Tools to Manipulate Data
- Sort and Auto Filter Data
- Visualizing Data as a Graphic
Outlines
Module 1: Organize Dynamic Data Range with Table
Topic A: Create and Modify Tables
- Create table
- Table Styles and Options
- Removing Duplicate Values
- Total Row with SUBTOTAL Functions
- Rename table
- Convert table to range
Topic B: Sort and Filter Data
- Sorting Data by value
- Sorting data by color
- Filtering Data
Module 2: Working with Functions
Topic A: Working with Date and Time Function
- TODAY
- NOW
- Calculation between dates formula
Topic B: Working with Text by Changing Case
- UPPER
- LOWER
- PROPER
Â
Topic C: Working with Lookup Function
- VLOOKUP
- IFERROR
Topic D: Conditional Data Summary
- COUNTIF / COUNTIFS
- AVERAGEIF / AVERAGEIFS
- SUMIF / SUMIFS
Module 3: Useful tools to Manipulate Data
- Using Text-to-Column
- TEXTSPLIT, TEXTJOIN, CONCAT
- Insert FlashFill to Combine and Split Data
- Insert Checkbox feature
Module 4: Data Visualization
Topic A: Conditional Formatting
- Highlight Cell Rules
- Data Bars
- Icon Sets
Topic B: Create Charts
- Chart Insertion Methods
- Resizing and Moving the Chart
- Adding Additional Data
- Switching Between Rows and Columns
Topic C: Modify and Format Charts
- Formatting the Chart with a Style
- Chart Elements
- Chart Filter
