img
iTrainingExpert Logo

Microsoft Excel - Basic

Banner
Microsoft Excel - Basic

Description

This Excel Basic workshop will familiarize delegates with spreadsheet terminology and the fundamental usage of Microsoft Excel including identifying Excel window components, navigating and analyzing worksheets, downloading templates, using pivot tables and how to modify page setups.

An overall coverage of the basic techniques and formulas unique to Microsoft: Excel.

By the end of the Excel Basic training, you will be able to:
  •  Apply formatting techniques to worksheet data.
  • Create and Modify charts.
  • Insert graphics.
  • Review workbooks for spelling errors.
  • Modify page setup.
  • Print worksheets.
  • Entering and editing text, values, and formulas.
  • Save workbooks in the Excel and other formats.
  • Move and copy data and formulas.
  • Determine absolute and relative references.
  • Work competently with ranges, rows, and columns.

Any and all personnel who find Microsoft Excel useful in their jobscope.

Module 1: Creating a Basic Worksheet
Explore the User Interface and the Ribbon
Enter Data and Save a Workbook
Customize the Quick Access Toolbar/User Interface
 
Module 2: Performing Calculations
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Module 3: Modifying a Worksheet
Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet
 
Module 4: Formatting a Worksheet
Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents
Apply Cell Styles
 
Module 5: Printing Workbook Contents
Print Workbook Contents Using Default Print Options
Set Print Options
Set Page Breaks
Module 6: Managing Large Workbooks
Format Worksheet Tabs
Manage Worksheets in a Workbook
Manage the View of Large Worksheets

This is an activity-based workshop to cover Excel features and commands to jump start productivity for existing Excel users. Laptops required.

To Contact Shahariah has been conducting IT based training for 10 years. 

Specialise in teaching:

  • MS-Word (Basic, Intermediate & Advanced)
  • MS-Excel (Basic, Intermediate & Advanced)
  • MS-PowerPoint(Basic, Intermediate & Advanced)
  • Ms-Access (Basic& Intermediate)
  • Lotus 123 (Basic& Intermediate)

Job Experience :

  • 10 years as Senior Instructor with Mesiniaga Berhad
  • 2 years as a Contract Systems Analyst with Esso Malaysia
  • 10 year as a IT Trainer (current) :Esso Malaysia
  • PC support for the entire Exploration Department
  • Procurement processing of new Hardware and Software (Purchase RQ and Contracts RQ)
  • Monitoring of purchases with the Materials Dept and Vendors

Used MS-Access software database and also SAP for database entry and update to monitor purchases

Some of the Companies whom I’ve conducted IT training and supported :

  • Exxon-Mobil Bhd
  • Perbadanan Nasional Bhd
  • Maybank Bhd
  • Malaysia Airlines System Bhd
  • American Home Assurance Bhd
  • Employees Provident Fund
  • Cycle and Carriage Bhd
  • SEH Malaysia Bhd
  • American Express
  • Jabatan Pengangkutan Jalan
  • Setiausaha Kerajaan Selangor
  • Monsanto Bhd 

To contact Shahariah, please call +6012 6869 628 or info@itrainingexpert.com

OR 

<>VINCENT CHIN
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer

Vincent has held financial, continuous improvement and I.T. positions in the banking, shared services and hospitality industry. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Office Specialist and a PSMB-accredited trainer. His previous roles include being an internal change consultant of a global team, a financial shared-services local head and a finance regional head. He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA and process improvement. Vincent’s experience in the continuous improvement sphere of the financial industry includes projects in process automation & robotics, productivity management, end-to-end reviews and streamlining. He also trained yellow belts and green belts in DMAIC (the acronym for Define, Measure, Analyse, Improve & Control; a problem-solving methodology in Six Sigma) for other various companies. Vincent codes in VBA and has developed complex bespoke Excel applications in the companies he worked for.
He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA and process improvement. Vincent also assist companies in automating Excel tasks, end-to-end process reviews, developing process target operating models and other areas of process continuous improvement.
Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, HSBC. Vincent adapts a highly practical approach in his training and relates topics he conducts to real-life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimics closely the solutions that are needed in his participants’ organizations. To contact Vincent, please feel free to email us at info@itrainingexpert.com or call +603 8074 9056 | +6012 6869 628

or

We have a faculty of specialists and can cater to your organisation's different levels and specific needs.

For training and advisory services, feel free to contact us at info@itrainingexpert.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123

"The trainer was very clear in this explanation on how to use the excel functions to enhance my work. Great job. Thanks" Farhan, Rail Transit.

“I have learned a lot of knowledge from this course, Micorsoft Excel – Intermediate. Both the training and the trainer are equally good. I would like to join other Microsoft Office course.”– Secretary, NUR Power Sdn Bhd

“Thanks to my trainer, Pn Sha, I learned to apply Microsoft Excel in my future work. She is good and expressive. She is able answer all my questions immediately. I hope to join for Microsoft Excel – Advanced Level.”– Accounts, Hiraki Timur Sdn Bhd.

“During the course, I learned to simplify my work using Microsoft Excel. After the course, I am so excited and can’t wait to apply the knowledge that I learned from this course. Pn Sha is an excellent and knowledgeable trainer. I hope to join Microsoft Excel – Advanced Level conducted by him.”– Accounts, Hiraki Timur Sdn Bhd.

Normal Fee Early Bird Group Fee
Sign up 1 pax Sign up 1 pax Sign up 3 pax or more
Pay 1 day(s) before course starts Pay 14 day(s) before course starts Pay 14 day(s) before course starts
MYR 3490 per pax MYR 2890 per pax MYR 2790 per pax
USD 1030 per pax USD 850 per pax USD 820 per pax

Upon successful completion of this program, you will receive a Certificate of Achievement.

1. ONLINE PAYMENT  by Credit card:  You can opt to register and pay online with our latest payment integration system through our website.

2. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks

We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com

USD 1030

Share to your friends