MS Excel
MS Excel is a generally used Microsoft Office application. It is a spreadsheet application that is used to store and analyze numerical data.
Online/Offline
class available
All
Skill Level
30:45 hours
Duration
English
Language
MS Excel Course Outline
1. Using Excel
• The Excel Cell Referencing System
• Entering Numbers and Text
• Entering a Date
• Worksheets and Workbooks
• Creating and Saving a New Workbook
• Opening a Workbook
• Switching between Workbooks / sheets
2. Manipulating Cells and Cell Content
• Selecting a Cell, cell range, row & column.
• Inserting Rows & Columns
• Deleting Rows& Columns
• Column Widths
• Row Heights
• AutoFill
• Searching and Replacing
3. Manipulating Worksheets
• Renaming a Worksheet
• Inserting a New Worksheet
• Deleting a Worksheet
• Copying and moving a Worksheet
• Freezing Row and Column Titles
• Splitting window
• Hiding Rows, Columns & Worksheets.
4. Formatting
• Font Type, size, style, background, colour etc.
• Aligning cell contents
• Cell Orientation, wrapping, merge etc.
• Format Painter
• Number Formatting – decimal, symbol, % etc.
5. Formulas
• Creating Formulas
• Copying Formulas
• Using Operators inFormulas
• Relative Cell Referencing
• Absolute Cell Referencing
6. Functions
• Sum Function
• Average Function
• Min, Max Functions
• Count Function
• The Counta Function
• The Countblank Function
• Using the If Function
• LEFT, RIGHT, MID, TRIM, CONCATENATE
7. Customising Excel
• Customising the Ribbon
• Customising Quick Access Tool Bar
• Minimising the Ribbon
• Autocorrect Options
8. Setup & Printing Issues
• Worksheet Page setup- Margins, fit to page etc.
• Headers and Footers
• Scaling Your Worksheet to Fit a Page(s)
• Printing Titles On Every Page
• Printing the Row and Column Headings
• Printing Options
9. Time & Date Functions
• TODAY.
• NOW.
• DAY.
• MONTH.
• YEAR.
10. Mathematical Functions
• ROUND.
• ROUNDDOWN.
• ROUNDUP.
11. Financial Functions
• FV.
• PV.
• NPV.
• RATE.
• PMT.
12. Lookup Functions
• VLOOKUP.
• HLOOKUP.
13. Named Ranges
• Naming Cell Ranges.
• Removing a Named Range.
• Using Named Range in a formula / functions
14. Cell Formatting
• Applying Styles to a Range.
• Conditional Formatting.
• Custom Number Formats.
15. Paste Special Options
• Using Paste Special to Add, Subtract, Multiply & Divide.
• Using Paste Special ‘Values’.
• Using Paste Special Transpose Option.
16. Pivot Tables
• Using a Pivot Table.
• Filtering and SortingData
• Grouping Data
• Slicers
17. Charts
• Inserting different chart types.
• Resizing and deleting a Chart
• Chart Title or Labels
• Formatting the Chart Area
• Spark Line Chars
18. Hyperlinks, Linking & Embedding
• Inserting a Hyperlink.
• Editing a Hyperlink
• Removing a Hyperlink
• Linking Cells between Worksheets within a Workbook.
19. Importing Text Files
• Importing a Delimited Text File.
20. Sorting and Filtering Data
• Sorting Data by Multiple Columns
• Custom Sorts
• Customized List
• AutoFilter.
• Advanced Filter Criteria.
• Sub-Totaling.
21. Validating
• Setting data validation for the cells
• Validation Input Message and Error Alert.
• Removing Data Validation.
22. Auditing
• Tracing Precedent Cells.
• Tracing Dependent Cells.
• Identifying Cells with Missing Dependents.
• Showing All Formulas in a Worksheet.
• Comments.
23. Macros
• Using Macros
• Assigning a Macro to aButton
• Deleting Macros.
24. Passwords & Security Issues
• Password Protection.
• Password Protecting Cells and Worksheets.
• Hiding Formulas.
• Un-Hiding Formulas.
25. Shortcuts • Trying out around 30 productive shortcuts in Excel