MOF 003 – Microsoft Excel (Intermediate & Advanced) 16 & 17 Oct 2023

MOF 003 – Microsoft Excel (Intermediate & Advanced) 16 & 17 Oct 2023

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

RM 1,990.00

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

Objective

Intermediate: Microsoft Excel Intermediate course will equip you with hands-on knowledge to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Advanced: This advanced Excel course syllabus is designed for the intermediate Excel user who desires to learn more advanced skills. Learn the most advanced formulas, functions, charts and types of financial analysis to be an Excel power user.

Methodology

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Visualize Data with Charts
  • Create Advanced Charts
  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Using date & time function
  • Create pivot table and use pivot function

2 Days Training Content

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

Day One: Intermediate (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
    Step 1) Create an Excel Sheet and Enter the Data
    Step 2) Format Data in Microsoft Excel
    Step 3) Make Column Names Bold
    Step 4) Align Data to the Left
    Step 5) Enclose Data in Boxes
    Step 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 MS 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 Graphic Objects
  • Grouping Objects
  • Incorporate SmartArt

  • How to insert the current date and time in Excel
  • Current date and time formulas (dynamic)
  • Date and time example
  • Date and time formulas (static)

  • Insert a Pivot Table
  • 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: Advanced (9am-5pm)

  • An overview of the screen, navigation and basic spreadsheet concepts
  • Various selection techniques
  • Shortcut Keys

  • Customizing the Ribbon
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options

  • Using Functions – Sum, Average, Max,Min, Count, Counta

  • Currency Format
  • Format Painter
  • Formatting Dates
  • Custom and Special Formats
  • Formatting Cells with Number formats, Font formats,
  • Alignment, Borders, etc
  • Basic conditional formatting

  • File Level Protection
  • Workbook, Worksheet Protection

  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Exact
  • Concatenate
  • Find, Substitute

  • Creating Simple Pivot Tables
  • Basic and Advanced Value Field Setting
  • Classic Pivot table
  • Choosing Field
  • Filtering PivotTables
  • Modifying PivotTable Data
  • Grouping based on numbers and Dates
  • Calculated Field & Calculated Items
  • Arrays Functions
  • What are the Array Formulas, Use of the Array Formulas?
  • Basic Examples of Arrays (Using ctrl+shift+enter).
  • Array with if, len and mid functions formulas.
  • Array with Lookup functions.
  • Advanced Use of formulas with Array.

  • Various Charts i.e. Bar Charts / Pie Charts / Line Charts
  • Using SLICERS, Filter data with Slicers
  • Manage Primary and Secondary Axis

  • Planning a Dashboard
  • Adding Tables and Charts to Dashboard
  • Adding Dynamic Contents to Dashboard

About Instructors

Sazali
- Microsoft Office Training - Microsoft Word - Microsoft Excel - Microsoft Powerpoint