IT and Computing (Live Online) > EX19F(1) Microsoft Excel – Foundation (Online Training)
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise
Topic A – Identify the Elements of the Excel Interface
– Microsoft Excel 2019
– What is Spreadsheet, Worksheet and Workbook
– What are Columns, Row, Cells, and Ranges
– The Excel Interface
– Navigation Options
Topic A: Modify Fonts
– Fonts
– The Font Group
– The Format Cells Dialog Box
– The Format Painter
– Live Preview and Formatting
– The Mini Toolbar
Topic B: Add Borders and Colors to Cells
– Border Options
– Fill Options
– Sheet Backgrounds
Topic C: Apply Number Formats
– Number Formats
– Dragging and Dropping Cells
– How to cut, copy, and paste cells
– How to cut, copy, and Paste Multiple cells
– Using the Clipboard
– Using Paste Special
– Number Formats in Excel
– Custom Number Formats
Topic D: Align Cell Contents
– Alignment Options
– The Indent Commands
– Orientation Options
– The Merge & Center Options
Topic E: Apply Cell Styles
– Cell Styles
– The Style Dialog Box
Topic A: Manipulate Data
– The Undo and Redo Commands
– The AutoFill Feature
– Auto Fill Options
– The Transpose Option
– Live Preview
– The Clear Button
Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
– The Insert and Delete options
– Column Width and Row Height Alternation Methods
– The Hide and Unhide Options
Topic C – Search for and Replace Data
– The Find Command
– The Replace Command
– The Go to Command
Topic D – Spell Check a Worksheet
– The Spelling Dialog Box
Topic A: Format Worksheet Tabs
– Renaming Worksheet Tabs
– Changing Tab Color
Topic B: Manage Worksheets
– Repositioning Worksheets
– Inserting or Deleting Worksheets
– Hiding and Unhiding Worksheets
– Worksheet References in Formulas
Topic C: Manage the view of Worksheets and Workbooks
– Split Command
– Freeze Panes options
– Arrange All Command
– Arrange Windows Dialog Box
– View Side by Side Command
– Switch windows Command
– New Window Command
Topic A: Create Formulas in a Worksheet
– Excel Formulas
– The Formula Bar
– Elements of an Excel Formula
– Common Mathematical Operators
– The Order of Operations
– Division Formula
Topic B: Insert Functions in a Worksheet
– Functions
– The Function Library
– Common Functions in Excel (SUM, AVERAGE, COUNT, MIN & MAX)
Topic A: Define the Basic Page Layout for a Workbook
– The Print Options in Backstage View
– The Page Setup Dialog Box
– The Print Preview Option
– Headers and Footers
– Header and Footer Settings
– Page Margins
• Margins Tab Options
• Page Orientation
Topic B: Refine the Page Layout and Apply Print Options
– Zoom Options
– Page Breaks
– Page Break Options
– The Print Area
– Print Area
– Scalling Options
4.5
Nazarudin Aziz started freelancing as a Corporate Trainer since the year of 2005 specializing in the field of Multimedia Graphic Designer and Microsoft Office Applications. His list of clients are Perodua, Grand Pacific Hotel, Cosway, UDA Mall, Institut Teknologu Rekabentuk Perabot Malaysia, Telekom Malaysia, Lembaga Tabung Haji, Yayasan Pelajaran MARA, Kementerian Pembangunan Wanita & Masyarakat, Hospital Tengku Ampuan Rahimah Klang, United Engineers Malaysia, Malaysian Maritime & Dredging Corporation, Jabatan Perdana Menteri, Indah Water Consotrium and many more.
FREE QUOTATION!
THIS PUBLIC COURSE INCLUDES
CLASS DETAILS
ALL IN FROM ONLY
RM0/PAX
*T&C Applies
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
4
4
4
4
4
4
4
4
4
3
3
Live chat, call or email, we’re here for you
Since its inception in 2009, Quorse, pronounced as “Kor-Say,” has been dedicated to revolutionizing the way you search for and engage with training courses.
As a comprehensive training search engine, our mission is to simplify the process of sourcing courses, making it effortless and efficient for you. Our extensive database, available 24/7, houses over 5000 courses spanning a variety of fields and disciplines.
Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly
Sign in with your social account
or
By signing up, you agree to our Terms of Use and Privacy Policy