Business Professionalism Archives

Microsoft PowerPoint | Intermediate and Advanced (MPPI&A)

Business Professionalism

This is the intermediate and advanced level of PowerPoint. Learning to implementing more advanced features of PowerPoint to visually enhance presentations and streamline slide shows.

Who should do this course?
It is intended for users that are already familiar with the basics of PowerPoint and wants to broaden their knowledge on the application. If will also focus on implementing slide shows and using slide masters to build presentations.

Pre-requisites
PowerPoint basic knowledge is required and we assume basic computer skills like working with a mouse and typing on a keyboard are in place.

Insert Smart Art diagrams.
Managing Smart Art diagrams.
Insert media like video and audio to enhance presentations.
Manage video and audio.
Work with web features in presentations like action buttons.
Apply background designs.
Insert and manage themes.
Insert special effects with animation.
Work with speaker notes.
Create and manage slide masters.
Use presenter view when delivering presentations.

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft PowerPoint | Basic (MPPB)

Business Professionalism

This is the elementary level of the PowerPoint course. It will focus on creating slides to build a presentation.

Who should do this course?
It is intended for first time PowerPoint users, or users with very little knowledge of the application. Anyone wanting to learn how to create and work with a presentation application to create professional-looking presentations.

Pre-requisites
No prior knowledge of PowerPoint is required. We assume that you are familiar with basic computer skills like working with a mouse and keyboard.

Understanding when to use PowerPoint.
Open and Close PowerPoint.
Navigate your way around PowerPoint.
Create, save and open presentations.
Creating and working with slides.
Manage the layout of slides.
Insert tables and charts.
Formatting slides.
Insert pictures, objects and images.
Edit pictures, objects and images.
Insert transition to enhance slide shows.
Running and navigating through a slide show.

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft Word | Advanced (MWA)

Business Professionalism

This is the advanced level of MS Word. It will focus on features to manage large documents and creating references as well as a table of contents.

Who should do this course?
Anyone who wants to enhance their knowledge of MS Word by learning the advanced features. It is also intended for users who want to use referencing to update automatically and in particular anyone who works with lengthy documents.

Pre-requisites
MS Word basic knowledge is required and we assume basic computer skills like working with a mouse and typing on a keyboard are in place. It would be beneficial if you have some knowledge of the MS Word intermediate level.

Create and work with Charts.
Create linked Charts that integrate with MS Excel.
Create and edit linked Tables.
Use integration between other Microsoft applications.
Collaborate files between different users using Track Changes and Comments.
Merge documents.
Working with Reference marks and notes like Footnotes and Endnotes.
Insert Captions and Cross-References.
Work with long documents and create an Index and Table of Contents.
Securing documents with protection features.
Creating forms.
Working with advanced layout features like different headers and footers on different pages.
Create and work with Mail Merge.

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft Word | Intermediate (MWI)

Business Professionalism

This is the intermediate level of MS Word. Learning to implementing more intermediate features of MS Word and also to visually enhance your data by creating tables and inserting images and styles.

Who should do this course?
It is intended for users that are already familiar with the basics of MS Word and wants to broaden their knowledge on the application up to an intermediate level.

Pre-requisites
MS Word basic knowledge is required and we assume basic computer skills like working with a mouse and typing on a keyboard are in place.

TBC

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft Word | Basic (MWB)

Business Professionalism

This is the elementary level of the Microsoft Word course. Learning to use a word processor application.

Who should do this course?
It is intended for first time MS Word users, or users with very little MS Word knowledge.

Anyone wanting to learn how to create and edit documents using a word processor application..

Pre-requisites
No prior knowledge of MS Word is required. We assume that you are familiar with basic computer skills like working with a mouse and keyboard.

Create and use templates.
Insert pictures and shapes.
Insert Word Art.
Edit images.
Work with Smart Art and special characters.
Edit Smart Art.
Create tables.
Managing rows, columns and cells.
Visually enhance tables.
Create basic calculations in a table.
Working with Styles.
Managing Styles.

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft PowerBi (MPBi)

Business Professionalism

It is intended for users to master how to use the Power BI application to build reports through visuals. The course will focus on connecting to data and creating reports using the Power BI Desktop application.

Who should do this course?
Anyone who wants to gain knowledge of Microsoft Power BI by learning to connect to data files and using the data to build reports using various visuals and then Publish it to Power BI Service.

Pre-requisites
No prior knowledge of Microsoft Power BI is required. It would be beneficial if you have some knowledge of Excel intermediate in place.

Introduction to Microsoft Power BI.
Understand the elements of Microsoft Power BI.
Using the Microsoft Power BI Desktop element.
Connect to data.
Transform data using the Power Query Editor.
Changing data types.
Find and replace data and errors.
Using Split on columns.
Refresh data from the source.
Understanding basic DAX calculations.
Understanding how to model data through relationships.
Inserting visuals to build a report.
Formatting visuals.
Insert and manage report pages.
Sorting information within visuals.
Apply conditional formatting on visuals.
Manage a visual’s aggregation.
Using the highlight feature on visuals.
Manage how visuals interact.
Using focus mode.
Understanding and using various filter options.
Insert text boxes.
Inserting and managing themes.
Introduction to Power BI Service.
Publish a report to Service.
Navigate around Power BI Service.
Create a dashboard in Power BI Service.
Share a report.

Learning Methodologies:

Duration:
2 Days

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft Outlook (MO)

Business Professionalism

The course will focus on features of creating, sending and managing e-mails using Microsoft Outlook.

Who should do this course?
Anyone who wants to enhance their knowledge of Microsoft Outlook by learning how to create and send e-mails together with message management.

Pre-requisites
We assume basic computer skills like working with a mouse and typing on a keyboard are in place. It would be beneficial if you have some knowledge of the Introduction to Computers course in place.

Introduction to Microsoft Outlook.
Using the Mail element.
Create and send messages.
Receive and manage messages with reply, reply to all and forward.
Deleting messages.
Create folders to organise messages.
Marking and flagging messages.
Create and use a signature.
Using the Calendar element to create appointments.
Responding to appointments.
Deleting appointments.
Using the Contacts element.
Create and edit contacts.
Share and delete contacts.
Create a contact group.

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft Excel | Intermediate (MEI)

Business Professionalism

This is the elementary level of the Excel course. It focuses on using a spreadsheet application.

Who should do this course?
It is intended for users that are already familiar with the basics of Excel and wants to broaden their knowledge on the application up to an intermediate level. Users that want to organise their data in a more professional way, visually present it in a chart and also make use of more intermediate functions and formulate.

Pre-requisites
Excel basic knowledge is required and we assume basic computer skills like working with a mouse and typing on a keyboard are in place.

Prepare and produce a spreadsheet to provide a solution to a given problem.
Adjust settings to customise the view and preferences of the spreadsheet application for large sheets.
Sort and filter data for better organisation.
Create and edit charts to enhance readability of data.
Visually enhance a spreadsheet using sparklines.
Apply automatic formatting to a spreadsheet applicable to the given problem.
Create and manage more intermediate functions and formula, like IF and Vlookup to provide solutions.
Create and work with named ranges to streamline calculations.
Creating and managing comments in a worksheet,

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft Excel | Advanced (MEA)

Business Professionalism

This is the advanced level of Excel. It will focus on features to manage large sets of data by creating analysed reports, advanced filters and automating tasks with macros.

Who should do this course?
Anyone who wants to enhance their knowledge of Excel by learning the advanced features like reporting and comparing large sets of data with PivotTables. It is also intended for users who want to automate tasks learning about macros among other advanced features.

Pre-requisites
Excel basic knowledge is required and we assume basic computer skills like working with a mouse and typing on a keyboard are in place. It would be beneficial if you have some knowledge of the Excel intermediate level.

Create an outline of your data.
Calculate subtotals on data sets.
Consolidating and linking data within spreadsheets.
Applying advanced filters and use forms in a spreadsheet.
Importing and exporting text files.
Creating and using macros.
Combining and comparing large sets of data in a spreadsheet by using PivotTables.
Create drop-down lists.
Protecting information of workbooks and spreadsheets.
Collaborating and sharing spreadsheets by using tracking features.

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft Excel | Basic (MEB)

Business Professionalism

This is the elementary level of the Excel course. It focuses on using a spreadsheet application.

Who should do this course? It is intended for first time Excel users, or users with very little Excel knowledge. Anyone wanting to learn how to create and work with an Excel spreadsheet and create basic calculations. Pre-requisites No prior knowledge of Excel is required. We assume that you are familiar with basic computer skills like working with a mouse and keyboard.

Understanding when to use Excel and the benefits thereof.
Create, open and save spreadsheets.
Finding your way around Excel.
Entering data in a spreadsheet.
Manipulating data.
Formatting data.
Working with sheets.
Formatting rows and columns.
Create and use basic functions and formulae.
Check spelling in a spreadsheet.
Managing the page setup and printing.

Duration:
1 Day

Learning Methodologies:

*Pricing available upon request.

Contact training@dev.metrominds.co.za
for group pricing

Microsoft PowerPoint | Intermediate and Advanced (MPPI&A)

Business Professionalism

Microsoft PowerPoint | Basic (MPPB)

Business Professionalism

Microsoft Word | Advanced (MWA)

Business Professionalism

Microsoft Word | Intermediate (MWI)

Business Professionalism

Microsoft Word | Basic (MWB)

Business Professionalism

Microsoft PowerBi (MPBi)

Business Professionalism

Microsoft Outlook (MO)

Business Professionalism

Microsoft Excel | Intermediate (MEI)

Business Professionalism

Microsoft Excel | Advanced (MEA)

Business Professionalism

Microsoft Excel | Basic (MEB)

Business Professionalism

Apply Now

nEed more Info