Microsoft Excel (Basic 每 Intermediate)
| Previous | 4 / 10 | Next |
This is 2-Day beginner and intermediate level of Microsoft Excel training suitable for beginners and people with some experience in using Microsoft Excel. You will learn how to get more out of Microsoft Excel to make the best use of the software in your daily work. Improve your productivity and efficiency with new time saving features in Excel 2019
Objective:
At the end of the training, participants are able to:
Objective:
At the end of the training, participants are able to:
- Create, modify and format worksheets
- Perform basic calculations and functions
- Mange worksheet and workbook
- Organize a database list by sorting and filtering
- Create, modify and format Charts
- Consolidate data and link cells in different workbooks
- Protect worksheet and workbook
Outline:
-
Chapter 1: Getting Started with Excel
- Explore the user interface and the ribbon
- Navigate withing the worksheet
- Selecting a cell or range of cells
- Entering cell contents
- Cutting, Copying, and Pasting Cell values
- Copy and Paste Special
- Saving and Opening your workbook
-
Chapter 2 : Managing Rows and Column
- Inserting, moving and deleting cells
- Managing columns and rows
- Hide and unhide rows and columns
- Changing column width and row height
-
Chapter 3 : Managing Worksheets
- Format worksheet tabs
- Insert and Delete Worksheet
- Move and Copy worksheet
- Hide and Unhide Worksheet
-
Chapter 4: Formatting Cells
- Formatting the cell
- Number and Date Formatting
- Finding and replacing text
- Working with styles
-
Chapter 5 : Working with Formulas & Functions
- Excel Arithmetic Operators & Order of Operations
- Create Basic Formulas
- Calculate with commonly used Functions
- Copy Formulas and Functions
-
Chapter 6 : Organizing Worksheet
- Create, modify and format tables
- Sorting and filtering table data
- Use functions to calculate data in table
- Apply Conditional Formatting
-
Chapter 7 : Working with Charts
- Presenting data visually using charts
- Variety ways to create a Chart
- Format Chart Legend and Titles
- Saving the Chart as a Template
- Creating Column, Line and Pie Charts
-
Chapter 8 : Working with Graphics
- Adding Pictures into a worksheet
- Customizing Pictures and Objects
- Adding Drawing Objects into a worksheet
- Adding SmartArt into a worksheet
-
Chapter 9: Printing Workbook Contents
- Printing Contents Using Default Print Options
- Setting Print Options
- Setting Page Breaks
-
Chapter 10: Customizing and Enhancing Workbooks
- Customizing excel environment
- Creating hyperlinks
- Working with templates
- Create your own templates
-
Chapter 11: Working with Multiple Workbooks
- Linking to others workbook
- Consolidating multiple sets of data
- Consolidate multiple worksheets
-
Chapter 12: Protecting Your Workbook and Worksheet
- File Level Protection
- Worksheet Level Protection
- Workbook Level Protection
Duration:
2 days (14 hours)
Target Audience:
This course is aimed at beginner Excel users who want to understand the basic concepts of Excel and want to improve Excel skills in their workplace.
Methodology:
Demonstration, practical learning, case discussion and exercises
Prerequisite(s) or equivalent knowledge:
Basic knowledge of computers, using the keyboard, mouse and windows is required.