Unlock Your Excel Expertise with Our Excel Course
Looking to elevate your Microsoft Excel skills? Look no further! Our ‘Microsoft Excel 365 ntermediate’ course is the perfect opportunity to take your spreadsheet prowess to the next level. Whether you’re a clerk, manager, or anyone in between, this Excel course is designed to empower you with practical knowledge and hands-on experience.
What You'll Learn
In this engaging and interactive course, we delve into the depths of Excel’s capabilities. You’ll master advanced functions like COUNTIFS, AVERAGEIFS, SUMIFS, and nested IF statements. We’ll also explore data visualization, helping you turn raw data into insightful charts and graphs. Plus, you’ll discover the power of tables, data validation, and dynamic range organization. By the end of this course, you’ll be creating impressive reports, setting up tables effortlessly, and turning numbers into compelling visuals.
How We Teach
Our teaching methodology combines interactive lectures, PowerPoint presentations, lively discussions, and practical exercises. We believe in hands-on learning, ensuring that you not only understand the concepts but can apply them confidently in your day-to-day work.
Don’t miss out on this opportunity to boost your Excel skills. Join our ‘Microsoft Excel 365 Intermediate’ course today and unlock your full potential with Excel. Elevate your career, impress your colleagues, and excel in the world of spreadsheets!
Course Details
Course Code: EX365I-2; 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
- Text Functions
- Lookup Functions
- Conditional Functions
- Database Function
- Apply Range Name
- Auditing Formulas
- Useful tools to manipulate data
- Navigating Objects
- Filter data using Auto & Advanced Filters
- Visualizing Data as a Graphics
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
- Advanced Filtering
Topic C: Insert Hyperlink to Navigate Object
- Insert Hyperlink
- Edit Hyperlink
- Formatting Hyperlink
- Using Hyperlink in Excel
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
- IF Function
Topic D: Conditional Data Summary
- COUNTIF / COUNTIFS
- AVERAGEIF / AVERAGEIFS
- SUMIF / SUMIFS
Topic E: Auditing Formulas
- Trace Precedents and Dependents
- Remove Arrows
- Show Formulas in spreadsheet
- Checking Error
- Evaluate Formula
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 Validation
- Data Validation Using Lists
- Data Validation Using Date
- Data Validation Using Whole Number / Decimal
Module 5: Data Visualization
Topic A: Conditional Formatting
- Highlight Cell Rules
- Data Bars
- Icon Sets
- Creating New Rules with Formula
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
Topic D: Adding Sparklines
- Adding Sparklines
- Removing Sparklines
Topic E: Editing Sparklines
- Showing and Hiding Data
- Changing the Style
- Changing the Sparkline and Marker Color
- Setting Axis Options
Module 6: Setting Up Reports as Pages
Topic A: Working with Different Views
- Using Page Break Preview for Page Setup
- Using Page Layout View for Express Header & Footer
- Using Custom view
