Excel Course: Master Microsoft Excel 365 Foundation
Are you looking to boost your career prospects? Our Excel Course on Microsoft Excel 365 Foundation is your ticket to unlocking a world of opportunities. Whether you’re a newbie or already have some spreadsheet experience, this course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels, and anyone eager to elevate their Microsoft Excel skills.
What You'll Learn
In this interactive and practical course, we delve into the core of Microsoft Excel 365, breaking down complex spreadsheet concepts into easy-to-understand modules. You’ll discover how to navigate the Excel interface, create and format data, perform calculations, and manage large workbooks efficiently. By the end, you’ll be equipped with the skills to confidently handle tasks like data analysis, report creation, and more.
Elevate Your Career
In today’s fast-paced corporate world, Excel proficiency is a valuable asset. Whether you’re striving for a promotion, aiming for a new job, or simply looking to enhance your productivity, mastering Microsoft Excel 365 through our Excel Course can set you on the path to success. Join us to harness the power of spreadsheets, and watch your career soar to new heights. It’s time to excel in Excel!
Course Details
Course Code: EX365F-1 ; Instructor-led
Audience
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.
Prerequisites
Basic knowledge of Windows is essential with the following pre-requisites:
- Able to maneuver with the mouse – Point, Click, Drag and Double Click
- Able to configure the desktop
- Able to use the Control Panel
- Able to move and re-size Application Windows
- Able to switch between task applications
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
- Give participant a systematic understanding of a spreadsheet and 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 365, Identify the Elements and Interface of Excel
- Performing Calculation, Basic Formula and Functions
- Modify worksheet & Formatting Worksheet
- Printing and managing large workbooks
Outlines
Module 1: Getting Started with Microsoft Excel 365
Topic A – Identify the Elements of the Excel Interface
- Microsoft Excel 365
- 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 File View
- The Save and Save As Commands
Module 2: Formatting a Data in Worksheet
Topic A: Formatting Fonts
- Font type
- Font size
- Font color
- Bold
- Italic
- Underline
- The Mini Toolbar
- The Clear Button
Topic B: Add Borders and Colors to Cells
- Select Border
- Select Fill
Topic C: Align Cell Contents
- Horizontal Alignment
- Vertical Alignment
- Increase or Decrease Indent
- Wrap Text
- Orientation Options
- Merge & Center
Topic D: Apply Formats
- Format cell
- Number
- Date
- Currency
Topic E: Move and Duplicate data
- Dragging and Dropping Cells
- Cut, copy, and paste cells
- Cut, copy, and Paste Multiple cells
- Using the Clipboard
- Paste Special
- Format Painter
Topic F: Apply Cell Styles
- Cell Styles
- Style Dialog Box
Topic G: Manipulate Data
- Undo and Redo Commands
- AutoFill Feature
- Auto Fill Options
- Transpose Option
Topic H: Insert, Manipulate, and Delete Cells, Columns, and Rows
- Insert and Delete cell, row, column
- Column Width and Row Height Alternation Methods
- Hide and Unhide row, column
Topic I – Spell Check a Worksheet
- The Spelling Dialog Box
Topic J – Search for and Replace Data
- The Find Command
- The Replace Command
- The Go to Command
Module 3: Performing Calculation
Topic A: Create Formulas in a Worksheet
- Common Mathematical Operators
- Addition
- Subtract
- Multiply
- Divide
- The Order of Operations
Topic B: Insert Functions in a Worksheet
- Functions in Excel
- SUM
- AVERAGE
- COUNT
- MIN
- MAX
- Worksheet References in Formulas
Module 4: Referencing Calculations
Topic A: Formula Reference
- Relative References
- Absolute References
- Mixed References
Module 5: Managing Large Workbooks
Topic A: Format Worksheet Tabs
- Insert or Delete sheet
- Renaming Worksheet Tabs
- Changing sheet Tab Color
Topic B: Manage Worksheets
- Repositioning Worksheets
- Hiding and Unhiding Worksheets
Topic C: Manage the view of Worksheets and Workbooks
- Split Command
- Freeze Panes
- Arrange All Command
- View Side by Side Command
- Switch windows Command
- New Window Command
- Zoom Options
Module 6: Printing Workbook Contents
Topic A: Define the Page Setup
- Print Options in Backstage View
- Page Setup Dialog Box
- Print Preview Option
- Page size
- Page orientation
- Page Margins
- Headers and Footers
Topic B: Print Options
- Scale to fit
- Page break
- Print title
