Contact
Info
- Privacy Policy
- Terms of Use
Company
B-23A-3, The Ascent Paradigm, No. 1, Jalan SS7/26A, Kelana Jaya, 47301 Petaling Jaya, Selangor, Malaysia
Introductory To Excel Workshop (Basic Excel)
Overview
This Basic Excel course is designed to provide participants with a foundational understanding of the basic features and functions of Microsoft Excel. Through a combination of theoretical and practical exercises, participants will gain proficiency in creating, editing, and formatting spreadsheets, as well as performing calculations, sorting and filtering data.
This workshop will provide a solid foundation for further learning and application in a range of personal and professional contexts.
Duration
1 Day
Audience Profile
Any professional who It is wanting more knowledge on formulas, formatting worksheets, managing workbooks and worksheets for business data.
Pre-requisite
N/A
Course Outlines
Excel Interface
- Ribbon, Tabs, Quick Access Toolbar
Understanding Excel Data Entry
- Text, Number, Date
Navigation tips and Common Shortcut keys
- Autofill & Flash Fill
- AutoFill a Series
- Creating Custom Lists
Understanding Formulas
- Operators
- Using Cell References in Formulas
- Using Formulas with number, text & date values
Introduction to Functions
- Frequently used functions- AutoSum, Average, Max, Min, COUNT, COUNTA
Working with Date values & Functions
- Inserting Static Dates and Times
- Date Functions
- Inserting a Dynamic Date Only
- Inserting a Dynamic Date and Time
- Get last day of the month (EOMonth)
Formatting Columns
- Modifying Column Width
- Inserting & Deleting columns
- Modifying Row Height
- Inserting & Deleting Rows
Formatting Text
Formatting Numbers
Changing Alignment
- Horizontal and Vertical Text Alignment
- Merging Cells
- Text Wrapping
- Text Orientation
Borders and Shading
- Applying Borders
- Applying Cell Colors
Format Painter
Applying Cell Styles
Adjusting Zoom
- To use the Zoom Slider
- To use Zoom from the Ribbon
- To use the Zoom dialog box
- To use Zoom to Selection
Using Multiple Windows
- To open multiple windows of a single worksheet
- To open multiple windows of several workbooks
- To open a window for each worksheet in a Workbook
Using Freeze Panes
- To freeze panes
- To unfreeze panes
- To freeze the first column only
Using Split Windows
- To split a worksheet
- To remove the split
- To split using icons
Custom Views
- To create a custom view of the whole sheet
- To display a saved view
- To delete a saved view
Hiding and Unhiding Worksheets and Workbooks
- Hide a worksheet
- Display a hidden worksheet
Working With Multiple Worksheets
- Renaming Worksheet Tabs
Changing Worksheet Tab Colors
Inserting Worksheets
- Inserting Worksheets: Ribbon Option
- Inserting Worksheets: Right Click Option
- Inserting Worksheets: Button Option
Moving Worksheets
- Moving Worksheets: Same Workbook using the Ribbon
- Moving Worksheets: Same Workbook, Right Click
- Moving Worksheets: Same Workbook, Drag and Drop Option
- Moving Worksheets: Different Workbook
Copying Worksheets
- Copying Worksheets: Same Workbook using the Ribbon
- Copying Worksheets: Same Workbook using Right-click
- Copying Worksheets: Same Workbook, Drag and Drop Option
- Copying Worksheets: Different Workbook
Deleting Worksheets
Grouping and Ungrouping Sheets
- Grouping Worksheets
- Ungrouping Worksheets
Setting up your Worksheets
- Page Breaks
- Setting Page Orientation
- Setting Margins
- Setting Headers and Footers
- Setting a Print Area
Print Titles
The Scale To Fit
Sheet Options
Previewing your Worksheet
Printing your Worksheet
Outcome
- Optimize work done with excel using techniques learned
- Improve productivity by introducing automation on excel
- Increase data literacy by using simple operations to perform data analysis
- Improve data quality by introducing accurate, systematic data syncing across multiple sheets
- Improve data analysing skills using advance techniques to be applied onto dataset
RM
699
HRDC Claimable
-
Certification
-
Real Case Application
Click Here
Please contact us for In-House Training