DESKTOP EXCELLENCE

Back to programs

MICROSOFT Office Word

1) MICROSOFT Office Word – Foundation

Duration: 1 day

INTRODUCTION:

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and want to further enhance their knowledge and practical uses of Microsoft Word.

HOW WILL YOU BENEFIT:

• Getting Started
• Editing the Documents
• Moving and Copying Text
• Formatting Characters and Paragraphs
• Creating and Managing Tables
• Controlling Page Layout
• Using Proofing Tools

 

2) MICROSOFT Office Word – Intermediate –SBL Khas

Duration: 1 day

INTRODUCTION:

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and want to further enhance their knowledge and practical uses of Microsoft Word.

HOW WILL YOU BENEFIT:

Upon completion of this program, participants should be able to:

• Convert the document to Word 2013 format
• Apply & Modify Multilevel List
• Insert a Section Break
• Apply different Header and Footer
• Perform Mail Merge using the Wizard
• Add Watermark to a Document

3) MICROSOFT Office Word – Advance –SBL Khas

Duration: 1 day

INTRODUCTION:

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and want to further enhance their knowledge and practical uses of Microsoft Word.

HOW WILL YOU BENEFIT:

Upon completion of this program, participants should be able to:

• Work with Graphics, WordArt, SmartArt & Graph
• Insert Screenshot and Screen Shots
• Apply Artistic Effects to graphics
• Apply Text Wrapping to within a Word Document
• Repeat The Table Headings for Multiple-Page Tables
• Manipulating Styles in a Word 2013
• Create Tables of Contents
• Compiling and Updating An Index

 

MICROSOFT Office Excel

4) MICROSOFT Office Excel – Foundation-SBL Khas & Popular

INTRODUCTION:

This course is intended for participants who wish to gain the foundational understanding of Microsoft Excel that is necessary to create and work with electronic spreadsheets.

PREREQUISITES:

Basic knowledge of Windows is essential with the following pre-requisites:

• Able to maneuver with the mouse – Point, Click, Drag and Double Click
• Able to use the Control Panel
• Able to move and re-size Application Windows
• Able to switch between task applications

HOW WILL YOU BENEFIT:

Upon completion of this program, participants should be able to:

• Create Excel Worksheet such like
• Creating and Designing Invoice, Purchase Order and other Corporate templates
• Work with formulas
• Create own Template
• Set printing reports with current date with Header Footer.
• Manage Worksheet and Workbook

 

5) MICROSOFT Office Excel  – Intermediate –SBL Khas & Popular

INTRODUCTION:

This course is intended for participants who wish to gain more knowledge from the foundation level of Excel.  For participants who are working with lots of formulas and creates report to understand the necessary technique on how an electronic spreadsheet works.

PREREQUISITES:

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 use Auto Filter command
• 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.

HOW WILL YOU BENEFIT:

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 and IFERROR Function
• Filter data using Auto & Advanced Filters
• Advanced Chart Formatting
• Clean Duplicate Records

 

6) MICROSOFT Office Excel  – Advance –SBL Khas & Popular

INTRODUCTION:

This course is intended for participants who wish to gain more knowledge from the intermediate level of Excel.  For participants who are working with nested formulas, perforMicrosoft what if analysis, consolidating data and creates Pivot Table to have in depth understanding of how an electronic spreadsheet works.

PREREQUISITES:

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

• Have attended Microsoft Excel – Foundation & Intermediate Level; OR
• Able to switch between task applications
• Able to create simple to complex formulas and functions, like:
• COUNTA, COUNTIF & COUNTIFS Function
• AVERAGEA, AVERAGEIF & AVERAGEIFS Function
• SUMIF & SUMIFS Function
• IF Functions
• Nested Functions
• Database Function
• Able to validate data in a Worksheet
• Able to apply Filter data using Auto & Advanced Filters
• Able to clean Duplicate Records

HOW WILL YOU BENEFIT:

Upon completion of this program, participants should be able to:

• Create Subtotal Using The Subtotal Function
• Analyze data Using Pivot Tables
• Perform What If Analysis using:
• Goal Seek
• Solver
• Input Table
• Scenarios
• Use VLOOKUP function to extract data
• Nesting INDEX and MATCH Function
• Combining & Consolidating Data
• Record and Run a Macro

 

7) MICROSOFT Excel Advanced Conditional Formatting (new)

Duration: 1 day

INTRODUCTION:

When you see conditional formatting in Excel for the first time, you are amazed, to put it mildly if Excel formatting makes your spreadsheets visually pleasant, conditional formatting in Excel makes them infinitely more powerful and useful In this easy-to-follow Excel course, you will not only learn the basics of conditional formatting  in  Excel,  but  also  become  comfortable  with  more advanced conditional formatting techniques, such as conditional formatting  based on text, conditional formatting based on another cell, conditional formatting based on a date, or on a range of dates, as well as conditional formatting with formulas, range-based conditional formatting rules and more This Excel conditional formatting course will quickly build your Excel skills It will serve you well as an Excel conditional formatting tutorial that takes your productivity to the next level.

HOW WILL YOU BENEFIT:

After you enroll and complete this course, you will have acquired various carefully selected conditional formatting tips and tricks. This course is designed with a conditional formatting problem-solving approach  in  mind.  The  majority  of  these  training  lessons  first introduce and define a specific, real-life problem and then provide an elegant conditional formatting based solution, so you can apply the newly-acquired skills immediately. After you have taken this course, you will:
1)  Become more productive in Excel
2)  Enhance your conditional formatting skills
3)  Save time with conditional formatting at work
4)  Make your spreadsheets more dynamic
5)  Impress your boss, your colleagues, and your clients
6)  Improve your data analysis capabilities
7) Becomes comfortable with conditional formatting formula based rules

 

8) MICROSOFT Excel Functions and Formulas

Duration: 2 days

INTRODUCTION:

The distinguishing feature of a spreadsheet program such as Excel is that it allows you to create mathematical formulas and execute functions. Otherwise, it is not much more than a large table displaying text. Your spreadsheet environment will become a dynamic and responsive work environment when you use formulas and funcstions; they automatically updating when you change your data.

HOW WILL YOU BENEFIT:

Upon successful completion of this course, participants will be able to:
1) Understand the Excel tools to assist in building formulas
2) Create basic formulas and functions
3) Manipulate text with Text functions
4) Calculate dates and numbers in creative ways
5) Add intelligence to your spreadsheets using Logical functions
6) Find data easier with Lookup functions
7) Use advanced function techniques to save you time

9) MICROSOFT Excel Dashboard for REPORTS-POPULAR

Duration: 2 days

INTRODUCTION:

This course is best suited to anyone in Business Intelligence, data managers, data analysts, or Project Managers. This course would also suit anyone looking to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together.

HOW WILL YOU BENEFIT:

• At the end of this course you will understand what makes a dashboard.
• You will learn how to build some of the most useful components when constructing your own dashboard reports.
• During the course, you will build one complete dashboard projects to give you inspiration for your own solutions.

10) MICROSOFT Excel Power Lookup and Reference Functions (new)

Duration: 2 days

INTRODUCTION:

For anyone working with a large amount of data, particularly those who need to easily cross-reference different sets of data, the ability to use functions such as LOOKUP and REFERENCE functions in Microsoft Excel is absolutely essential. Here, we will show you the power of the LOOKUP and REFERENCE functions, demonstrating to you how they work, their limitations, and how you can utilise them to make working life easier for you. Learners are encouraged to participate in the session by asking questions, and we’ll be here to provide you support via email after attending the programme.

HOW WILL YOU BENEFIT:

• By the end of the course you will be able to know:
• How the LOOKUP and REFERENCE functionsworks and what its limitations are
• How to write a powerful LOOKUP and REFERENCE functionsto find related information within the same worksheet
• The difference between near and exact matches in your searches
• How to nest within LOOKUP and REFERENCE functions and other functions
• How to build a LOOKUP and REFERENCE functions working between different worksheets and workbooks
• How to gather and transform data from multiple sources
• Exploration, analysis and visualization of data

11) Financial Modelling Using MICROSOFT Excel

Duration: 2 days

INTRODUCTION:

Financial Modelling is one the most fundamental and widely sought after skills in the finance industry. It is the art of building a model to depict financial statements and investment analysis using MICROSOFT Excel. Learn various techniques in investment appraisal, budgeting, financial analysis and forecasting. Financial models can be used to represent the performance of a business, a project or any other investment.

HOW WILL YOU BENEFIT:

With historical data available, forecasting is used to predict possible outcomes so as to help make short or medium term decisions. Learn to handle forecasting with seasonal fluctuations. Build a financial model from scratch.

Leverage on Excel’s built in tools to link data in the most efficient way while minimising errors by building in error checks. Repetitive tasks can be very time consuming. In this course, the introduction of macro programing will allow users to automate repetitive tasks.

While many professionals are familiar with the output of financial statements, few are truly adept at building an accurate and effective financial model from ground up. Learn the step by step process where each component builds upon or feeds into another component in a budget model.

In many situations, we want to find the best way to achieve an objective. In other words we want to find the parameters that optimize (example maximize profits or minimize costs) a certain objective using Excel Solver tool.

 

12) Mastering Pivot Tables with Pivot Charts

Duration: 1 day

INTRODUCTION:

Elements of this syllabus are subject to change. This one-day instructor- led course provides students with the knowledge and skills to examine and manipulate raw data through the use of Microsoft Office Excel PivotTables and PivotCharts.

HOW WILL YOU BENEFIT:

Upon completion of this program, participants will be able to:

• Understand the benefits of PivotTable Reports
• Convert raw data in an Excel worksheet into meaningful PivotTables and PivotCharts
• Manipulate the PivotTable layout
• Use grouping
• Create custom calculations
• Use formulas and create formulas outside of a report
• Create a PivotChart and publish it to a Web site

 

13) Mastering Charts & Graphs in Excel 2010 and 2013

Duration: 2 days

INTRODUCTION:

Use Excel 2013’s radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly… so you drive your message home, and get the decisions and actions you’re looking for!

HOW WILL YOU BENEFIT:

Upon completion of this program, participants should be able to:

• Create stunning data visualizations instantly with Excel 2013’s new Recommended Charts
• Use charts to instantly reveal trends, differences, and relationships
• Quickly generate combo charts that once required complex, frustrating procedures
• Create Waterfall and Thermometer Charts.

14) Excel VBA Programming/Macro-POPULAR

Duration: 3 days

INTRODUCTION:
Excel 2010 VBA training teaches participants everything they need to know to create VBA applications within Excel.

HOW WILL YOU BENEFIT:

During this course, all attendees will learn to:

• Use Macros
• Create recorded macros in Excel
• Use the macro recorder to create a variety of macros
• Understand the Excel object model and VBA concepts
• Work with the three main components of the VBA Editor window
• Create procedures in VBA
• Create and use variables
• Create and work with user-defined functions
• Write code to manipulate Excel objects
• Use a range to manipulate Excel objects
• Use a range of common programming techniques
• Create a custom form complete with controls
• Code to drive user form
• Create procedures that start automatically
• Write a variety of error handling routines

 

15) Analysing Data with MICROSOFT Power BI-NEW

Duration: 3 days

INTRODUCTION:

This three-day instructor-led course provides students with the knowledge and skills analyse data with Microsoft Power BI.
This primary audience for this course is BI professionals who need to analyse data utilizing Power BI.
The secondary audiences for this course are technically proficient business users.

HOW WILL YOU BENEFIT:

After completing this course, students will be able to:

• Describe key features of a self-service BI solution
• Describe Power BI and its data sources
• Model, shape, and combine data
• Describe Power BI data visualizations
• Excel Power PIVOT-NEW

 

16) Excel Power PIVOT-NEW

Introduction: 1 day

In this program, trainer will cover on PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for Microsoft Excel that allows large amounts of data to be collected, aggregated, and analyzed in one workbook.

Modules covered

• Best Things That PowerPivot Brings to Excel
• What Will PowerPivot Do for the Analyst?
• Introduction to PivotTables (Optional)
• VLOOKUP Not Required (Use Relationships)
• Architectural Changes in Excel 2013
• PowerPivot and Excel 2013
• PowerPivot and SharePoint
• Enterprise Business Intelligence and PowerPivot
• Importing Data
• Data Models
• Data Relationships
• Simple PivotTable Reports
• Calculated Columns and Calculated Fields
• Refreshing Data
• Calculations
• SharePoint Sharing

Lab 1: Excel 2013 PowerPivot

• Pivot Tables (Optional)
• PowerPivot User Interface
• Importing Data
• Importing Large Datasets
• Importing Data with a Query
• Creating Relationships
• Creating a Cascading Relationship
• Creating a Relationship Between Tables From Different Sources
• Hiding Columns, Change Data Type, Sorting, and Filtering
• Calculated Column and Calculated Field
• Add a Calculated Field From the PivotTable
• Filter Context Using One Table
• Row Context and Dynamic Selection
• FILTER Function
• CALCULATE Function
• Build a Date Table
• Relate a Table to an Excel Calendar Table
• Time Intelligence
• Perspectives
• Hierarchies
• KPIs

After completing this module, students will be able to:

• Understand pivot tables (optional)
• Explore on the PowerPivot user interface
• Import data
• Import to large datasets
• Import data with a query
• To Create relationships
• To Create a cascading relationship
• To Create a relationship between tables from different sources
• Learn how to hide columns, change data types, sort, and filter.
• Learn how to create and configure calculated columns and calculated fields
• Learn how to add a calculated field from the pivot table
• Understand row context and dynamic selection
• Know how to Use FILTER function
• Know how to Use CALCULATE function
• Build a date table
• Able to relate a table to an Excel calendar table
• Able to create and configure Time Intelligence
• Able to create and configure perspectives
• Able to create and configure hierarchies
• Able to create and configure KPIs

 

1xx) Excel Power Query-NEW

Duration: 1 day

INTRODUCTION:

Power Query can connect to wide range of data source. Databases such as SQL Server, Oracle, Text files, Big data and Hadoop data sources, online searches and OData feeds, Cloud storage, Facebook, SharePoint and many other types of data storage. Power Query extracts the data from multiple file formats, and does transformations such as splitting columns, data conversions, lookups, data consolidation, data cleansing and many other data transformations AUTOMATICALLY without the use of VBA. Power Query introduced a new expression language called “M” for data transformations.

Power Query is simple the best transformation and data manipulation tool for Excel and easier to use, understand and master than any other tools.

HOW WILL YOU BENEFIT:

During the training, you will use Power Query to:

• Import/ connects to external data from multiple sources.
• Automates the data transformation & data cleansing processes.
• Combines data from multiple sources into a single source (ready for pivot tables).
• Merging data without the need of formulas such as VLOOKUP, INDEX & Match.
• Perform calculation to aggregate data

 

MICROSOFT Office Power Point

17) MICROSOFT Office Power Point 2013 – Basic

Duration: 1 day

INTRODUCTION:

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who wants to know, understand and want to further enhance their knowledge and practical uses of Microsoft PowerPoint.

HOW WILL YOU BENEFIT:

Upon completion of this program, participants should be able to:

• Create and format presentation
• Change and Reset the slide Layout
• Apply Bullets and Numbers
• Create Sections in a presentation
• Apply Themes to a presentation
• Change the Slide Variant
• Format the Slide Background
• Apply header and footer to a presentation
• Print  Notes and Handouts

18) MICROSOFT Office Power Point 2013– Intermediate

Duration: 1 day

INTRODUCTION:

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who wants to know, understand and want to further enhance their knowledge and practical uses of Microsoft PowerPoint.

HOW WILL YOU BENEFIT:

Upon completion of this program, participants should be able to:

• Insert Table into a Presentation
• Insert Chart into a Presentation
• Insert SmartArt into a Presentation
• Insert Equation into a Presentation
• Apply Basic Animations
• Copy Animation with Animation Painter
• Apply Transitions
• Customize Transitions
• Publish a presentation to PDF or XPS format
• Protect a Presentation with a Password

 

19) Impactful Presentation Using MICROSOFT PowerPoint

Duration: 2 days

INTRODUCTION:

Want to create effective PowerPoint presentations but don’t know where to start? Whether you are new to PowerPoint or have some experience and want to improve your skills, this course has something for everyone, covering, intermediate and advanced lessons in PowerPoint

HOW WILL YOU BENEFIT:

• Enhance your productivity using ribbons in PowerPoint
• Move beyond default PowerPoint templates
• Create impressive presentations using template

Back to programs

Here’s What Clients Say About Us