This course introduces participants to the Basic ,Intermediate of Microsoft Excel. Participants will learn the basics skills necessary to create and edit basic worksheets and workbooks, enter data, formulas, format and print workbooks. Participants gain knowledge on working with Name Ranges, more complex formulas and functions, They will learn how to manage their data by working with tables, sorting and filtering, highlight important data using conditional formats. Participant will also learn to validate, analyze and summarize their data. At the end of the course, the participant will be able to demonstrate the ability to perform complex calculation and manage data efficiently with Microsoft Excel.
MOF 003 – Microsoft Excel (Intermediate), 25 & 26 June 2024
MOF 003 – Microsoft Excel (Intermediate), 25 & 26 June 2024
RM 1,400.00
INTRODUCTION
OBJECTIVES
The overall outcome of the module is designed to achieve the terms of the skills and knowledge that participants will be able to demonstrate upon completion:
- Discuss on how Microsoft Excel can be an appropriate tool to run a day-to-day business.
- Illustrate the different components of the Excel worksheet and demonstrate advanced practical skills using Excel to perform data analysis, expenses analysis and forecasting in a business.
WHO SHOULD ATTEND?
This course was designed for participants who are just starting to get to know Microsoft Excel or for those who are looking to refresh their own skills and learn more about the available tools in Excel.
2 DAYS TRAINING MODULE
Day One (9am - 5pm)
- What is Microsoft Excel?
- Why Should I Learn Microsoft Excel?
- Understanding the Ribbon
- Ribbon components explained
- Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
- Important Excel shortcuts
- How to Do Addition, Subtraction, Multiplication & Division in Excel
- How To Perform Arithmetic Operations In Excel1)Create an Excel Sheet and Enter the Data2)Format Data in Microsoft Excel3)Make Column Names Bold4)Align Data to the Left5)Enclose Data in Boxes6)Set the Print Area, Print Preview & Page Layout
- Proper, Lower & Upper
- Data Validation
- Data Filters
- Group and Ungroup
- Summary
- What is a Chart?
- Types of Charts in Microsoft Excel
- The Importance of Charts
- Step by Step Example of Creating Charts in Excel
- Summary
- SUM
- SUMIF
- CONCAT
- COUNTIF
- VLOOKUP
- IF
- HLOOKUP
- COUNTIF
- Insert Picture into a Cell in Excel
- Layer and Group Objects
- Grouping Objects
- Incorporate SmartArt
- Recording Macros
- Writing a Macro using the Visual Basic Editor
- Editing Macro
- Running Macro
- Insert a PivotTable
- Drag fields
- Sort
- Filter
- Change Summary Calculation
- Two-dimensional Pivot Table
- Create a PivotTable timeline to filter dates
- Use a Timeline to filter by time period
- Use a Timeline with multiple PivotTables
- Clear a Timeline
- Customize a Timeline
Day Two (9am - 5pm)
Topic A: Create a PivotTable
- Start with Questions End with
- Structure
- Create PivotTable Dialog Box
- PivotTable Fields Pane
- Summarize Data in a PivotTable
- Show Values As Functionality of a
- PivotTable
Topic B: Filter Data by Using Slicer and Timelines
- Insert Slicers Dialog Box
- Insert Timelines
Topic C: Analyzing Data with PivotChart
- Creating PivotChart
- Applying a Style to a PivotChart
Topic A: Customizing Workbooks
- What is a Hyperlink?
- Inserting Hyperlinks
- Editing Hyperlinks
- Formatting Hyperlinks
- Using Hyperlinks in Excel
Topic A: Finishing Workbook
- Publishing to PDF or XPS
Topic B: Protecting Worksheet and Workbook
- Protecting the Current Sheet
- Protecting an Entire Workbook
- File Protection
About Instructors
Sazali
- Microsoft Office Training
- Microsoft Word
- Microsoft Excel
- Microsoft Powerpoint