Live Virtual Training (Most Popular!) > Microsoft Excel 2019 Foundation
Give participants a systematic understanding of a spreadsheet ad its benefits
Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment
Upon completion of this program, participants should be able to:
• Getting Started with Microsoft Excel 2019, Identify the Elements and Interface of Excel
• Performing Calculation, Basic Formula and Functions
• Modify worksheet & Formatting Worksheet
• Printing and managing large workbook
REQUIRED PREREQUISITES:
Basic knowledge of Windows is essential with the following pre-requisites:
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.
Module 1: Getting Started with Microsoft Excel 2019
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 B Creating a New Blank Workbook
• The Ribbon
• The Backstage View
• The Save and Save As Commands
Module 2: Formatting a Worksheet
Topic A: Formatting Fonts
• Fonts
• The Font Group
• The Format Cells Dialog Box
• The Format Painter
• Live Preview and Formatting
• The Mini Toolbar
• The Clear Button
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
• The Wrap Text Command
• Orientation Options
Module 3: Modifying a Worksheet
Topic A: Manipulate Data
• The Undo and Redo Commands
• The AutoFill Feature
• Auto Fill Options
• The Transpose Option
• Live Preview
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
Module 4: Performing Calculation
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)
Module 5: Managing Large Workbooks
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
Module 6: Printing Workbook Contents
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 Titles
• Scaling Options
4.5
Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.
FREE QUOTATION!
COURSE INCLUDES
COURSE BENEFITS
ALL IN FROM ONLY
RM949/DAY
RRP RM2,500/DAY SAVE RM1,551
*T&C Applies
Customer Service 101
Trainer Indy
Effective Thinking and Solution Mindset (Online Training)
Trainer Dr Alvin
Time & Stress Management (Online Training)
Trainer Dr Alvin
Business English For Office (Online Training)
Trainer Fakitah
Enhancing Business Correspondence (Online Training)
Trainer Fakitah
Occupational Safety & Health (OSH) Management Workshop (Online Training)
Trainer Dominic
RRP RM1,000/day SAVE RM275
Live chat, call or email, we’re here for you
Quorse is Asia’s #1 online training marketplace that connects learners with trainers who seek a value-added training experience on a single platform. Discover training courses from diverse categories, ranging from technical IT certifications to personal development programs.
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