Microsoft Excel Beginner
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 beginner level, it shares the fundamental features in Microsoft Excel. Besides that, it provides methods on how to work with different type of data in Microsoft Excel. It also enhances Microsoft Excel report with charts for better visualization.
Learning Outcome and Goals
Course Requirement:
Duration:
Course Outline
- Excel cell referencing System
- Default Text and Number alignment
- Sum a column of numbers
- Date entry
- Create, open and save Workbook
- Font formatting – font size, font type
- Bold, Italic and Underline
- Cell border formatting
- Font and background colour formatting
- Select connecting and non-connecting cells
- Select connecting and non-connecting columns
- Select connecting and non-connecting rows
- Cell content alignment
- Cell orientation
- Text wrapping
- Format Painter
- Insert rows and columns
- Delete rows and columns
- Resize column width and height
- Date Formatting
- Copy, edit and delete Cell Content
- Undo and Redo
- Move data between worksheet in within and between workbook
- Autofill
- Cell sorting
- Search and replace data
- Decimal point display
- Thousand separators
- Currency symbol
- Percentages
- Insert worksheet
- Rename worksheet
- Delete worksheet
- Copy and move worksheet within and between workbook
- Freeze row title
- Freeze column title
- Insert, resize and delete different types of charts
- Modify chart component
Microsoft Excel Intermediate
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 intermediary level, it provides an overview of the Excel forms and features used every day for preparing reports and analytics for our managers.
Learning Outcome and Goals
Course Requirement:
Duration:
Course Outline
- Apply styles to a range
- Conditional formatting
- Custom number formats
- VLOOKUP function
- HLOOKUP function
- Remove a named range
- Named cell ranges and functions
- Nested functions
- Consolidating data using a 3-D reference sum function
- Mixed references within formulas
- COUNT function
- COUNTA function
- COUNTIF function
- COUNTBLANK function
- DSUM function
- DAVERAGE function
- DMAX function
- DMIN function
- DCOUNT function
- LEFT function
- RIGHT function
- MID function
- TRIM function
- CONCATENATE function
- Use Paste Special to add, subtract, multiply & divide
- Use Paste Special ‘Values’
- Use Paste Special Transpose Option
- Inserting the current time and date
- TODAY function
- WORKDAY function
- NETWORKDAYS function
- Copy or move worksheets between workbooks
- Split a window
- Hide & unhide rows / columns
- Hide & unhide worksheets
- IF function
- AND function
- OR function
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and footers
- Scaling worksheet to fit a page(s)
- Printing titles on every page
- Previewing worksheet
Microsoft Excel Advanced
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 advanced level, it provides ways to validate user input which helps in analyzing the Excel data. Besides that, it shares how to perform automation in Excel and also the ways to secures the data in Microsoft Excel
Learning Outcome and Goals
Course Requirement:
Duration:
Course Outline
- Sort data by multiple columns at the same time
- Apply a pre-installed custom sort
- Create a customized list and performing custom sort
- Sub-Total
- Using AutoFilter
- Advanced filter criteria
- One-input data tables
- Two-input data tables
- Data validation – whole number
- Data validation – decimal number
- Data validation – list
- Data validation – text length
- Customizing validation input message and error alert
- Scenario manager
- Scenario summary reports
- Trace precedent cells
- Trace dependent cells
- Show formulas in worksheet
- Insert and view comments
- Record an Excel Macro
- Link data within a worksheet
- Link cells between worksheet within a workbook
- Link data between workbook
- Link data from Excel to a word document
- Password protecting cells and worksheets
- Hiding and un-hiding formulas
Contact Information
+60 17-282 8183
P37, Kelana Square,
Jalan SS7/26, Kelana Jaya,
47301 Petaling Jaya, Selangor.
