Description

Microsoft Excel is a software for storing numerical data and analyzing them. It is one of the most flexible and commonly used applications in Office. Whatever career path you choose, you will probably have to use Excel to achieve your professional goals, some of which may happen every day. For one way or the other, we all work with numbers. When we want to record, analysis and save such numeric data, Microsoft Excel comes in handy. At this basic level, it provides strong understanding what is Data Type and proper formatting to present the data effectively.

Learning Outcome and Goals

• Describe Excel Data thoroughly to prevent common mistake in Excel Reports!
• Select and modify cells, columns, and rows confidently.
• Manage multiple worksheets with ease.
• Understand the used of Cell Reference techniques
• Write some basic formula and functions.

Course Requirement

• Participants should be able to use a PC at the beginner level.
• Microsoft Office 2013 and above

Course Information

Course Outline

Getting Started with Excel

• Cell Referencing System
• Entering Numbers and Text
• Default Text and Number Alignment
• Summing a Column of Numbers
• Entering a Date

Excel Selection Techniques

• Selecting a Cell
• Selecting the Entire Worksheet
• Selecting a Row & a Column

Manipulating Rows and Columns within Excel

• Inserting Rows into a Worksheet
• Inserting Columns into a Worksheet
• Automatically Resizing the Column Width to Fit Contents

Manipulating Cells and Cell Content within Excel

• Editing Cell Content
• Undo and Redo
• AutoFill
• Searching and Replacing Data

Number Formatting within Excel

• Number Formatting
• Decimal Point Display
• Applying and Removing Comma Style Formatting (To Indicate Thousands)
• Currency Symbol
• Date Styles
• Percentages

Alignment Formatting within Excel

• Centring a Title over a Cell Range
• Cell Orientation
• Text Wrapping within a Cell
• Aligning Cell Contents Vertically
• Format Painter

Excel Worksheets

• Switching between Worksheets
• Renaming a Worksheet
• Copying or Moving Worksheets between Workbooks

Freezing Row and Column Titles

• Freezing Row and Column Titles

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

Excel Functions

• What Are Functions?
• Common Functions
• Sum Function
• Average Function
• Max Function
• Min Function
• Count Function
• The Counta Function
• The CountBlank Function