Brief Introduction
Learn Excel Intermediate from Microsoft Certified TrainerDescription
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
- Have attended Microsoft Excel – Foundation Level; OR
- Able to switch between task applications
- Able to create a spreadsheet with simple formatting
- Able to create a basic chart
- Able to print a spreadsheet with headers and footers added
- Able to apply Freeze Pane command
- Able to create basic formulas – Addition, Subtraction, Multiplication and Division
- Able to use basic functions – AutoSum, Count, Max, Min and Average functions.
Upon completion of this program, participants should be able to:
- Create simple to complex formulas and functions, like:
- COUNTIF Function
- AVERAGEIF Function
- SUMIF Function
- IF Function
- VLOOKUP Function
- Filter data using Auto Filters
- Create Chart
- Apply Conditional Formatting
Requirements
- Requirements
- You should be able to use Microsoft Excel at a beginner level
- A computer with Microsoft Excel software installed
Microsoft Power BI - Business Intelligence for Beginners
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Beginner Course on Power BI : Business Intelligence & Data/Business Analysis with Microsoft Power BI Do you want to build professional-quality Business Intelligence Reports from the ground up ?...
Power BI Master Class - Query Editor [2021 Edition]
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn how to import, transform and prepare data using the Query Editor in Microsoft Power BI Students who have taken this course have this to say:...
Excel in Microsoft Excel 2: Intermediate to Expert advanced
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Get Expert certified! Levels 6-10 for Microsoft Excel 2010, 2013, 2016 and Excel 2019. Covers 77-728, 77-427 & 77-428. How would that look on your resume?...
Microsoft Excel from Beginner to Advanced Level
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Mastering the Microsoft Excel Application for Productivity The Microsoft Excel course exposes students to all available tools, command and Functions in the application....
