• +60 11-1088 8118
  • Mon - Fri 9am - 6pm

Microsoft Excel Foundation

About Microsoft Excel Foundation

Course Duration

2 Days

Who Should Attend This Course?

No pre-requisite required

What Will You Learn?

At the completion of the training, candidates will be able to:
  • Use Microsoft Excel’s selection techniques
  • Manipulate rows and columns within Microsoft Excel
  • Manipulate cells and cell content within Microsoft Excel
  • Perform Sorting
  • Format Font within Microsoft Excel
  • Perform Alignment formatting within Microsoft Excel
  • Perform Number formatting within Microsoft Excel
  • Freeze row and column titles within Microsoft Excel
  • Use Microsoft Excel formulas
  • Use Microsoft Excel functions
  • Create Microsoft Excel charts
  • Customize Microsoft Excel

Programme Outline

GETTING STARTED WITH MICROSOFT EXCEL
  • Starting Excel
  • Selecting the blank worksheet template
  • The Excel cell referencing system
  • Entering numbers and text
  • Default text and number alignment
  • Summing a column of numbers
  • Entering a date
  • Worksheets and workbooks
  • Saving a workbook to your hard disk
  • Closing a workbook
  • Creating a new workbook
  • Opening a workbook
  • Switching between workbooks
  • Saving a workbook using another name
  • Saving a workbook using a different file type
  • Getting help within Excel
  • Searching for online help
  • Alt key help
MICROSOFT EXCEL SELECTION TECHNIQUES
  • Why are selection techniques important?
  • Selecting a cell
  • Selecting a range of connecting cells
  • Selecting a range of non-connecting cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of connecting rows
  • Selecting a range of non-connected rows
  • Selecting a column
  • Selecting a range of connecting columns
  • Selecting a range of non-connecting columns
  • Recommended techniques when creating or editing lists
MANIPULATING ROWS AND COLUMNS WITHIN MICROSOFT EXCEL
  • Inserting rows into a worksheet
  • Inserting columns into a worksheet
  • Deleting rows within a worksheet
  • Deleting columns within a worksheet
  • Modifying column widths
  • Modifying column widths using ‘drag and drop’
  • Automatically resizing the column width to fit contents
  • Modifying row heights
MANIPULATING CELLS AND CELL CONTENT WITHIN MICROSOFT EXCEL
  • Copying a cell or range contents within a workbook
  • Deleting cell contents
  • Moving the contents of a cell or range within a workbook
  • Editing cell content
  • Undo and redo
  • Copying data between worksheets (within the same workbook)
  • Moving data between worksheets (within the same workbook)
  • Moving data worksheets (between different workbooks)
  • Copying data between worksheets (in different workbooks)
  • AutoFill
  • Copying a data range using AutoFill
SORTING A CELL RANGE
  • Searching and replacing data
MICROSOFT EXCEL WORKSHEETS
  • Switching between worksheets
  • Renaming a worksheet
  • Recommended techniques with naming worksheets
  • Inserting a new worksheet
  • Deleting a worksheet
  • Copying a worksheet within a workbook
  • Moving a worksheet within a workbook
  • Copying or moving worksheets between workbooks
FONT FORMATTING WITHIN MICROSOFT EXCEL
  • Font formatting options
  • Font type
  • Font size
  • Bold, italic, underline formatting
  • Cell border formatting
  • Formatting the background colour
  • Formatting the font colour
ALIGNMENT FORMATTING WITHIN MICROSOFT EXCEL
  • Horizontally aligning contents in a cell range
  • Centering a title over a cell range
  • Cell orientation
  • Text wrapping within a cell
  • Aligning cell contents vertically
  • Format painter
NUMBER FORMATTING WITHIN MICROSOFT EXCEL
  • Number formatting
  • Decimal point display
  • Applying and removing comma style formatting (to indicate thousands)
  • Currency symbol
  • Date styles
  • Percentages
FREEZING ROW AND COLUMN TITLES WITHIN MICROSOFT EXCEL
  • Freezing row and column titles
MICROSOFT EXCEL FORMULAS
  • Creating formulas
  • The easy way to create formulas
  • Copying formulas
  • Operators
  • Using operators in formulas
  • Formula error messages
  • Relative cell referencing within formulas
  • Absolute cell referencing within formulas
MICROSOFT EXCEL FUNCTIONS
  • What are functions?
  • Common functions
  • Sum function
  • Average function
  • Max function
  • Min function
  • Count function
  • The counta function
  • The countblank function
  • What are ‘if functions’?
  • Using the if function
MICROSOFT EXCEL CHARTS
  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Chart title or labels
  • Changing the column, bar, line or pie slice colours in a chart
  • Modifying the legend fill colour
  • Changing the chart type
  • Modifying charts using the design tab
  • Modifying the chart title
  • Modifying the chart axis
  • Modifying the chart legend
  • Modifying chart data labels
  • Displaying chart data tables
  • Modifying chart gridlines
  • Copying and moving charts within a worksheet
  • Copying and moving charts between worksheets
  • Copying and moving charts between workbooks
CUSTOMIZING MICROSOFT EXCEL
  • Modifying basic Excel options”

Trainer

SENTHIVALU KRISHNASAMY

Certified Assessor for Skills Training under “Jabatan Pembangunan Kemahiran” (JPK), Ministry of Human Resources, Malaysia

About Us

Elev8 Asia Sdn Bhd is a HRDF Certified Training Provider in Malaysia which founded in year 2015.

Services

  • Corporate Training
  • Competency Assessment
  • e-Learning
  • Platform Development

Help

© Copyright 2020 Elev8 asia sdn bhd - All Rights Reserved