Microsoft Excel 2016 Training Objective:
Excel is one of the most commonly used administrative tool nowadays. Given its advantage of being able to manipulate and present data in an orderly manner, it is one of the basic software that people use nowadays. It has helped many users reduce unnecessary work with the aid of its functions and formulas. Being well versed in Excel will be a useful skill for the working adults.Our hands-on Excel courses focus on helping participants understand the interface and various features of Excel.
Curriculum covered in Excel 2016 Courses
Introduction to Excel 2016
- Introduction
- Excel 2016 Interface
Basic of Spreadsheet
- Open/Save/Create a new spreadsheet
- Moving around Workbook and Worksheet
- Key in different kind of data
- Editing and Removing data
- Autocorrect
- Flashfill and Autofill
- Drag and Drop
- Find and Replace
Edit Formatting of Spreadsheet
- Change Styles
- Themes
- Font Options: Underline, Bold, Italic
- Number
- Format Painter
- Alignment
Printing Setting
- Edit Print Properties
- Include Page Breaks
- Print Preview: Layout and Break
- Different Output
Computations and Formulas
- Simple Mathematical Calculation
- Making use of AutoSum Functions - Addition, Average, Min, Max
- Using Operators - Addition, Subtraction, Multiplication ,Division ,Percentage.
- Auto Calculate
- Basic Formulas
Window Setting
- Different Views
- Multi Windows functions (Split/Freeze/Windows)
- Organise windows
Data Arrangement
- Using Sorting Option - Ascending ,Descending, Alphabetically, Custom
- Criteria - Contains, equal to, less than
- Grouping and Subtotals
- Filtering- AutoFilter ,Filter by Colour Coding and Text Filters
- Custom Filter
Data Evaluation
- Understand Formatting
- Conditional Formatting
Data Manipulation
- Data Validation
- Construct Data Validation Rules
- Use a formula to Validate Data Entries
- Use Database Functions
- Construct Criteria Range
- Database Function
Reporting
Using Charts
- Introduction to Chart Design and Creation
- Simple Editing of Charts
- Moving and Changing size
- Changing Colour
- Edit Data
- Charts
- Edit Chart title, legend, labels
- Data Management
- Producing a Combination Cchart
Pivot Table and Pivot Charts
- Preparing Data to make a Pivot Table
- Construct Pivot Table
- Choosing Fields and Classifying Data
- Pivot Table Tool Tab Analysis
- Changing the displayed data and refreshing the Pivot Table
- Pivot Table Styles
- Present a Pivot Chart from a Pivot Table
- Producing a Pivot Chart from data
Formulas
- IF Statement- SUMIF, COUNTIF, IF, AND, OR
Advanced Functions
- Name Range
- Absolute Cell Referencing
- VLOOKUP Formula
- HLOOKUP Formula
- Array Formula
- Index and Match
- Nested IF
- CONCATENATE
- Transpose
Extra Tools
- Paste Unique
- Functioning with Sheets
- Hide or Show Comments
- Hyperlinks
- Worksheet with Password Security Protection
- Finding duplicates data
Macros
- Changing on the developer cursor
- Building Macro
- Editing Marco security setting
- Recording and Implementing Macro
Workbooks
- Joining Workbooks
- Several Workbook
- Sharing a Workbook and Monitor changes made
- Executing with extra data
- Using Formula to join Workbooks
Worksheets
- Several Worksheets
- Managing across worksheet
- Building 3-D Formulas
- Making use of Paste Link Feature
- Managing Link Updates
- Resolving Broken Links
Advanced Charting
- Create advanced graph and charts to enhance your excel report
- Sparkline
- Creation of Pivot Table and Pivot Charts (Complicated)
Case Study Investigation
Types of Cases
- Creating Case Studies
- Desired Outcome
- Given Data
Solutions
- Solver Range
- Cell Constraints/Reference
Doing Reports and Examinations
- Finding Precedent and Dependent Cells
- Showing Formulas uses in the Worksheet
- Including ,Showing ,Changing and Deleting Comments
- Finding Formula Mistakes
- Making us of Trace Error Features
- Perform Error Checks
- Analysing Formulas
Please email admin@mocdstudio.com for training schedules.
International Plaza – Beside Tanjong Pagar
Please take note that:
- We can arrange a close class if your company have a minimum of 6 participants.
- All payments are accepted using only Singapore dollars, and are non-exchangeable or non refundable for other items.