Microsoft Excel
Microsoft Excel Level 1
Prerequisites
This course is tailored towards learners who have never used Excel before. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Course Description
This course is designed to give learners the ability to use Microsoft Excel to create a simple workbook, and learn the basics in editing, formatting and creating simple formulas. This course also teaches the learners how to use tables and print workbooks. Lastly, they will also learn how to insert pictures and diagrams.
Available Versions
2010, 2013, 2016, 2019, Office 365
Course Duration
8 hours
Course Topics
Learn the interface and basic tasks
Enter and edit data using different techniques
Format text, numbers and cells
Write basic formula and basic functions
Proofread workbooks
Present data using tables
Explore print options
Insert illustrations and graphics
Microsoft Excel Level 2
Prerequisites
This course assumes basic understanding in the use of Excel. Learners attending this training must know how to write basic functions and formulas in Excel. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Course Description
This course is designed to give learners the ability to use Data tools such as Sort, Filter, Subtotal, and others. They will also learn how to conditionally format cells and insert pivot table. They will also learn how to insert hyperlinks, construct Text, Data and Time functions, and customize the worksheet view.
Available Versions
2010, 2013, 2016, 2019, Offic
e 365
Course Duration
8 Hours
Course Topics
Insert charts and Sparkline
Create reports using pivot tables
Format cells using criteria and formulae
Prepare Excel data using Data Tools
Work with Excel Data using Sort and Filter commands
Summarize lists using Subtotal
Learn practical Text, Date & Time and Logical functions
Audit formulas
Insert hyperlinks
Customize the view
Microsoft Excel Level 3
Prerequisites
This course is tailored towards more proficient users those who are well versed in formula construction. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Course Description
This course is designed to give learners the ability to use cell names and use more advanced functions such as IF, Vlookup, Hlookup and Database functions. The learners will also know how to protect worksheets and workbooks, review and share workbooks and record basic macros. Lastly, they will also learn What-If Analysis commands.
Available Versions
2010, 2013, 2016, 2019, Office 365
Course Duration
8 hours
Course Topics
Use cell names and use them in formulas
Working with Links
Learn IF function
Learn Vlookup and Hlookup functions
Learn Database functions
Protect worksheets and workbooks
Review and Share workbooks
Record basic macros
Use What-If Analysis
Microsoft Excel Data Analysis with Power Pivot
Prerequisites
This course assumes proficient level in the use of Excel. Learners attending this training must know how to write complex formulas and use Pivot table in Excel.
Course Description
This course is aims to introduce Microsoft Excel Power Pivot, a data analysis tool used to create data models, establish relationships and create calculations. In the course, learners will work with large data sets, build extensive relationships and create simple to complex calculations all within the familiar experience of Excel.
Available Versions
2013-2019, Office 365
Course Duration
16 hours
Course Topics
What is Power Pivot?
- Know the difference between Pivot table and Power Pivot; Enable and navigate Power Pivot
The Data Source
- Import different data sources from MS Access database, Text files, or from another MS Excel workbook
Building the Data Model
- Understand the different terminologies related to databases; Manage data relationships; create a Pivot table using the Data Model
Pivot table from Power Pivot fields
- Customizing Pivot tables using PowerPivot fields and Pivot table options; Filtering using Slicers
Calculations using commonly used Data Analysis Expressions (DAX)
- Calculating using the different operators, functions of DAX
Visualizing Power Pivot Data
- Creating Pivot Charts, customizing it and use Slicers to make interactive presentation of the data
Create KPI in Power Pivot
- Create Key Performance Indicator and work with Dates and times in Power Pivot
Microsoft Excel Macro Programming Introduction
Prerequisites
This course is tailored towards more proficient and advanced users of Excel. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Course Description
This course is designed to give learners the ability to use work with basic macros. This course will teach the target learners the basic of programming macros in Visual Basic Editor. They will also learn the different control structures, interactive dialog boxes and debugging techniques.
Available Versions
2010, 2013, 2016, 2019, Office365
Course Duration
8 hours
Course Topics
Getting Started with Excel Macros
- Getting Started with Excel Macros
- Change the Macro Security
- Recording Macros
- Run Macros Using the Macros Dialog Box
- Viewing Macro Codes
- Assigning macros to Form Control button
- Adding macro commands to Quick Access Toolbar
- Delete Macro from the Worksheet
- Delete a Macro from the Personal Macro Workbook
Using Visual Basic Editor
- Activate the Visual Basic Editor
- Parts of VBE
- Set Properties of a Project
- Set the display options of the Code Window
- Comments
- Modules
- Add Modules
- Rename Modules
- Delete Modules
- Procedure
- Function
- Variables
- Constants
Interactive Dialog Boxes
- Message Box
- Input Box
- Determine the Dialog Box Type
- MsgBox Function
- vbCrLf character
- The Code Continuation Character
Protecting Macros
- Hiding Macros
- Lock Macros for Viewing
Debugging Macros
- Breakpoint
- Step Into tool
- Step Out Tool
- Resume Macro Execution