MOF 003 – Microsoft Excel (Beginner to Advanced) 23 & 24 November 2023

MOF 003 – Microsoft Excel (Beginner to Advanced) 23 & 24 November 2023

Teachers
Sazali
Category:
IT PP/ Public Programs/
RM 1,990.00
D4 (3)

RM 1,990.00

Duration: 2 Days
Lectures: De Palma Hotel
Certificate of Completion

Objective

This course introduces participants Beginner, Intermediate and Advance levels to the Basic
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 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.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

2 Days Training Content

This content is restricted to members only. Please log in to view more details. Registration are Free!

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 Excel
    1) Create an Excel Sheet and Enter the Data
    2) Format Data in Microsoft Excel
    3) Make Column Names Bold
    4) Align Data to the Left
    5) Enclose Data in Boxes
    6) 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: Intermediate (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