Tips and Tricks in Excel

DOMESTIC INQUIRY
DOMESTIC INQUIRY (Statutory Requirement Process & Procedures)
November 3, 2022

Ms. Adila Diyana

Trainer's Profile

Ms. Adila Diyana has a bachelor’s degree in Accounting and Finance from Aberystwyth University, United Kingdom and currently finishing her professional papers to be a Chartered Accountant from Association of Chartered Certified Accountants (ACCA). Adila had worked in one of the big 4 audit firm, multinational company, and government-linked company. She had accumulated experience in preparation of statutory audit report and tax computation for auditor and tax agent as well as identifying cost saving projects through deep dive financial and data analysis. Prior to becoming a trainer, she has previously conducted training and knowledge sharing session for her colleagues in relation to Microsoft Excel and cost saving initiative across healthcare, property, and facility as well as infrastructure services.

Organizations Trained:
- Rubber Industry Smallholders Development Authority (RISDA)
- Majlis Agama Islam Selangor (MAIS)
- Pertubuhan Keselamatan Sosial (PERKESO)
- FGV Holdings Berhad
- BBV Engineering (M) Sdn Bhd
- PERSOLKELLY Consulting
- Construction Industry Development Board (CIDB)
- KESM Industries Berhad
- Prestige Sports Sdn Bhd
- Kaneka Malaysia

Topics Trained:
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Teams
- Microsoft Outlook
- Finance for Beginner
- Costing and Cost Reduction
- Pengurusan Kewangan

Tips and Tricks in Excel
Introduction
Tips and Tricks in Excel course covers different functions and formula available in the Excel spreadsheet. It is suitable for complete beginners without or little prior knowledge of Excel. At the end of this course, the participants will have a good understanding about the different features available in Excel which can be use daily at work and in business.
Learning Objectives
  • Practice data cleaning in Excel through data analysis, learning pivot table fundamentals, as well as grouping, shorting and filtering pivot data.
  • Creating charts using pivot table and learning to update the data.
  • Creating interactive dashboard and dashboard reporting in Excel.
  • Illustrate the different components of the Excel worksheet.
  • 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.
Course Outline

Data Analysis

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Use Advanced Chart Features (Pareto)
  • Pivot Table Extension (Slicer)

Format Table

  • Convert Range to Table
  • Convert Table to Range
  • Table Styles Options
  • Insert Slicer

Charts and Graphs

  • Create Basic Charts and Graphs (Pie Chart, Column Chart, Bar Chart, Line Graph)
  • Create Actual vs Target Charts and Graphs
  • Create Dual Charts and Graphs (Pareto)
  • Editing Charts and Graphs
  • Charts and Graphs Styles Option
  • Text to Column function
  • Group/Ungroup
  • Freeze Pane
  • VLookup Function
  • Find and replace function

Count If and Sum If Function

  • COUNTIF And COUNTIFS function
  • SUMIF and SUMIFS function
  • Apply If Error function
  • Apply Formatting critical thinking
Requirement
  • You will need a laptop.
  • You will need Microsoft Excel in your device.
  • Complete the exercises provided in each section.

TARGET AUDIENCE

This course was designed for participants who has none to basic knowledge about Microsoft Excel or for those who are looking to refresh their own skills and learn more about the different components in Microsoft Excel.

DATE

8th March 2024 (Friday)

TIME

9.00am – 5.00pm

DURATION

7 hours (1 full day)

DELIVERY MODE

Face-To-Face Programme

VENUE

Hartamas Training Centre, Level 13, Block A, Menara Prima, Jalan PJU 1/37, Dataran Prima, 47301, Petaling Jaya, Selangor Darul Ehsan


 

Have an enquiry? Please share your information













    For enquiries: