Monday, January 6, 2020

Excel For Accountants (Intermediate) -3035530865

In this course you’ll learn:
  • Perform calculations using Time and Date functions
  • Lookup information using HLOOKUP and VLOOKUP
  • Perform more complex lookups using INDEX and MATCH
  • Make decisions with IF Statements
  • Incorporate logical operators into formulas
  • Create a Loan Amortization table using the PMT function
  • Clean and prepare raw data
  • Create PivotTables and PivotCharts
  • Analyse large datasets using Power Pivot
  • Use Goal Seek, Data Tables and Scenarios to analyse data
  • Automate common tasks using Macros
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel PivotTable Course-3035530865

Sample content: More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Who is this course for?

Business, Data and Financial analysts that want to crunch data from any source, quickly and easily. Excel users that want to supercharge their data analysis skills.

Requirements

Microsoft Excel 2007/10 or 2013

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel - Beginner & Advanced Bundle-3035530865

Description

Why Excel Matters:
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.
We also know how difficult it is to find quality instruction that is:
  • Easy to follow
  • Gets you the results you want
  • Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Excel course.
What you get with this Microsoft Excel duo:
  • 280 modules of training, covering the most business-relevant areas of Microsoft Excel.
  • 190+ videos and over 130 downloadable exercises.
  • Tailored learning. If you have some Excel knowledge, you can use the filter to show only what you most need to learn.
  • You’ll be an advanced level user after taking this Microsoft Excel course.
What you will learn in these courses:
Microsoft Excel:
  • How Excel works, how to navigate and design a spreadsheet
  • The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
  • To use PivotTables, Pivot Charts and Basic Macros
  • To create beautiful looking graphs and charts
  • Formatting, including; conditional, cell and number formatting
  • How to print what you want
Advanced Microsoft Excel:
  • Use advanced graphs in minutes instead of wasting hours trying to figure them out
  • Increase interactivity by automating your spreadsheets with macros and VBA
  • Solve complex problems with superpower functions
  • Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
  • And more!
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Data Analysis In Excel-3035530865

Description

In a world where we are constantly bombarded with information, making sense of it all can sometimes be difficult and time-consuming. This is particularly true of Excel. Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.
What you get with this Data Analysis in Excel course:
  • 15 brand new demo videos with professional voiceovers
  • 11 modules with text, that is relevant and easy to understand
  • 10 downloadable exercises
  • Quiz questions in every module
  • Specific objectives and condensed accelerators
In this course you’ll learn:
  • Clean up data ready for analysis
  • Create PivotTables and PivotCharts
  • Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
  • Make decisions using IF Statements
  • Highlight information using Conditional Formatting and Rules
  • Build a basic Interactive Dashboard
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Complete Course - Beginner, Intermediate & Advanced- SPTTC-3035530865

Description

MS Excel Beginners Course
The MS Excel beginners course will give you a full overview of all of the most common features of Excel and how to use them.
Some of the highlights of this course include:
  • A basic overview of Excel
  • Calculating sums, averages, and totals
  • Counting cells
  • Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Creating borders
  • Wrapping text
  • Merging cells
  • Pasting, sorting, and converting columns to rows
  • Creating graphs and charts
  • Using hyperlinks
This beginners course is recommended for anyone who might use Excel at home or at work for uncomplicated reasons, such as tracking simple expenditures or for calculating sums or totals.
MS Excel Intermediate Course
The MS Excel Intermediate Course will take what you learnt in the beginners course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginners course.
Some of the highlights of the intermediate Excel course include the following:
  • Learning more about intermediate Excel functions including ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS, and AVERAGEA
  • Data validation with date, list, time, and numbers
  • Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • How to remove duplicates in Excel
  • Creating random numbers
  • Changing text case
  • Adding passwords
  • Sending emails from Excel
  • Adding custom backgrounds
  • How to auto fill data
  • Adding special characters
  • Changing border colour and theme
Before jumping into the MS Excel Intermediate course, one should have a good basic overview of the beginner Excel functions. Those with experience in Excel might feel as if they can skip the beginner course, but it is best to at least go through the course and review it before starting the intermediate curriculum.
The curriculum in the intermediate course is designed for those who work with Excel in the workplace, and it is primarily for those who want to improve their skills with this program.
MS Excel Advanced Course
The MS Excel Advanced Course is the longest and the most intense of the three Excel courses presented here. However, if you have successfully passed the beginner and the intermediate courses, you should consider yourself fully prepared to begin the advanced course.
Some of the concepts that you will learn in the MS Excel Advance Course include the following:
  • VLOOKUP Advanced formula options and manipulations
  • Other advanced functions including OR, AND, CHOOSE, INDIRECT, REPLACE, LEN,      LEFT, FIND
  • Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
  • Colouring a column and row with a formula
  • Highlighting a cell with a formula
  • Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
  • Functions including DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM
  • Calculating loan IPMT and EMI
  • Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
  • Full explanation of the INDEX and MATCH functions, covering several modules
  • Looking up data
  • Selecting only cells containing comments
  • Hiding formulas
As you can see, the information you will get from the MS Excel Advanced Course will fully prepare you for virtually any career path, including those that require advanced skills with this software. Though this course is the longest and most involved of the three, once you complete it, you will have the knowledge and skills that most can only dream of.

Beginners Course Modules/Lessons
Module 1: Introduction to Excel
Module 2 : Add
Module 3 : Multiply
Module 4 : Subtraction in Excel
Module 5 : Dividing
Module 6 : Sort
Module 7 : Percentage
Module 8 : Running Totals
Module 9 : Print
Module 10 : Paste Special
Module 11 : Merge
Module 12 : Filter
Module 13 : Average
Module 14 : AVERAGEIF
Module 15: SUMIF Formula
Module 16: IF Formula
Module 17: VLOOKUP
Module 18: HLOOKUP
Module 19 : Countif Formula
Module 20 : CountBlank
Module 21 : Counta Formula
Module 22 : Count Formula
Module 23 : Concatenate
Module 24 : Transpose
Module 25: Date Formula
Module 26: Month Formula
Module 27: Pivot Tables
Module 28: Pie Charts
Module 29: Doughnut Charts
Module 30: Line Charts
Module 31: Column Charts
Module 32: Bar Charts
Module 33: Number Formatting
Module 34: Create Borders
Module 35: Conditional Formatting
Module 36: Comments FAQ's
Intermediate Course Modules/Lessons
Module 1: SumProduct Formula
Module 2 : Data Validation With Date
Module 3 : Data Validation with Whole Numbers
Module 4 : Data Validation with List Feature
Module 5 : ABS Function
Module 6 : CHAR Function
Module 7 : CLEAN Function
Module 8 : CODE Function
Module 9 : EXACT Function
Module 10 : AVERAGEA Function
Module 11 : AVERAGEIF
Module 12 : AVERAGEIFS Function
Module 13 : CELL Function With 10 Variations
Module 14 : LARGE Function
Module 15: MAX Function
Module 16: MEDIAN Function
Module 17: MIN Function
Module 18: MODE Function
Module 19 : N Function
Module 20 : RANDBETWEEN Function (Insert Random Numbers)
Module 21 : RANK Function
Module 22 : Remove Duplicate Values
Module 23 : ROUND Function Up/Down
Module 24 : Add Custom Background Image
Module 25: Change Text To Lower Case
Module 26: Change Text To Upper Case
Module 27: Change Text To Proper Case
Module 28: Insert Special Character
Module 29: Use Autofill : A Time Saving Trick
Module 30: Treemap Chart
Module 31: Sunburst Chart
Module 32: Use Tables
Module 33: Use Templates
Module 34: Use Themes
Advanced Course Modules/Lessons
Module 1: Add a Password
Module 2 : AND Function
Module 3 : Auto Updating Drop-down Lists
Module 4 : CEILING Formula
Module 5 : Charts that Update Automatically
Module 6 : CHOOSE Formula
Module 7 : Compare 2 Lists with VLOOKUP Function
Module 8 : CORREL Function
Module 9 : Create an Advanced Calculator
Module 10 : Create a Combo Chart
Module 11 : Create a Custom Tab
Module 12 : Create a Pivot Chart
Module 13 : Create Visual In-cell Indicators
Module 14 : Create Visual In-cell Indicators with Icon Sets
Module 15: Customise the Status Bar
Module 16: DATEDIF Function
Module 17: DATEVALUE Function
Module 18: DAVERAGE Function
Module 19 : DCOUNT Function
Module 20 : DCOUNTA Function
Module 21 : Depreciation Formula
Module 22 : DGET Function
Module 23 : DMAX Function
Module 24 : DPRODUCT
Module 25: DSUM Function
Module 26: EDATE Function
Module 27: EOMONTH Function
Module 28: Find and Replace
Module 29: FIND Function
Module 30: INDEX Function
Module 31: Index and Match Formula
Module 32: Indirect Formula
Module 33: Insert Serial Number Automatically
Module 34: IPMT Formula
Module 35: Isblank Formula
Module 36: Iserr Formula
Module 37: Islogial Formula
Module 38: Isnon Text Formula
Module 39: IsNumber Formula
Module 40: Isodd Formula
Module 41: Isolate First Name
Module 42: ISTEXT Formula
Module 43: Left Formula
Module 44: Len Formula
Module 45: Match Formula
Module 46: Vlookup Multiple Results at Once
Module 47: OR Formula
Module 48: PMT Formula
Module 49: Replace Formula
Module 50: Select all Cells with Comments
Module 51: Sparkline Charts in Excel
Module 52: Straight Line Depreciation
Module 53: Strikethrough
Module 54: Sum of Years Depreciation
Module 55: Timeline in Pivot Table
Module 56: Vlookup with 2 Criteria
Module 57: Vlookup with DropDown List
Module 58: Vlookup with Max
Module 59: Vlookup with Min
Module 60: Watch Window In Excel


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel – Beginner Course-3035530865

Description

Introduction to the Microsoft Excel for Beginners Course
This beginners course is recommended for anyone who might use Excel at home or at work for uncomplicated reasons, such as tracking simple expenditures or for calculating sums or totals. This course is ideal for anyone who has never used Excel or for those who have only a rudimentary understanding of the software.
It is also perfect for anyone who is familiar with the older versions of the software, but not the latest version. If you are re-entering the workforce, you will also find that this course will suit you well, and will certainly get you caught up with the rest of your peers.
The course begins with explaining concepts, such as ‘What is a cell?’ and how to tell the difference between a column and a row. The course continues by explaining basic Excel concepts such as how to create, copy, delete, and cut information from Excel cells. You will also learn how to edit information that is put into a cell and how to insert and edit comments when using Excel.
The second half of the beginner’s Excel overview, which is only a small part of the beginner’s course, will cover sheets, which is an entirely different concept than cells. In this section, you will learn how to rename a sheet, delete a sheet, hide and unhide a sheet, and move and copy a sheet. You will also learn how to change the colour of tabs.
After mastering the beginner’s overview, the rest of the beginner’s course will go further into these concepts, and then teach details on how to perform basic functions.
Each video in the course shows where one can learn more about the concept covered in the course, as well as the difficulty level of the concept. There is also a full explanation of the concept and the instructor of the course visually takes students through each concept step by step on the screen. If you have questions about the concept, the instructor also offers a message board, or you can download a list of the most common questions asked about Excel.
When you finish this course, you will have a basic understanding of how to use many of the functions of Excel, and can use the program with ease. You will then be fully prepared to move ahead to the intermediate course.
What you will learn
The MS Excel beginners course will give you a full overview of all of the most common features of Excel and how to use them. Some of the highlights of this course include:
  • A basic overview of Excel
  • Calculating sums, averages, and totals
  • Counting cells
  • Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Creating borders
  • Wrapping text
  • Merging cells
  • Pasting, sorting, and converting columns to rows
  • Creating graphs and charts
  • Using the dictionary
  • Using hyperlinks

Course Modules/Lessons
Module 1: Introduction to Excel
Module 2 : Add
Module 3 : Multiply
Module 4 : Subtraction in Excel
Module 5 : Dividing
Module 6 : Sort
Module 7 : Percentage
Module 8 : Running Totals
Module 9 : Print
Module 10 : Paste Special
Module 11 : Merge
Module 12 : Filter
Module 13 : Average
Module 14 : AVERAGEIF
Module 15: SUMIF Formula
Module 16: IF Formula
Module 17: VLOOKUP
Module 18: HLOOKUP
Module 19 : Countif Formula
Module 20 : CountBlank
Module 21 : Counta Formula
Module 22 : Count Formula
Module 23 : Concatenate
Module 24 : Transpose
Module 25: Date Formula
Module 26: Month Formula
Module 27: Pivot Tables
Module 28: Pie Charts
Module 29: Doughnut Charts
Module 30: Line Charts
Module 31: Column Charts
Module 32: Bar Charts
Module 33: Number Formatting
Module 34: Create Borders
Module 35: Conditional Formatting
Module 36: Comments FAQ's

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Online Course for Beginners--3035530865

What you get with this Microsoft Excel course:
  • 22 modules of training (full syllabus below), covering the most business-relevant areas of Microsoft Excel.
  • Taught via video, downloadable practice exercises and mini tests.
  • You’ll have a basic understanding of Microsoft Excel after taking this course.
In this course you’ll learn:
  • Data entry
  • Text and number formats
  • Basic mathematical functions (SUM, AVERAGE)
  • Editing skills, including Flash Fill
  • Basic data analysis skills through sorting and filtering.
  • Printing spreadsheets
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Who is this course for?

Perfect for beginners through to those with intermediate levels of experience and anyone looking to brush up on their core Excel skills. This course is proven to save you time in the workplace and optimise your workflow across essential day to day Microsoft Excel tasks.

Requirements

Version: Excel 2013 used in examples but applicable to all PC Excel versions


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Excel For Accountants (Basic)-3035530865

In this course you’ll learn:
  • Worksheet organisation and navigation tips
  • Understanding Number and Date Formatting
  • Conditional Formatting
  • Constructing Formulas using Basic Functions
  • The Importance of Absolute Cell References
  • Sorting and Filtering Data
  • Looking beyond simple Paste
  • The advantages of naming Ranges
  • Manipulating data with Text Functions
  • The magic of Flash Fill
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Who is this course for?

The Excel for Accountants (Basic) course is a short course consisting of 10 video-led modules. The course is primarily aimed at accountants, bookkeepers and accounting professionals and aims to provide learners with a solid foundation with which to build further skills.


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel 3 Course Bundle – Basic, Intermediate & Advanced Courses-3035530865

Description

The online Microsoft Excel Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel Advanced course is perfect.
Course Syllabus
Basic Level:
  • Introduction to Spreadsheets
  • Understanding Microsoft Excel
  • Excel Workbook Windows
  • Basic Spreadsheet Skills
  • Excel Help System
  • Opening and Closing Workbooks
  • Understanding Workbook File Formats
  • Creating New Workbooks
  • Selecting Cells
  • Auto Sum and Auto Fill Function
  • Cell Referencing and Request
  • Formatting Cells
  • Formatting Numbers
  • Placing Cell Alignment
  • Cell, Rows and Columns
  • Understanding Worksheets
  • Editing, Copying and Moving Cells
  • Page Layouts in Excel
  • Proofing Workbooks
  • Basic Options, Ribbons and Toolbar
  • Final Assessment
Intermediate Level:
  • Introduction to Excel Spreadsheet Intermediate Level
  • Defining Names in Excel
  • Sorting Data
  • Using Excel Tables
  • Filtering Data in Excel
  • Understand Charts
  • Chart Design Options and Tools
  • Chart Format Tools
  • Combo Charts
  • Functions within Excel
  • Understanding Date Function
  • Information Functions
  • Logical Functions
  • Financial Functions
  • Find and Replace
  • Headers and Footers
  • Adding Comments
  • Conditional Formatting
  • Final Assessment
Advanced Level:
  • Introduction to Excel Advanced
  • Using Text to Columns
  • The Paste Special Function
  • Data Validation
  • Subtotals and Grouping
  • Consolidating Data
  • Scenario Analysis
  • Data Tables in Scenario Analysis
  • What-if Analysis
  • Mats and Trig Functions
  • Text Functions in Excel
  • Using Lookup Functions
  • Vlookups
  • HLookups
  • Using Statistical Functions
  • Databse Functions
  • Formaula Auditing and Error Tracing
  • Hyperlinks in Excel
  • Linking Data
  • Understanding Pivot Tables
  • Using Pivot Charts
  • Workbook Properties
  • Protecting and Sharing Worksheets
  • Data Encrypting and Finalising Workbooks
  • Understanding to Macros
  • Custom Number Formats in Excel
  • Using Custom Lists
  • Working with Templates
  • Tracking Changes in Excel
  • Merging and Compare Excel Workbooks
  • Final Assessment
  • Microsoft Excel Software
This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.
Assessment
To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel Basic, Intermediate & Advanced course, the course features a number of end of module interactive quiz questions.
Additionally, at the end of the course learners will also take an online multiple choice assessment test. This online multiple choice test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel – Intermediate Course -3035530865

Description

Some of the highlights of the intermediate Excel course include the following:
  • Learning more about intermediate Excel functions including ABS, AVERAGEIF, AVERAGEIFS, and AVERAGEA
  • Data validation with date, list, time, and numbers
  • Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • How to remove duplicates in Excel
  • Creating random numbers
  • Changing text case
  • How to use Templates
  • Insert Charts
  • Adding custom backgrounds
  • How to use Tables
  • How to auto fill data
  • Adding special characters
  • Changing border colour and theme
Course Modules/Lessons
Module 1: SumProduct Formula
Module 2 : Data Validation With Date
Module 3 : Data Validation with Whole Numbers
Module 4 : Data Validation with List Feature
Module 5 : ABS Function
Module 6 : CHAR Function
Module 7 : CLEAN Function
Module 8 : CODE Function
Module 9 : EXACT Function
Module 10 : AVERAGEA Function
Module 11 : AVERAGEIF
Module 12 : AVERAGEIFS Function
Module 13 : CELL Function With 10 Variations
Module 14 : LARGE Function
Module 15: MAX Function
Module 16: MEDIAN Function
Module 17: MIN Function
Module 18: MODE Function
Module 19 : N Function
Module 20 : RANDBETWEEN Function (Insert Random Numbers)
Module 21 : RANK Function
Module 22 : Remove Duplicate Values
Module 23 : ROUND Function Up/Down
Module 24 : Add Custom Background Image
Module 25: Change Text To Lower Case
Module 26: Change Text To Upper Case
Module 27: Change Text To Proper Case
Module 28: Insert Special Character
Module 29: Use Autofill : A Time Saving Trick
Module 30: Treemap Chart
Module 31: Sunburst Chart
Module 32: Use Tables
Module 33: Use Templates
Module 34: Use Themes

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel - Advanced-3035530865

Description

Course Syllabus includes 24 intermediate/advanced level lessons
  • Essential Formula Knowledge - Understand the most common and essential formula categories in Excel and how to use them.
  • Understanding Dates - Understand how dates work in Excel using the TODAY, YEAR, MONTH, DAY and DATE functions.
  • Understanding Time - Understand how time works in Excel, and how to change from whole numbers into time increments and back again.
  • · Intermediate Formula Knowledge - Learn more advanced formulas and gain a deeper understanding of how Excel formulas work.
  • Formula Auditing - Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.
  • Temporal Functions - Learn to work with the EOMONTH and EDATE functions that easily shift dates from one month or year to another.
  • VLOOKUP with Approximate Match - Learn to use VLOOKUP to find an approximate match and return it or the corresponding value from another column.
  • VLOOKUP with Exact Match - Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column.
  • Other Lookup Methods - Learn to work with INDEX, MATCH and HLOOKUP, as alternatives to the VLOOKUP function.
  • · Optimizing Data - Get your data into a usable form and unleash Excel's most powerful tools with it.
  • Naming Ranges - Learn about creating named ranges, and the benefits of doing so.
  • Excel Tables - Learn about creating Excel tables, and their advantages.
  • Recording Macros - Learn to record basic Excel macros to automate your actions (instead of doing them manually).
  • · Data Analysis - Analyze, summarize and highlight data quickly and easily using Excel's PivotTables.
  • Creating PivotTables - Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data).
  • Formatting PivotTables - Learn to control formatting and other options in PivotTables.
  • Calculated Fields in PivotTables - Learn to create and modify basic calculated fields for PivotTables.
  • What-If Analysis - Learn to perform what-if analysis in Excel using the Scenario Manager and Goal-Seek.
  • · Presenting and Reporting - Interpret your data and turn it into information using Excel's advanced formatting tools.
  • Outlining - Learn about adding and working with Excel’s outlining tools to quickly hide irrelevant sections of your worksheet.
  • Custom Number Formats - Learn to build your own custom number formats to display dates, values and variances how you want to see them.
  • Conditional Formats with Built-In Rules - Learn to create top/bottom and highlight cell rules, as well as to apply icon sets and data bars.
  • Conditional Formats with Custom Rules - Learn to create custom conditional formatting rules based on formulas.
  • Building Combination Line and Area Charts - When you want to graph 3 line series, but only want 2 in focus most of the time.
  • · Validating and Updating - Increase the integrity and longevity of your spreadsheet so that the right data is entered and can be easily updated.
  • Data Validation - Learn how to use Data Validation to ensure that users enter valid data in input cells.
  • Styles - Learn how to apply built-in number styles and create your own custom styles packages.
  • Preparing to Deploy - Set up Excel's aesthetics, including preparing to print, and protect your spreadsheet's key components.
  • Custom Views - Learn how to create and manage Custom Views in a worksheet.
  • Page Setup Options - Learn about page setup options, fitting print jobs on a page, headers and footers, and other ways to customize print jobs.
  • Security Considerations - Learn about the setup and weaknesses of Excel’s security systems.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad


Microsoft Excel 2007 Intermediate
-3035530865

Description

Learning Outcomes
  • Learn how to summarise data and correct errors in calculation
  • Learn formatting and calculation
  • Learn how to customise appearance of charts
  • Learn how to print charts separately from worksheets
  • Learn how to create an outline, showcase different groups of data
Course Titles
  • Module 01: Using Multiple Worksheets and Workbooks
  • Module 02: Advanced Formatting
  • Module 03: Outlining and Subtotals
  • Module 04: Cell and Range Names
  • Module 05: Lists and Tables
  • Module 06: Web and Internet Features
  • Module 07: Advanced Charting
  • Module 08: Documenting and Auditing
  • Module 09: Templates and Settings
Access Duration
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.
Method of Assessment
At the end of the Microsoft Excel 2007 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.
Certification
Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2007 Intermediate.
Awarding Body
The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Complete Course - Beginner, Intermediate & Advanced-3035530865

Description

MS Excel Beginners Course
The Microsoft Excel beginner’s course will provide you with a comprehensive overview of all of the most well-known features of Excel and the methods to successfully use them.
The highlights of this course cover:
  • A broad overview of MS Excel
  • Calculating sums, averages, and totals
  • Summing columns or rows of numbers
  • Including cells
  • Learning formulas including IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Wrapping text
  • Creating borders
  • Merging cells
  • Pasting, ordering, and converting columns to rows
  • Designing graphs, diagrams and charts
  • Using hyperlinks
This beginner's level course highly recommended if you want to use Excel at home or work for tracking simple expenses or calculating sums or totals, adding column headings, and so on.
MS Excel Intermediate Course
The MS Excel Intermediate Course focuses on teaching you more advanced concepts of Excel in an accessible and more comprehensive guide to mind.
The highlights of the intermediate Excel course include the following:
  • Grasp advanced Excel functions such as ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, and AVERAGEIFS
  • Data validation with date, list, time, and numbers
  • Other functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • Techniques to eliminate duplicates in Excel
  • Creating random numbers
  • Changing text case
  • Adding passwords
  • Sending emails from Excel
  • Adding custom backgrounds
  • How to auto-fill data
  • Adding special data and characters
  • Changing border colour and theme
With having a firm basic knowledge of the beginner Excel functions, you can effortlessly get into the MS Excel Intermediate course.
The course curriculum intended for making it much easier to work with Excel in the workplace, and it is perfect for individuals who desire to enhance their skills in Excel.
MS Excel Advanced Course
After completing the beginner and intermediate courses successfully, you will move onto the MS Excel Advanced Course where you will introduce with the curriculums that well laid out with just the most essentials in Excel.
The highlights of MS Excel Advance Course cover:
  • VLOOKUP Advanced formula options and manipulations
  • Other advanced functions such as OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND
  • Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
  • Highlighting a cell with a formula
  • Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
  • Functions including DGET, DMAX, PRODUCT, DCOUNTA, DCOUNT and DSUM
  • Calculating loan IPMT and EMI
  • Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
  • A detail interpretation of the INDEX and MATCH functions
  • How to look up data
  • Colouring a column and row with a formula
  • How to select only cells carrying remarks
  • Hiding formulas
The MS Excel Advanced Course will thoroughly prepare you for job posistion that require excellent command over Excel. Upon successful completion of the course it, you will gain the knowledge and skills and feel more confident that will be ideal for your career success.
Beginners Course Modules
  • Module 1: Navigate the Excel User Interface
  • Module 2: Use Excel Commands
  • Module 3: Create and Save a Basic Workbook
  • Module 4: Enter Cell Data
  • Module 5: Use Excel Help
  • Module 6: Create Worksheet Formulas
  • Module 7: Insert Functions
  • Module 8: Reuse Formulas and Functions
  • Module 9: Insert, Delete, and Adjust Cells, Columns, and Rows
  • Module 10: Search for and Replace Data
  • Module 11: Use Proofing and Research Tools
  • Module 12: Apply Text Formats
  • Module 13: Apply Number Format
  • Module 14: Align Cell Contents
  • Module 15: Apply Styles and Themes
  • Module 16: Apply Basic Conditional Formatting
  • Module 17: Create and Use Templates
  • Module 18: Preview and Print a Workbook
  • Module 19: Set Up the Page Layout
  • Module 20: Configure Headers and Footers
  • Module 21: Manage Worksheets
  • Module 22: Manage Workbook and Worksheet Views
  • Module 23: Manage Workbook Properties
Intermediate Course Modules
  • Module 1: Work with Ranges
  • Module 2: Use Specialized Functions
  • Module 3: Work with Logical Functions
  • Module 4: Work with Date & Time Functions
  • Module 5: Work with Text Functions
  • Module 6: Sort Data
  • Module 7: Filter Data
  • Module 8: Query Data with Database Functions
  • Module 9: Outline and Subtotal Data
  • Module 10: Create and Modify Tables
  • Module 11: Apply Intermediate Conditional Formatting
  • Module 12: Apply Advanced Conditional Formatting
  • Module 13: Create Charts
  • Module 14: Modify and Format Charts
  • Module 15: Use Advanced Chart Features
  • Module 16: Create a PivotTable
  • Module 17: Analyze PivotTable Data
  • Module 18: Present Data with PivotCharts
  • Module 19: Filter Data by Using Timelines and Slicers
Advanced Course Modules
  • Module 1: Use Links and External References
  • Module 2: Use 3-D References
  • Module 3: Consolidate Data
  • Module 4: Use Lookup Functions
  • Module 5: Trace Cells
  • Module 6: Watch and Evaluate Formulas
  • Module 7: Collaborate on a Workbook
  • Module 8: Protect Worksheets and Workbooks
  • Module 9: Apply Data Validation
  • Module 10: Search for Invalid Data and Formulas with Errors
  • Module 11: Work with Macros
  • Module 12: Create Sparklines
  • Module 13: MapData
  • Module 14: Determine Potential Outcomes Using Data Tables
  • Module 15: Determine Potential Outcomes Using Scenarios
  • Module 16: Use the Goal Seek Feature
  • Module 17: Forecasting Data Trends
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Excel 2016 Essentials - Training Course Microsoft Office Certification-3035530865


Description

What is covered in this Excel 2016 Essentials online course?
This Excel 2016 Essentials online training course covers the following modules:
Module One: Create and Manage Worksheets and Workbooks
  • Create Worksheets and Workbooks

    • Create a workbook
    • Import data from a delimited text file
    • Add a worksheet to an existing workbook
    • Copy and move a worksheet
  • Navigate in Worksheets and Workbooks

    • Search for data within a workbook
    • Navigate to a named cell, range, or workbook element
    • Insert and remove hyperlinks
  • Format Worksheets and Workbooks

    • Change worksheet tab color
    • Rename a worksheet
    • Change worksheet order
    • Modify page setup
    • Insert and delete columns or rows
    • Change Workbook themes
    • Adjust row height and column width
    • Insert headers and footers
  • Customize Options and Views for Worksheets and Workbooks

    • Hide or unhide worksheets
    • Hide or unhide columns and rows
    • Customize the Quick Access toolbar
    • Change workbook views
    • Change window views
    • Modify document properties
    • Change magnification by using zoom tools
    • Display formulas
  • Configure Worksheets and Workbooks for Distribution

    • Set a print area
    • Save workbooks in alternative file formats
    • Print all or part of a workbook
    • Set print scaling
    • Display repeating row and column titles on multiple worksheets
    • Inspect a workbook for hidden properties or personal information
    • Inspect a workbook for accessibility issues
    • Inspect a workbook for compatibility issues
Module Two: Manage Data Cells and Ranges
  • Insert data in cells and ranges

    • Replace data
    • Cut, copy, or paste data
    • Paste data by using special paste options
      fill cells by using Auto Fill
    • Insert and delete cells
  • Format cells and ranges

    • Merge cells
    • Modify cell alignment and indentation
    • Format cells by using Format Painter
    • Wrap text within cells
    • Apply number formats
    • Apply cell formats, apply cell styles
  • Summarize and organize data

    • Insert sparklines
    • Outline data
    • Insert subtotals
    • Apply conditional formatting
Module Three: Create tables
  • Create and manage tables

    • Create an Excel table from a cell range
    • Convert a table to a cell range
    • Add or remove table rows and columns
  • Manage table styles and options

    • Apply styles to tables
    • Configure table style options
    • Insert total rows
  • Filter and sort a table

    • Filter records
    • Sort data by multiple columns
    • Change sort order
    • Remove duplicate records
Module Four: Perform operations with formulas and functions
  • Summarize data by using functions

    • Insert references
    • Perform calculations by using the SUM function
      Perform calculations by using MIN and MAX functions
    • Perform calculations by using the COUNT function
    • Perform calculations by using the AVERAGE function
  • Perform conditional operations by using functions

    • Perform logical operations by using the IF function
    • Pperform logical operations by using the SUMIF function
    • Perform logical operations by using the AVERAGEIF function
    • Perform statistical operations by using the COUNTIF function
  • Format and modify text by using functions

    • Format text by using RIGHT, LEFT, and MID functions
    • Format text by using UPPER, LOWER, and PROPER functions
    • Format text by using the CONCATENATE function
Module Five: Create charts and objects
  • Create charts

    • Create a new chart
    • Add additional data series
    • Switch between rows and columns in source data
    • Analyze data by using Quick Analysis
  • Format graphic elements

    • Resize charts
    • Add and modify chart elements
    • Apply chart layouts and styles
    • Move charts to a chart sheet
  • Insert and format objects

    • Insert text boxes and shapes
    • Insert imagesModify object properties
    • Add alternative text to objects for accessibility

Career path

Anyone who successfully passes this course could progress to any of the following positions:
  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester
  • IT professionals
  • Technical IT professionals
  • Project-based technical analysts and engineers
  • Technical support personnel
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel – Advanced Course-3035530865

Description

The online Microsoft Excel 2013 Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel Advanced course is perfect.
Course Syllabus
The Microsoft Excel Advanced course is split into the following modules:
  • Introduction to Excel Advanced
  • Using Text to Columns
  • The Paste Special Function
  • Data Validation
  • Subtotals and Grouping
  • Consolidating Data
  • Scenario Analysis
  • Data Tables in Scenario Analysis
  • What-if Analysis
  • Mats and Trig Functions
  • Text Functions in Excel
  • Using Lookup Functions
  • Vlookups
  • HLookups
  • Using Statistical Functions
  • Databse Functions
  • Formaula Auditing and Error Tracing
  • Hyperlinks in Excel
  • Linking Data
  • Understanding Pivot Tables
  • Using Pivot Charts
  • Workbook Properties
  • Protecting and Sharing Worksheets
  • Data Encrypting and Finalising Workbooks
  • Understanding to Macros
  • Custom Number Formats in Excel
  • Using Custom Lists
  • Working with Templates
  • Tracking Changes in Excel
  • Merging and Compare Excel Workbooks
  • Final Assessment
  • Microsoft Excel Software
This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Excel: Data Analysis + Pivot Tables – Microsoft Office Certification - -3035530865

Description

What is covered in this Excel: Data Analysis with Pivot Tables online course?
Pivot Tables are the perfect tool to analyze large amounts of data in Excel. Being able to summarise, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data, and in this course Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016.
Topics covered include:
  • Preparing Data and Creating Pivot Tables
  • Working with Local and External Data Sources
  • Summarizing, Organizing, Filtering, and Formatting PivotTables
  • Refresh and Change PivotTable Data
  • Working with PivotCharts
Delivered by our experienced Microsoft trainer; Excel – Data Analysis with Pivot Tables will help intermediate and advanced users work more effectively with Excel Pivot Tables and Pivot Charts.
Why train with Mandatory Compliance?
Mandatory Compliance is the leading UK provider of accredited Microsoft Office training courses and programs. All our training materials are developed by fully certified Microsoft Office instructors with extensive industry experience.
Excel: Data Analysis with Pivot Tables – Microsoft Office Certification - Online CPD Training Course

Who is this course for?

This Excel – Data Analysis with Pivot Tables online training course is suitable for anyone who wants to improve their knowledge of Excel. These skills will enhance their knowledge and employability opportunities.
This Excel: Data Analysis with Pivot Tables online training course can be purchased as an individual course or as part of our integrated Microsoft Office programs.

Requirements

Course Delivery – via desktop PC/MAC, laptops, tablets or smart phones

Career path

Anyone who successfully passes this course could progress to any of the following positions:
  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester
  • IT professionals
  • Technical IT professionals
  • Project-based technical analysts and engineers
  • Technical support personnel
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel for Business Accounting -3035530865

Description

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
  • Video lessons
  • Online study materials
Course design
This course is designed with the following modules:
Excel Basics
  • Create a Basic Worksheet
  • Use the Help System
  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas
  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search For and Replace Data
  • Spell Check a Worksheet
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles
  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options
  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
  • Customize Formula Options
  • Customize the Functionality of Excel by Enabling Add-Ins
Intermediate Functions
  • Apply Range Names
  • Use Specialized Functions
  • Use Text Functions
  • Use Logical Functions
  • Use Lookup Functions
  • Use Date Functions
  • Use Financial Functions
  • Create and Modify Tables
  • Sort and Filter Data
  • Use Subtotal and Database Functions to Calculate Data
  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts
  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data with PivotCharts
  • Preparing a Workbook for Multiple Audiences
Advanced Features
  • Update Workbook Properties
  • Create and Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Merge Workbooks
  • Export Excel Data
  • Import a Delimited Text File
  • Create a Web Query
  • Import and Export XML Data
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel 2010 Intermediate-3035530865

Description

By the end of this course, you will be able to:
  • understand and use formula cell referencing to create more complex formulas
  • use a range of formula techniques and use a range of logical functions
  • use a range of lookup and reference functions
  • use the mathematical functions in Excel
  • use a range of text and information functions
  • sort data in a list in a worksheet
  • filter data in a table and use advanced filters to view or extract matching records from a list of data
  • use a range of techniques to enhance charts
  • protect data in worksheets and workbooks
  • use comments to provide additional context to your worksheet data
  • use data linking to create more efficient workbooks
  • group cells and use outlines to manipulate the worksheet
  • use the formula auditing tools to find and fix formula errors
  • analyse your data and visually enhance your findings using conditional formatting techniques
  • open and arrange multiple workbooks
What will it cover?
  • Revision of fundamentals
  • Formula auditing
  • Working with names
  • Customising the quick access toolbar
  • Protecting data
  • Conditional formatting
  • Working with comments
  • Logical functions
  • Lookup functions
  • Using maths functions
  • Working with dates
  • Text functions
  • Number formatting techniques
  • Sorting data
  • Filtering data
  • Advanced charting techniques
  • Using data validation
  • Grouping and outlining
  • Multiple workbooks
  • Advanced charts

Requirements

Microsoft Excel 2010 Intermediate assumes the delegate has completed Excel 2010 Fundamentals or has equivalent knowledge.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Visio Course-3035530865

In this course you will learn:
  • To understand the Microsoft “Ribbon”, Quick Access Toolbar, and Backstage View.
  • How to create new diagrams.
  • How to manipulate and add shapes.
  • How to use rulers, grids and guides.
  • To connect shapes using lines and dynamic glue.
  • To create cross-functional flowcharts.
  • How to work with themes.
  • How to create an organisation chart.
More about us:
  • Formed in 2009, EwB was created to solve a problem close to our founders hearts – ineffective Microsoft Excel training.
  • We have nearly 1 million students in total, 95k+ of those have had MS Excel training with us.
  • Our training is personal. If you have used Microsoft before you can use the filter to show you which parts of the course to skip.
  • All of our courses are certificated on completion – Most of our Microsoft Courses are also CPD Accredited.
  • Our platform is award-winning and improving all the time.
  • We have an in-house expert, Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Excel Intermediate (2010, 2013 & 2016) -3035530865

Description

This course covers Microsoft Excel 2010, 2013 and 2016.
Content covered
Advanced File Tasks
  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility
Working with Functions and Formulas
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Managing Tables in Microsoft Excel
  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters
Data Tools in Excel
  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate
Doing More with Charts in Excel
  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting
Sparklines
  • Creating Sparklines
  • Editing Sparklines
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Advanced with SPTTC Certificate-3035530865

Description


Course Content
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic 1A: Use 3-D References
Topic 1B: Use Links and External References
Topic 1C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic 2A: Collaborate on a Workbook
Topic 2B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic 3A: Apply Data Validation
Topic 3B: Work with Forms and Controls
Topic 3C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic 4A: Use Lookup Functions
Topic 4B: Combine Functions
Topic 4C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic 5A: Trace Cells
Topic 5B: Search for Invalid Data and Formulas with Errors
Topic 5C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic 6A: Determine Potential Outcomes Using Data Tables
Topic 6B: Determine Potential Outcomes Using Scenarios
Topic 6C: Use the Goal Seek Feature
Topic 6D: Activate and Use the Solver Tool
Topic 6E: Analyse Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Topic 7A: Use Advanced Chart Features
Topic 7B: Create Sparklines
Course Objectives
Upon successful completion of this course, students will be able to:
  • Work with multiple worksheets and workbooks simultaneously.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Apply conditional logic.
  • Audit worksheets.
  • Use automated analysis tools.
  • Present your data visually.

Who is this course for?

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Requirements

Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:
  • Microsoft Excel Introduction
  • Microsoft Excel Intermediate

Career path

Being proficient in Excel can open the door to many career opportunities such as:
  • Administrative Assistant
  • Data Analyst
  • Accountants
  • Financial Analyst
  • Retail Store Manager
  • Project Manager
  • Business Analyst
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel Advanced with Certificate - Onsite/In-Company-3035530865

Description

Course Content
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic 1A: Use 3-D References
Topic 1B: Use Links and External References
Topic 1C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic 2A: Collaborate on a Workbook
Topic 2B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic 3A: Apply Data Validation
Topic 3B: Work with Forms and Controls
Topic 3C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic 4A: Use Lookup Functions
Topic 4B: Combine Functions
Topic 4C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic 5A: Trace Cells
Topic 5B: Search for Invalid Data and Formulas with Errors
Topic 5C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic 6A: Determine Potential Outcomes Using Data Tables
Topic 6B: Determine Potential Outcomes Using Scenarios
Topic 6C: Use the Goal Seek Feature
Topic 6D: Activate and Use the Solver Tool
Topic 6E: Analyse Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Topic 7A: Use Advanced Chart Features
Topic 7B: Create Sparklines
Course Objectives
Upon successful completion of this course, students will be able to:
  • Work with multiple worksheets and workbooks simultaneously.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Apply conditional logic.
  • Audit worksheets.
  • Use automated analysis tools.
  • Present your data visually.

Who is this course for?

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Requirements

Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:
  • Microsoft Excel Introduction
  • Microsoft Excel Intermediate

Career path

Being proficient in Excel can open the door to many career opportunities such as:
  • Administrative Assistant
  • Data Analyst
  • Accountants
  • Financial Analyst
  • Retail Store Manager
  • Project Manager
  • Business Analyst
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Excel PivotTable-3035530865

Description

Pivot Table Fundamentals
What is a Pivot Table?
When and why use a Pivot Table?
Anatomy of a Pivot Table
Limitations of Pivot Tables
Creating Basic Pivot Tables
Preparing your data
· Tabular Layout
· Removing Section Headings
· Removing Repeated Column Groups
· Eliminating Gaps
· Type Formatting
Creating Pivot Tables
· Adding Fields
· Adding Layers
· Altering Structure
· Report Filters
Managing Changes in Your Source Data
· Dynamic Named Ranges
· Dealing with Zeroes
Subtotals
Summary Calculations
· Running totals
· Differences (year on year, month on month)
· Percentages of Rows, Columns, Totals and other fields
Running Totals and Top 10 reports
Pivot Table Tools
· Layout Updates
· Refreshing & Restarting
· Moving Pivot Tables
Pivot Table Views
Conditional formatting
Sorting, Filtering and Re-ordering
· Slicers (2010 / 2013 only)
Saving Custom Views
Pivot Table Calculations
Calculated Fields and Items
Managing & maintaining Pivot Table calculations
Pivot Charts
What is a Pivot Chart?
Creating a Pivot Chart
Pivot Chart Rules
· Managing the underlying data
· Adding Layers
· Altering Structure
Pivot Chart Alternatives
· Dynamic Charts
· Transition tables
Working with Data Sources
Consolidating multiple sheets or ranges of data
Using external data sources (Access)
Automating Pivot Tables with Macros
Introducing Macros
Recording Pivot Table macros
Tidying and refining recorded macros
The Power Pivot add-in (2010 / 2013 only)

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel Introduction-3035530865

Description

This course contains the following modules:

Getting Started with Microsoft Excel
- Starting Out
- About Workbooks
- Exploring your Workbook
- Getting Help with Excel

The Excel Interface
- The Quick Access Toolbar and File Menu
- The Home Tab
- The Insert Tab
- The Page Layout Tab
- The Formulas Tab
- The Data Tab
- The Review Tab

Microsoft Excel Basics
- Working with Excel
- Basic Excel Features
- Moving your Data
- Smart Tags and Options Buttons
- Editing Tools

Editing your Workbook
- Enhancing a Worksheets Appearance
- Cell Formatting
- Conditional Formatting

Printing and Viewing your Workbook
- Using the View Tab
- Managing a Single Window
- Managing Multiple Windows
- Printing your Workbook
- Print Page Layout options

Working with Charts in Excel
- Using Recommended and Standard Charts
- Chart Elements
- Chart Tools - Design & Format

'

Who is this course for?

The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel - Macros and VBA-3035530865

Overview

Learn to automate your most repetitive tasks at the push of a button with Microsoft Excel Macros and VBA. In this online course, you will learn to create powerful Excel Macros using VBA (Visual Basic for Applications) to really make Excel work for you. With no prior programming experience required, you'll have your daily spreadsheets running like clockwork to save you hours of time and boost your productivity.

Description

  • Understand the differences between Excel Macros and VBA.
  • Run your macro from the Macro dialog, a keyboard shortcut or worksheet button.
  • Understand the syntax and structure that make up a valid Excel macro.
  • How VBA Objects and the Objects model relate to each other.
  • Using step vs run in entry level debugging.
  • How to create variables and assign strings, values or objects.
  • Implementing logic tests in VBA.
  • Set up looping with Do loops and Do While loops.
  • Create a VBA Message Boxes.
  • Set up an error trap in VBA to handle errors.
  • Create a User Defined Function (UDF).
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Advanced Microsoft Data Analysis Toolkit-3035530865

The courses this bundle will cover:
Advanced Microsoft Excel:
  • Use advanced graphs in minutes instead of wasting hours trying to figure them out
  • Increase interactivity by automating your spreadsheets with macros and VBA
  • Solve complex problems with superpower functions
  • Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
  • And more!
Advanced Microsoft Access:
  • How to effectively link to other data sources.
  • How to split a database by splitting the frontend and backend.
  • To create and maintain macros.
  • The use of Visual Basic for Applications (VBA).
  • Advanced options for the use of forms.
  • Packaging your application for distribution.
Advanced Microsoft VBA:
  • Advanced methods for automating tedious Excel jobs.
  • How to write and implement Excel events.
  • How to modify a variety of standard behaviours, such as double-clicking, opening files and saving files.
  • How to design and implement specialised classes of objects.
  • How to customise the right-click menu within cell ranges.
  • External libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
  • How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code
Microsoft Power BI:
  • How to use the Query Editor to transform and morph data into the right format for your reporting purposes.
  • How to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.
  • How to share dashboards and reports, with colleagues, business partners and potential clients.
  • How to use Power BI’s sophisticated security features to control the exact content your audience can view.
  • How to use Power BI Desktop, Service and Mobile Apps
  • How to connect with a variety of data sources


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel for Accountants Diploma Certification-3035530865

Description

Benefits of studying the Microsoft Excel Course
There are various advantages for those who work towards earning a Microsoft Excel certificate online.
These include some of the following:
  • Build great charts. Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells
  • Use conditional formatting
  • Help identify trends
  • Bring data together
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Intensive Microsoft Excel Course-3035530865

Description

Lesson One: Opening the Excel 2013 program, identifying the elements of the opening screen, creating a worksheet with text and numbers, entering addition formulas, adjusting column widths, using the SUM function in a formula, using the AutoSum feature, editing text and numbers, navigating a workbook and worksheets, saving, naming and closing a workbook, opening an existing workbook, exiting Excel.
Lesson Two: Applying bold, italic and underline formats, changing font type and size, using the mini toolbar, changing the font colour, selecting and formatting cells ranges, selecting columns and rows, aligning cell contents horizontally, using merge and centre, applying number formats, printing the active worksheet, creating a new folder, saving a workbook with a different name and file
type, viewing files in the open dialog box, using AutoFill, entering formulas for subtraction, multiplication, division and percentages.
Lesson Three: Inserting and deleting rows and columns, hiding and unhiding rows and columns, minimizing the ribbon, modifying column widths and row heights, aligning cell contents vertically, wrapping and indenting text, applying a fill colour, applying borders, undo and redo, moving and copying cell contents using drag and drop, moving and copying cell contents using cut, copy and paste, copying formats using format painter, clearing formats.
Lesson Four: Using AutoComplete, changing text orientation, selecting non-adjacent data, freezing and unfreezing panes horizontally and vertically, using Zoom, page break preview, page layout view, naming a worksheet, inserting and deleting a worksheet, repositioning worksheets, using the count function, saving a workbook as a template, creating a workbook from a template, online templates.
Lesson Five: Using styles to format a worksheet, creating a custom cell style, using themes to format a workbook, creating and saving a custom theme, deleting a custom theme, page orientation, adjusting margins and scaling, centring the sheet horizontally and vertically, print preview and print a worksheet, viewing/hiding gridlines and row and column headings, printing gridlines and row and column headings, setting and clearing a print area, using COUNT, AVERAGE, MAX and MIN functions, using Quick Analysis,
sorting columns in ascending and descending order.
Lesson Six: Inserting and formatting headers and footers, inserting header and footer codes including date, page number and file name, copying and pasting data between worksheets, grouping and formatting multiple worksheets, switching between workbooks, viewing multiple workbooks, inserting and applying styles to a column, line and pie chart, using recommended charts, changing chart type.
Lesson Seven: Creating more complex formulas, calculating percentages, making a cell reference absolute and knowing when this is needed, displaying all formulas on a worksheet, customizing and viewing calculations in the status bar, the insert function dialog box, using the NOW, TODAY and IF functions, the function library, adding, viewing and editing comments, adding and deleting a button on the Quick Access toolbar.
Lesson Eight: Displaying a hidden worksheet, using the PMT and FV functions, recognizing errors, using the IFERROR function, creating 3D formulas.
Lesson Nine: Inserting column, line and pie charts, moving a chart to a new worksheet, add, reposition and remove chart elements, adding and removing a data table, switching chart rows/columns, changing chart layout options, selecting and formatting chart
elements , inserting sparklines, inserting moving, resizing and rotating pictures, making picture ‘corrections’ and applying picture styles and effects, aligning multiple objects, inserting and formatting WordArt, inserting and modifying shapes, creating and modifying SmartArt.
Lesson Ten: Using Spell check text in a worksheet, using Filter to display specific data, finding and replacing text and formats within a worksheet, saving a workbook as a web page, inserting and using hyperlinks in a worksheet, using conditional formatting in a
worksheet, customizing the ribbon.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Financial Modeling with Microsoft Excel-3035530865

Description

This Financial Modeling using excel course gives you an overview of Financial Modeling. It focuses on calculations, assumptions, projections and applications of financial modeling. The course is divided in two sections. Each of these modules in the Financial Modeling using Excel course provides in-depth knowledge of the concepts.
  • Financial Modeling using excel – An overview – This is an introductory section where you understand what is meant by financial modeling and the objective of the course.
  • Financial Modeling using excel – This section is the main part of the course which deals with various aspects of financial modeling and the use of excel to complete the task. In this section, you will gain understanding about the procedure to prepare a financial model from scratch using excel.
  • You will also be learning about major financial statements, diagrams, charts and their interpretation with the help of a case study.
  • The case study makes you understand about schedules, how they are used to analyze the financial statements and to forecast the financial health of the company.
  • The tutorial is designed to help you build an advanced financial model (step by step guide), understand the key links of Income statement, balance sheet and cash flow statement.
  • The aim of the course is to make you understand the financial statements of a company, analyzing the same, forecasting and projecting the future financial decisions for the company.
What are the requirements / pre-requisites to learn Financial Modeling using Excel?
There is no pre learning required to learn financial modeling course. This unique Financial Modeling using excel course from eduCBA starts from the scratch and is easy to understand. If you want to upgrade your skills or want to make your career in financial management field, this is the right course for you. Though sound understanding of basic finance and accounting concepts, could be advantageous to learn the course. If you have already learnt financial fundamental concepts, terminology, valuation concepts, general business procedures, the course is easy to learn. If you know how to use basic excel functions, it could be added advantage.
Don’t get disappointed if you don’t know any (or a few things) of the above mentioned things. The course starts from scratch and covers all the basics of financial modeling and MS Excel in detail.
Who should attend this online financial modeling using excel course?
The course is completely suitable for everyone who wants to understand the financial modeling in depth and understand the mechanics of company valuation with the help of the latest technology (Excel). In this course you will learn in detail about financial modeling using excel with the help of a case study. You must take this course if you want to demonstrate superior excel skills at work from day one. The course is ideal for professionals, students, financial analysts, researchers and managers. You can also consider many career options after learning it thoroughly.
  • This unique course is suitable for people in banking, business planning and strategy, commercial banks, equity research, project management, investment banking, equity research, private finance companies, accountants, portfolio managers, risk managers and all those who are or want to be a part of finance department in any kind of organization.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

MICROSOFT OFFICE EXCEL - INTRODUCTION-3035530865

Description

Starting Excel and some of its basic navigation and help controls.
Topics covered:
Starting Out
  • About Workbooks
  • Exploring your Workbook
  • Getting Help with Excel
Learning outcomes:
A look at the Ribbon interface and the different tabs and options the Ribbon offers.
Topics covered:
  • The Quick Access Toolbar and File Menu
  • The Home Tab
  • The Insert Tab
  • The Page Layout Tab
  • The Formulas Tab
  • The Data Tab
  • The Review Tab
Working with a Workbook, its cells, columns and rows.
Topics covered:
  • Working with Excel
  • Basic Excel Features
  • Moving your Data
  • Smart Tags and Options Buttons
  • Editing Tools
Understanding formatting features and enhancing a workbook's overall appearance and using Conditional Formatting.
Topics covered:
  • Cell Formatting
  • Conditional Formatting
  • Enhancing a Worksheet's Appearance
Exploring Excel's printing and viewing options enhancing your ability to print and work with your data effectively.
Topics covered:
  • Using the View Tab
  • Managing a Single Window
  • Managing Multiple Windows
  • Printing your Workbook
  • Print Page Layout options
Introducing charts within Excel and explain how to create basic charts to help convey your data with.
Topics covered:
  • Using Recommended and Standard Charts
  • Chart Elements
Chart Tools - Design & Format

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Automated Information Reporting with Advanced Microsoft Excel VBA-3035530865

Description

Course Unit 1: Building Applications with Advanced Microsoft Excel VBA
  1. Visual Basic Editor
  2. Objects, Methods, Properties
  3. Programming Tools
  4. The Menu Bar
  5. Running Code
  6. Run mode and Design mode
  7. Running Code from the development environment & the host application
  8. The Project Explorer
  9. Using the Project Explorer
  10. The Properties Window
  11. Changing a Property
  12. Using Constants
  13. Excel & Variable Constants
  14. Excel Objects
  15. Objects, Properties and Methods
  16. Getting & Setting Properties
  17. Calling Methods
  18. Passing Arguments
  19. Singular Objects & Collections of Objects
  20. Variables
  21. Dimensioning a variable
  22. Using variables in routines
  23. Object Variables
  24. Using Visual Basic Functions
  25. InputBox Function
  26. MsgBox Function
  27. Using a Set Statement
  28. Building Formula Control Structures
  29. If…Then Decision Structures
  30. Logical Operators
  31. Select Case Decision Structures
  32. Case Else
  33. Comparison Operators with Select Case Structure
  34. For… Loops & Do Loops
  35. While…Wend Statement
  36. UserForms
  37. Designing & Creating Forms
  38. Working with Controls
  39. Creating Custom Dialog Boxes
  40. Userform Properties Methods & Events
  41. Event Handling
  42. VBA Editing & Debugging
  43. Auto Macros
  44. Error Handling
Course Unit 2: Management Information Reporting (MIR)
1. Decision Making
• Effective Decision Making
• Steps to Making Effective Decisions
2. Introduction to Management Information Reporting
• Sources of Information and Data
• Uses of Management Information Reporting
3. Enterprise Performance Management
• Defining and Communicating Strategy
• Measuring Performance
• Analysing Performance
• Reporting and reviewing Performance
• Aligning People and Culture
4. Organisational Level and Reports
5. Key Performance Indicators
• What are Key Performance Indicators
• Benefit of KPI’s
• KPI Planning
• KPI metrics
• Identify KPI
6. HR metrics
• Turnover Rate
• Cost Per Hire
• Human Capital ROI
• Inventory to Sales Ratio
7. Service Level Agreement
• Introduction to SLA
• Why SLA is important to Management Information Reporting
• How to use and apply SLA to reports
8. Financial Metrics
9. Marketing/Sales Metrics
10. Designing and Planning Management Information Reports
• Approach to Data Reporting
• Accessing and updating live data from underlying accounting systems
• Implementing key performance indicators and benchmarking
• Building a tailored front end reporting system
• Drill down by different sectors, departments, timeframes or any other user defined variables
• Producing a budgeting model
11. Data Analysis lifecycle
• Using Information and Data Strategy to Analyse Business Objects
12. Data Sources
• Transactional Data
• Business operational Data
• Lifestytatic Report
13. Static Reports
14. Data Preparation and how to identify and deal with missing values
• Importing and Exporting Data
15. Quality Assurance
16. Identifying the right Chart
• Proportion of the Whole
• Column Charts
• Bar Charts
• Line Charts
• Combination Charts
• Sparkline, Data Bars
17. Identifying what you want to say
• Proportion of the Whole
• Trend Analysis
• Relationships
• Comparison
• Distribution
18. Trend Analysis
• Visualisation of trend Analysis
19. Data Visualisation in report
• Common Data visualization Issues
20. Pattern Recognition in Data and Charts
21. Database types
• Transactional Database
• Analytical Database
22. Introduction to Data Warehousing
• Definition of Data Warehousing
• Benefits and challenges of Data Warehousing
• Data Warehousing architecture
• Data mart
• Star Schema
• Snowflake Schema
23. Balance scorecards
24. Dashboards
• What is a Dashboard
• Categorizing Dashboards
• Establishing the user Requirement for Dashboard
• Building a Dynamic report
• Creating Dashboards using Power Pivot Tool
• Creating visually appealing dashboards and group summaries
25. Customer-Based Reports
• Customer Segmentation
• Behavioural analysis
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Excel Charting-3035530865

Description

Excel Charting Concepts
Understanding chart terminology
- Identifying chart elements (such as like plot area, chart area, gridlines, and legends)
- Selecting the right chart type
- Understanding the Ribbon and the Design, Layout, and Format tabs
Creating Basic Charts Quickly
- Selecting data to display as a chart
- Creating charts instantly with shortcuts
- Creating presentation-ready charts with just a few adjustments
- Creating graphic-in-cell charts with Sparklines
Fine-Tuning Charts with Design Tab Choices
- Switching rows and columns for a different view of the data
- Setting a default chart type and creating a template
- Dealing with empty and hidden cells
- Choosing a chart style from 48 colourful variations
- Changing the location of a chart
- Moving and resizing a chart
Layout Tab Options
Inserting Pictures, Shapes, and Text Boxes
- Using pictures as chart elements
- Adding shapes and arrows
- Adding floating text and text boxes
Adding Titles, Labels, and Legends
- Adding and editing chart titles
- Adding horizontal and vertical titles
- Linking titles to content
- Showing different scales
- Specifying the position of tick marks and axis labels
- Changing the numeric format on labels
- Adding, editing, and removing legends
- Adding and editing data labels
- Showing the source of a chart's data
Using Axes and Gridlines
- Modifying axis scaling
- Working with gridlines
Using the Analysis Tools
- Analyzing existing and future data with trendlines
- Adding drop lines
- Adding high-low lines and up-down bars
- Adding error bars
Format Options
Adding Shapes and WordArt Styles
- Selecting shape fill and outline
- Adding shape effects
- Applying WordArt styles
Using Other Formatting Tools
- Formatting lines and borders
- Filling an area with a colour gradient
- Specifying line style and weight
- Working with chart text
- Changing the rotation of chart text
Adjusting Specific Chart Types
- Column, line and pie charts
- Area, stock, and XY charts
- Doughnut, bubble, and radar charts
- Creating a Waterfall chart
Changing a Chart's Data Source
-Pasting new data into a chart
-Creating charts from multiple data sources
-Adding new data using a table
Printing and Sharing Charts
- Printing charts
- Copying and linking charts with Word and PowerPoint

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Excel For Accountant-3035530865

Description

What skills will I learn?
  • Gain an overview of Excel solutions for accountants and how best to use them
  • Understand graphs and pivot tables for accounting use
  • Understand discounting and compounding
Course Description:
This online training course is comprehensive and designed to cover the key topics listed under the curriculum.
Course Curriculum
1: An Overview Of Excel Solutions For Accountants – Level 2
2: A Guide To Important Excel Functions
3: The Time Value Of Money - Discounting And Compounding
4: Validation Of Data And Form Controls
5: Ratio Analysis 2- Statistical Analysis
6: Graphs For Accounting Use
7: Pivot Tables – Level 2
Course Duration:
You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.
Method of Assessment:
At the end of the course, learners will take an online multiple choice question assessment test. The online test is marked straight away, so you will know immediately if you have passed the course.
Certification:
Successful candidates will be awarded a certificate for Excel For Accountant – Level 2.
Why Choose Us?
  • Our courses represent outstanding value for money
  • High quality e-learning study materials and mock exams.
  • Each course is designed by industry experts, using an innovative interactive learning approach.
  • Includes step-by-step guided videos tutorials.
  • Benefit of applying NUS extra Discount Card.
  • 24/7 Access to the Online Learning Portal.
  • Anytime & Anywhere Learning.
  • Recognised Accredited Qualification.
  • Access Course Content on Mobile, Tablet or Desktop.
  • Study in a user friendly, advanced online learning platform.
  • Excellent customer service and administrative support.

Who is this course for?

  • School Lavers
  • Job Seekers
  • Acountants
  • Bookkeepers
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Office Excel - Advanced-3035530865

Description

Learning outcomes:
MODULE 1: Grouping & Outlining and Subtotals Learning outcomes: Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.Topics covered:
  • Outlining and Grouping Data
  • Using the Subtotals Tool
MODULE 2: What-If Analysis Learning outcomes: Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.Topics covered:
  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver
MODULE 3: PivotTables Learning outcomes: Creating Pivot Tables in order to display and summarise large quantities of data effectively.Topics covered:
  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers
MODULE 4: Charting Pivoted Data Learning outcomes: Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.Topics covered:
  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart
MODULE 5: Advanced Excel Tasks Learning outcomes: Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.Topics covered:
  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks
MODULE 6: Creating HLOOKUP and VLOOKUP Functions Learning outcomes: Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.Topics covered:
  • Using the VLOOKUP Function
  • Using the LOOKUP Function
MODULE 7: Introduction to Macros in Excel Learning outcomes: Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.Topics covered:
  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Data Reporting and Visualisation with Advanced Microsoft Excel-3035530865

Description

  1. Decision Making
  • Who Are Decision Makers
  • Effective Decision Making
  • Steps to Making Effective Decisions
  1. Introduction to Management Information Reporting
  • Basic understanding and purpose
  • Sources of Information and Data
  • Uses of Management Information Reporting
  1. Enterprise Performance Management
  • Defining and Communicating Strategy
  • Measuring Performance
  • Analysing Performance
  • Aligning People and Culture
  1. Organisational Level and Reports
  • Reporting and reviewing Performance
  • Understanding business goals
  1. Key Performance Indicators
  • What are Key Performance Indicators
  • Strategic Vision and Objectives
  • Benefit of KPI’s
  • KPI Planning
  • KPI metrics
  • Identify KPI
  1. HR metrics
  • Turnover Rate
  • Cost Per Hire
  • Human Capital ROI
  • Inventory to Sales Ratio
  1. Service Level Agreement
  • Introduction to SLA
  • Why SLA is important to Management Information Reporting
  • How to use and apply SLA to reports
  1. Financial Metrics
  • Understand Financial Metrics
  • Benefits that you can get working with metrics
  • Data set-up
  1. Marketing/Sales Metrics
  • Understand Financial Metrics
  • Benefits that you can get working with metrics
  • Data set-up
  1. Designing and Planning Management Information Reports
  • Approach to Data Reporting
  • Type of Reports
  • Accessing and updating live data from underlying accounting systems
  • Implementing key performance indicators and benchmarking
  • Building a tailored front end reporting system
  • Drill down by different sectors, departments, timeframes or any other user defined variables
  • Producing a budgeting model
  1. Data Analysis lifecycle
  • Using Information and Data Strategy to Analyse Business Objects
  1. Data Sources
  • Transactional Data
  • Data Flow
  • Quality Assurance
  • Business operational Data
  • Lifestyle Data
  • Importing and Exporting Data
  1. Static Reports
  • Creating Product Performance Reports
  • Analysing Business Performance
  • Working with complex databases
  • Data Validation techniques
  1. Data Preparation and how to identify and deal with missing values
  • Distribution of Data using statisical methods
  • Using various techniques to replace missing values
15. Identifying the right Chart
  • Proportion of the Whole
  • Column Charts
  • Bar Charts
  • Line Charts
  • Combination Charts
  • Sparkline, Data Bars
  1. Identifying what you want to say
  • Proportion of the Whole
  • Trend Analysis
  • Relationships
  • Comparison
  • Distribution
  1. Trend Analysis
  • Visualisation of trend Analysis
  1. Data Visualisation in report
  • Common Data Visualization Issues
  • Dynamic Reports
  • Choosing the right charts
  • Pattern recognition
  1. Pattern Recognition in Data and Charts
  1. Database types
  • Transactional Database
  • Analytical Database
  1. Introduction to Data Warehousing:
  • Definition of Data Warehousing
  • Benefits and challenges of Data Warehousing
  • Data Warehousing architecture
  • Data mart
  • Dimensional Modelling
  • Star Schema
  • SnowflakeSchema
  1. Balance scorecards
  1. Dashboards
  • What is a Dashboard
  • Categorizing Dashboards
  • KPI Dashboard
  • Consumer Based Reports
  • Establishing the user Requirement for Dashboard
  • Building a Dynamic report
  • Creating Dashboards using Power Pivot Tool
  • Creating visually appealing dashboards and group summaries
  • RAG Reports
  1. Customer-Based Reports
  • Customer Segmentation
  • Behavioral analysis
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Intermediate - In-company / Bespoke-3035530865

Description

Quick Recap Using references in Excel formulas
  • Overview of formulas in Excel
  • Relative, Absolute and Mixed cell references
Group editing worksheets
Mastering Excel Tables
  • Introducing Excel Tables
  • Creating Calculated Columns
  • Formatting a Table
  • Using Advanced Table Tools
  • Using Slicers
  • Converting Tables to Ranges
  • Removing duplicates
Using names Ranges
  • In Excel formulas
  • As a way of navigating through the workbook
Advanced Formulas
  • Simple IF examples
  • Using IF to check if a cell is blank
  • Nested IFs
  • VLOOKUP
  • HLOOKUP
  • PMT financial Function
  • Database Functions
  • Text Functions
  • Date Functions
Conditional formatting
  • Apply Conditional Formatting
  • Customising Conditional Formatting
  • Using Icons in Conditional Formatting
Linking spreadsheets and workbooks
  • Making a reference to another worksheet
  • Making a reference to another workbook
  • Editing links
  • Troubleshooting links
Analysing databases
  • Quick analysis
  • Sorting a database
  • Apply filters to a database
  • Advance filter
  • Outline data by levels
  • Sorting and Filtering by Conditional Formats
Charts
  • Analyse trends in data using Sparklines
  • Creating charts from start to finish
  • Available chart types
  • Create a Chart Template
  • Formatting Chart Elements and Styles
  • Filtering Charts by Series or Categories
  • Adding a Trendline to a Chart
Attaching security to a spreadsheet and workbook
  • Protect a worksheet
  • Protect a workbook
Introduction to Pivot Tables
  • What are Pivot Tables?
  • Using recommended pivot tables to analyse your data
Changing Excel’s environment Options

Who is this course for?

For those who want to explore in more detail formulas and functions, data analysis and data presentation.

Requirements

Preferably, delegates would have attended the Excel Introduction course.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Certified Data Science Training using R, SAS and Microsoft Excel-3035530865

Course Objectives
At the end of this course you will be able to
  • Describe the stages of analytics life cycle
  • Use a variety of statistical tools and techniques to analyze data
  • Use such tools to explore data
  • Design, model and manage databases in an effective way
  • Deliver new insights and competitive intelligence
  • Use the SAS software with ease

Description

Section 1 : Analytics Using Excel
Introduction to the Course MS Excel 2010 Advanced
This chapter will provide a brief introduction about Microsoft Excel 2010 advanced
Office Button and Paste Function
This section gives you step by step procedure of using the paste function in MS Excel and it also lets you know the various other paste options.
Sparklines, Custom Ribbons and Screenshots
This section explains what is sparklines, ribbons and how to take screenshots along with examples.
Conditional Formatting and Equation Editor
Lets you learn how to use the new equation editing tool in Excel 2010 and highlight the cells using conditional formatting.
Paste Special
Here you can learn the step by step procedure of using the paste special option in Excel 2010.
Logical functions – IF AND OR
This topic lets you learn how to use Excel’s logical functions IF, AND and OR with few examples.
Arithmetic functions MAX MIN ABS etc
In this chapter you will be learning how to use the mathematical functions in Excel 2010.
COUNT COUNTIF COUNTA COUNTBLANK
This topic will explain all the different count function in Excel the purpose of it along with their specific criteria and examples for each.
Cell Information – IFERROR ISBLANK etc
Here you will learn what is IFERROR, ISBLANK formula is, its syntax, how does it work in Excel 2010and the examples.
CHOOSE Function
This section explains the formula syntax and usage of the CHOOSE function in Microsoft Excel.
VLOOKUP Function
In this you will understand how to use Excel’s VLOOKUP function with example
HLOOKUP Function
This section describes the formula syntax and usage of the HLOOKUP function in Excel with examples.
MATCH & INDEX
This chapter will help you to understand the basics of MATCH and INDEX function in Excel, how and where to use it and how to use MATCH and INDEX function in place of VLOOKUP function.
Database functions – DSUM DAVERAGE DCOUNT
This section explains the more complex versions of the basic SUM functions and helps you to learn how to use Excel D functions with few examples.
OFFSET Function- Understanding basics
This chapter explains how to use the OFFSET function to return the value of a cell in excel and a basic understanding of it.
OFFSET Function – Dynamic nature
This lets you learn how to create and use dynamic range names in Excel using the OFFSET function
FORECAST Function
Here you can understand the formula syntax and usage of the FORECAST function in excel along with its function.
One Dimensional Data Tables
In this chapter you will learn how to create a one variable data table in Excel 2010 with sample values
Two dimensional Data Tables
This section will make you understand how to use two variable data table in Excel 2010.
Solver
This chapter gives a brief introduction about the tool called Solver in Excel 2010 and the step by step procedure to use this tool
Goal Seek
Here you will understand what is Goal Seek feature in Excel 2010 and using What if analysis command in Excel.
Array Function – Introduction
This section gives a quick introduction to arrays and array formulas in Excel 2010
Array Function – Row and Columns
Under this section you will learn the array function with examples in detail.
Array Function – TRANSPOSE
This section gives you the detail of array formula “TRANSPOSE” in detail and how to use it in Excel 2010.
Array Function – FREQUENCY
This explains how to calculate the frequency distributions in Excel 2010
PROPER UPPER LOWER LEFT RIGHT MID
This chapter is a quick guide on how to use various text related functions like PROPER UPPER LOWER LEFT RIGHT MID in Excel 2010
FIND CLEAN REPT CONCATENATE
Explains these text functions in detail along with examples
Pivot Tables
This section explains how to create or delete a pivot table in Excel
Pivot Table Filter – Slicer
This chapter explains how to use Slicer to filter Pivot table data in Excel 2010.
Pivot Charts
Under this section you will learn how to produce a pivot chart report in Excel 2010.
Naming Dynamic Ranges
This section will help you in creating and checking dynamic named ranges using OFFSET function in Excel 2010
Naming a Cell and a Range
In this section you will learn how to name a cell or a cell range in Excel 2010 with example.
Auditing Toolbar
This lets you know how to use auditing toolbar to investigate spreadsheets in Excel
Watch Window
Here you can learn how to use watch window to inspect, audit or confirm formula calculations and results in larger worksheet
Group Boxes and Options Button
This is an tutorial on how to add group box or a frame control to a worksheet
Check Boxes
This topic lets you to learn how to create and use a check box in worksheet. It also lets you to know how to insert multiple check boxes
List Boxes and Combo Boxes
In this section you will learn how to use list box and combo box in a worksheet in Excel 2010
Scroll Bar and Spinners
This topic lets you learn how to add a scroll bar or a spin button to a worksheet in Excel
Text to Columns
You can learn how to use combinations of text functions to extract from one cell and copy it into other cells
Grouping Tabs
In this chapter we will learn the step by step process to group and ungroup worksheets in Excel 2010
SUBTOTAL Function
This chapter tells you how to use SUBTOTAL function syntax in Excel and mentions its arguments
Hyperlinks
Here we will learn how to use and stop automatics hyperlinks and how to use special characters in hyperlinks in Excel 2010
Data Validation
In this section we will see how to add data validation in Excel sheets
Random Numbers
This tutorial lets you understand how to use the Excel RAND function with its syntax and few examples
Custom View
This topic tells you how to use custom view to save specific display settings and filter data and columns
Protecting – Worksheet and Workbook
Here you will learn how to password protect your worksheet or workbook elements
Excel 2010 Sparklines
It explains what is sparklines and how to use them
Range Charts Type 1
In this section you will learn how to create a chart and customize it
Range Charts Type 1- Continued
The various types of charts are explained with examples
Range Charts Area Type 2
This helps you to create type 2 charts and customize it
Range Charts Area Type 2- Continued
Type 2 charts are explained with examples in this section
Funding Graph
Creating a budget graph in excel can be learnt in this chapter
Two Axis Graphs
This will show you how to create a two axis graph in Excel 2010
Scenario Graphs
Here you will understand how to evaluate scenarios with Excel using Graphs
Scenario Graphs Continued
The formation of scenario graphs is explained with examples
Average Line
This section tells you how to add average line chart in excel
Bar to Pie Chart
Lets you learn to create bar and pie charts in Excel 2010
Combo Charts
This chapter explains how to create a combination chart and how to represent data in a combination chart
Creating Histograms
You will know how to use the histogram tool in excel and how to present your data in Histogram
Invert Negatives
Here you will learn how to change positive numbers into negative in excel and how the negative values can be converted into chart
Scrolling Chart
Gives step by step guide to create a scrolling chart in Excel 2010
Scrolling Chart Continued
Examples of scrolling chart is given in this section


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel Professional In Company Training-3035530865

Description

This course contains the following modules:

Advanced Conditional Formatting
- Editing Standard Formatting Rules
- Using Formulas in Conditional Formatting

Using Form Controls and Templates
- Using Form Controls
- Creating Templates

Advanced Lookup Functions
- Using the Index Function
- Using the Match Function
- Using Index and Match Together
- Using Index and Match with Array Formula
- Using the Indirect Function

Advanced Functions in Excel
- Using Error Functions
- Using Logical Functions
- Using Array Formulas
- Using Rounding Functions

Advanced Pivot Table Tools
- Importing Pivot Table Data
- Calculated Fields in Pivot Tables
- Showing Pivot Data as a Percentage
- Creating Custom Pivot Tables Styles

Introduction to User Defined Functions Using VBA
- Creating a User Defined Function
- Creating an Interactive Procedure
- Create and Share a Function Add-in


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Office Fundamentals: PowerPoint and Excel-3035530865

Overview

With so much communication to contend with today, it can be difficult to grab people's attention.

Description

Course Description:
With so much communication to contend with today, it can be difficult to grab people's attention. So, to grab and maintain an audience's focus we need to be clear, organised, and engaging. And, that is exactly what Microsoft Office PowerPoint can help you do by creating engaging, dynamic multimedia presentations With the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming very challenging. Fortunately, this is where Microsoft Office Excel can help. Excel can help you organise, calculate, analyse, and present your data in simple way and in less time, than if using pen-and-paper methods or non-specialised software. This course aims to provide you with a foundation for Excel knowledge and skills.

Who is this course for?

This course is designed for students who wish to gain a foundational understanding of Microsoft PowerPoint and Excel that is necessary to create and develop engaging multimedia presentations, and to create and work with electronic spreadsheets.

Requirements

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders.

Career path

 Get started with Microsoft Office Exc· Prepare to deliver your presentation · Add graphical elements to your presentation · Perform advanced text editing operations · Develop a PowerPoint presentation · Identify the basic features and functions of PowerPoint ·Upon successful completion of this course, students will be able to:  Print workbooks· Perform calculations ·el


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel: Essential Excel Functions-3035530865

Description

The Microsoft Excel Masterclass course is designed for professionals that want to learn the ins and outs of excel to help boost your productivity and skills for work.
If you are looking at this course, you already have some experience with excel but don’t really know how to use essential excel functions.
There are so many different buttons and features in excel that it can become really overwhelming, confusing and frustrating.
If you don’t understand how to really use excel, you’ll slowly get left behind. This course will encourage you to take the next step in separating yourself from your peers by learning how to really use excel.
Microsoft Excel Masterclass will cover the following topics:
Topic 1 - Starting Off
  • Introduction To Excel 2013
  • Recap Of Software Layout
Topic 2 - Home Tab
  • Home Tab
  • Wrap Text And Cell Format
Topic 3 - Insert Tab
Topic 4 - Page Layout Tab
  • Page Sizing
  • Gridlines
  • Bring Forward & Send Backward
Topic 5 - Formulas Tab
  • Function Dropdowns
  • Trace Precedents & Dependents
  • Formula Checking
  • Calculation Options
Topic 6 - Data Tab
  • Sorting & Filtering
  • Text To Columns
  • Data Validation
Topic 7 - Review Tab
  • Protect & Share Workbooks
Topic 8 - View Tab
  • Freeze Panes & Split
Topic 9 - File Tab
  • New & Open
  • Saving
  • Printing
Topic 10 - Options
  • Share, Export, & Options
  • Formula Options
  • Proof & Save Options
  • Language & Advanced Options
  • Copy Paste & Chart Options
  • Display Options
  • Formula & Calculation Options
  • Toolbar Options & Add-ins
Topic 11 - Math
  • Simple Math
  • Functions Using Cells
  • Using Parenthesis
  • Sum & Average
  • Min, Max, Absolute Value
  • Trig Functions
  • Inverse Trig
  • Convert
  • Degrees & Radians
  • Exponential Function
  • Future Value
  • Future Value Example
  • Present Value
  • Complex Numbers
  • Logarithms
  • Square Root
Topic 12 - Data Set Functions
  • Correlate
  • Count & Countblank
  • Greatest Common Denominator
  • If Function
  • Info
  • Least Common Multiple
  • Median
  • Mode
  • Slope
  • Standard Deviation
  • Random Number
  • Randbetween
  • Rounddown & Roundup
Topic 13 - Graphs & Charts
  • Inserting Graphs
  • Vertical Formatting
  • Manage Graph Data
  • Using Select Data Source
  • Modifying Graphs
  • More Axis Options
  • Graphing Equations
  • Improving Graph Display
  • Additional Graph Features
  • Changing Chart Types
Topic 14 - Tables & Data
  • Formatting Tables
  • Cell Borders
  • Excel Tables
  • Excel Table Freeze Pane
  • Excel Table Sorting
  • Trendlines
Topic 15 - Example Sheets
  • Timesheet Setup
  • Timesheet Calculation
  • Equation Example
  • Equation Example With Name Manager
  • Equation Calculation
  • Dragging Calculations
  • Timeplot Profiles
  • Matrix Math
  • Complex Calculation Example
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Office 365 Online Versions-3035530865

Description

What you will learn:
  • Office 365 versions and features
  • Bullets, numbering and styles
  • Data entry and navigation
  • Screen layout
  • Configuring Outlook online
  • One Note Desktop
Why study online?
Technological improvements and advances in educational design mean that studying online is no longer just a low-cost alternative to traditional training methods. In many respects, our online courses offer training which is superior to the majority of available “classroom” options.
Not only is the effectiveness of the training process enhanced, but also the convenience and overall cost efficiency of studying online make it a compelling option for training. You can learn at your own pace and can repeat each section as many times as required unlike in a classroom environment.
Studying at your own pace, rewinding and going over the material as often as you need improves your long-term memory retention and makes studying more rewarding.
Curriculum for the Microsoft Office 365 Online Versions course:
What Is Microsoft 365?
Introduction to 365
A Little Background on MS Office
Office 365 Versions and Features - Part 1
Office 365 Versions and Features - Part 2
Online Sign-Up
Word Online
Word Online Overview
Starting a document in Word Online
Word saved to OneDrive
Navigating
Tools and Features
Fonts Attributes - Part 1
Fonts Attributes - Part 2
Lines and Paragraphs - Part 1
Lines and Paragraphs - Part 2
Bullets, Numbering and Styles - Part 1
Bullets, Numbering and Styles - Part 2
Inserts, Pictures and Tools - Part 1
Inserts, Pictures and Tools - Part 2
Tables and Formatting - Part 1
Tables and Formatting - Part 2
Sharing and Templates - Part 1
Sharing and Templates - Part 2
Excel Online
Excel Online Overview
Getting Started with Excel
Data Entry and Navigation
Data Entry - Part 1
Data Entry - Part 2
Data Entry and Formatting - Part 1
Data Entry and Formatting - Part 2
Intro to Formulas
Formulas - Part 1
Formulas - Part 2
Formulas - Part 3
Intermediate Formula and Table Format - Part 1
Intermediate Formula and Table Format - Part 2
More Formula and Charts - Part 1
More Formula and Charts - Part 2
Charts
Sheets and Templates
PowerPoint Online
What is PowerPoint?
Screen Layout
Entering and Formatting Text
Layouts and Designs - Part 1
Layouts and Designs - Part 2
Inserting Objects around
Objects and Transitions
Animations
Smart Art
Notes Printing and Templates
Outlook Online
Intro to Outlook Online
Intro to Email Accounts Screen Layout
Configuring Outlook Online
Sending Emails Outlook Online
Organization Outlook Online
Mail Rules in Outlook Online
Additional Mail Options in Outlook Online
Spam & Junk Outlook Online
One Note Online
What is one Note?
One Note Screen Overview
One Note Desktop
Drawing Tools with One Note
Send to One Note
Media with One Note
Please note that the official exam is not included, however for those who complete the course, they will receive a completion certificate upon request.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Office Specialist with Career Program-3035530865

Description

Course syllabus
  1. Microsoft Office Specialist (MOS) 77-725: Word 2016 (1 EXAM)
  2. Microsoft Office Specialist (MOS) 77-727: Excel 2016 (1 EXAM)
  3. Microsoft Office Specialist (MOS) 77-729: PowerPoint 2016 (1 EXAM)
  4. Microsoft Office Specialist (MOS) 77-731: Outlook 2016 (1 EXAM)
  5. Microsoft Office Specialist (MOS) 77-730: Access 2016 (1 EXAM)
COMPLETE THE ENQUIRY FORM TO SEE A FULL BREAKDOWN OF THE COURSE SYLLABUS
Features of GMetrx system included in this course

GMetrix practice tests for MOS certification are designed to replicate the certification exam experience so test-takers can better prepare themselves for test day. The online practice tests use the same exam format as the certification exams and are mapped to the certification objectives so a test-taker is assured that he/she is learning and practicing the skills that will help him/her pass the certification exam. The student may take up to 100 MOS practice tests within a 12 month period.
Key Features:
  • GMetrix accurately replicates a “live application” testing environment.
  • Enhances learning through self-paced practice questions.
  • Builds familiarity with the testing environment.
  • Enhances confidence towards certification exams.
  • Better prepares students to pass certification exams.
GMetrix test modes explained

Testing Mode:

Students experience what the certification exams will be like. Timed practice test present scenario to perform just like the actual certification exam.
Training Mode:

Students work at their own pace as they receive feedback and step-by-step instructions for each question. The practice test titles available in your bundle include:
  1. MS Excel 2016
  2. MS Word 2016
  3. MS PowerPoint 2016
  4. MS Access 2016
  5. MS Outlook 2016
How long do I have to complete the course?

You have 12 months to complete the courses and take the exams.

Who is this course for?

  • Anyone looking to gain a series of Microsoft Office Specialist certifications.
  • Anyone looking to secure a job role based around Microsoft Office.
  • Anyone looking to upgrade their Microsoft Office skills.
  • Anyone looking to utilise our Career Program and get Microsoft Office Specialist certified.

Career path

  • Administrative Assistant
  • Executive Assistant
  • Administrative/Office Manager
  • Personal Assistant (P.A.)
  • Secretary/Receptionist
  • Microsoft Office Trainer
  • Desktop Designer
  • Data Entry Officer
  • Bookkeeper
  • Excel Administrator
  • Excel Analyst
  • Excel Data Analyst
  • Excel Specialist
  • PowerPoint Designer
  • PowerPoint Specialist
  • Word Specialist
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Querying Microsoft SQL Server 2012 (Microsoft 70-461 Course) -3035530865

Microsoft 70-461: Querying Microsoft SQL Server 2012
What will I learn?
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and alter views (simple statements).
  • Design views.
  • Create and modify constraints (simple statements).
  • Create and alter DML triggers.
  • Work with Data
  • Query data by using SELECT statements.
  • Implement sub-queries.
  • Implement data types.
  • Implement aggregate queries.
  • Query and manage XML data.
  • Modify Data
  • Create and alter stored procedures (simple statements).
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Combine datasets.
  • Work with functions.
  • Troubleshoot & Optimise
  • Optimise queries.
  • Manage transactions.
  • Evaluate the use of row-based operations vs. set-based operations.
  • Implement error handling.
Why not try the training before you buy
Get access to a free trial of the course, explore different learning segments and get an exact idea how the training is delivered.
Credit towards the new MCSA SQL Server 2012
ITonlinelearning’s courses follow official Microsoft curriculum and Microsoft 70-461 Querying Microsoft SQL Server 2012 course contributes a credit toward the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification, which ITonlinelearning also offers.
What do I Get?
  • Expert, instructor-led training delivered via video streaming
  • Extensive demonstrations and presentations delivered in a multimedia format
  • Practice tests and full exam simulators
  • Unlimited access to the course for 1 year
What Next?
Enquire today! Our Advisors can answer any questions you have and set up your learning page as soon as you are ready to start your studies.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Expert-3035530865

Description

Course Content
Lesson One: Using AutoFill, carrying out date calculations, adding a picture as a watermark, creating and working with tables, converting text to columns, removing duplicates, using Flash Fill, consolidating data, using paste special, creating a custom format
Lesson Two: Defining, using and managing named ranges, using named ranges in formulas, inserting, modifying and removing hyperlinks, formatting elements of a column and pie charts, saving a chart as a template, creating combination chart, using functions: ROUND; SUMIF; SUMIF; IF; IFERROR; AND, using the IF function nested with OR
Lesson Three: Using conditional formatting, editing a conditional formatting rule, using the Rules Manager, formatting cells meeting a specific condition, applying more than one conditional formatting rule, sorting data using cell attributes, filtering data.
running a macro from the Quick Access Toolbar, deleting macros, using data validation, tracing precedent/dependent cells in a worksheet, evaluating formulas, tracing errors.
Lesson Five: Summarising data using subtotals, using database functions, grouping and ungrouping data, creating a pivot table, refreshing pivot table data, filtering information in a pivot table, formatting pivot table data, creating and using a slicer, formatting a slicer, creating and using a timeline, using recommended pivot tables
Lesson Six: Using the VLOOKUP function, inserting an embedded object into a spreadsheet, inserting a linked object into a spreadsheet, using paste special to create a link between programs, linking Excel workbooks, using the scenario manager, setting up data tables
Lesson Seven: Protecting worksheet cells, applying and removing passwords, setting file properties, sharing workbooks, merging workbooks, tracking changes, accepting or rejecting changes, using the Document Inspector, marking a workbook as final
Lesson Eight: Using statistical functions: COUNTA, COUNTBLANK, COUNTIF, using text functions: PROPER, UPPER; LOWER, TRIM, LEFT, MID, RIGHT, CONCATENATE, using financial functions: PV; NPV; RATE, using nested functions


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

 

 

Microsoft Excel PivotTable Course-3035530865

Description

Why Pivot Tables?
Excel can feel daunting – in particular, the infamous PivotTable™ function, which is widely spoken about and little understood. In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.
But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.
What you get with this Mircosoft Excel PivotTable course:
  • 39 modules of training that teach you to master the PivotTable™ function
  • Multiple videos, practice exercises and test questions to aid your learning.
  • You’ll be confident using a pivot table to analyse complex data sets after completing this course.
In this course you will learn:
  • The primary uses of pivot tables
  • How to identify the best and worst data sets
  • To filter, sort and group PivotTable™ data to maximise its usefulness
  • How to present your data clearly using PivotCharts and Conditional Formatting
Sample content:More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft 70-461: Querying SQL Server 2012-3035530865

Overview

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.
This course provides the knowledge and understanding for some of these important job functions:
  • Apply built-in scalar functions
  • Apply ranking functions
  • Combine datasets
  • Creates and alters
  • Design T-SQL stored procedures, views
  • Implementing aggregate queries, error handling, sequence generation and data types
  • Manage transactions
  • Modify data by using INSERT, UPDATE, DELETE and MERGE statements
  • Optimizing queries
  • Query data using SELECT statements and Managing XML data
  • OUTPUT clause to return data
This learning course provides the knowledge for the 70-461 Exam on Queries on Microsoft SQL Server 2012:
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and alter views (simple statements).
  • Design views.
  • Create and modify constraints (simple statements).
  • Create and alter DML triggers.
  • Work with Data
  • Query data by using SELECT statements.
  • Implement sub-queries.
  • Implement data types.
  • Implement aggregate queries.
  • Query and manage XML data.
  • Modify Data
  • Create and alter stored procedures (simple statements).
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Combine datasets.
  • Work with functions.
  • Troubleshoot & Optimize
  • Optimize queries.
  • Manage transactions.
  • Evaluate the use of row-based operations vs. set-based operations.
  • Implement error handling.


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft PowerPoint-3035530865

Description

  • Course Syllabus includes 34 lessons covering beginner, intermediate and advanced levels
  • · Interface and Basics
  • Launching PowerPoint and choosing a Theme
Use a professionally designed template to save time creating a presentation.
  • Adding Slides, changing Layouts and exploring the Outline
Add slides, which are the building blocks of a presentation, and understand how layouts can provide you with quick ways to insert content aligned on your slide.
  • Exploring PowerPoint’s Views
The different PowerPoint views allow you to work on different parts of your presentation such as slides, slide thumbnails, text and running your presentation as a slideshow.
  • Getting familiar with the Notes pane
A very clever location to add extra text to a slide that your audience may not see, but you can use as an aid when presenting or as printed handouts.
  • Customizing the PowerPoint interface
Find and add menu items and buttons that you frequently use to your ribbon or quick access toolbar to give you faster access to the PowerPoint features you probably use the most.
  • Changing Themes and Colors
Quickly change the colors, fonts, effects or design of your entire presentation in almost a single mouse click.
  • · Adding Text and Shapes
  • The Content Placeholder and Bullet Levels
Use placeholders to quickly add content to your slides including text, diagrams, and charts – so that you can later change the location and proportions of these objects, often with a single mouse click.
  • Formatting Text
Format text in your presentation so that it is legible and perhaps even pleasant to look at!
  • Adding and manipulating Shapes
Add and work with shapes, which are one of the most important building blocks on a slide, including rectangles, ovals, and triangles.
  • Duplicate and add multiple Shapes
Reuse existing, formatted shapes to save time inserting shape content on your slides.
  • Align and Distribute Shapes
Align and distribute shapes (and other content) so that they are correctly positioned to quickly balance the content on your slides and prevent the same objects on different slides jumping to different locations during a slideshow.
  • Group and Ungroup Shapes
Group various shapes together into a single slide object to help you position the group of shapes in a specific location, while still gaining access to the size and formatting options available within PowerPoint for those individual shapes.
  • · Pictures
  • Working with Pictures
Since a picture is really worth 1000 words, add pictures, change their appearance and do so much more with these fundamental slide objects.
  • Remove Picture Backgrounds
Make the selected part of a picture transparent to either cleverly crop parts of the picture, or make parts of the picture transparent to overlay in front of other pictures without obscuring them.
  • Photo Album
Quickly add multiple pictures to a presentation even in the format of two or four pictures per slide.
  • · Info-graphics and Media
  • Introducing SmartArt
Insert, add text to, and format SmartArt graphics to quickly add diagrams to your presentation which will assist you to tell your story.
  • Adding and editing Charts
Select the right chart for your data, add it to a slide, know the basics of editing charts and quickly format charts.
  • Advanced Chart Options
Understand and work with the tricky parts of charts such as axes and legends.
  • Structure your Tables
Add tabular data to your presentation in the form of a table and change the table’s appearance.
  • Adding Audio
Insert sound on your slides so that your presentation can play music, narration or other sound effects.
  • Adding Video
Insert video into your presentation and use various formatting options such as soft edges, or 3-D bevels to make your video really stand out.
  • · Animations and Transitions
  • Less is More
Have the confidence to know exactly what to animate without driving your audience crazy.
  • Basic Animation Types
Just like an actor, make objects enter the stage, exit, move around the stage and maybe even gain the attention of your audience in the correct way.
  • Events and Speed
Make your animated objects speed up or slow down, or play with or without your intervention, depending on which you desire.
  • Motion Path Animations
Make an object move along a defined or custom path to enhance the engagement of your audience or explain in animated form very complex topics.
  • Transitions
Add smooth or exciting transitions between slides to increase the smoothness and continuity of your slideshow into an almost movie-like format.
  • · Slide Tasks
  • Duplicating and Reordering Slides
Reuse existing slides in your current presentation to save development time, as well is changing the order in which your slides play within a slideshow.
  • Reusing and Copying Slides
Reuse existing slides from another presentation, and retain the theme of that presentation if you wish.
  • Working with Slide Sections
Group your slides into common concepts or thoughts to help build your storyline, as well is quickly move all of the slides within that group to a new area of your presentation.
  • Reset – the magic button
When you work extensively on a chart, picture or slide and it doesn’t turn out exactly how you wish, quickly reset it back to what it was originally.
  • · Delivering your presentation
  • Printing Slides
Quickly print your slides professionally to give to your audience, or create PDFs to distribute either before or after the slideshow.
  • Rehearsing Slides
“Practice makes perfect” – so rehearse your slides and practice the delivery of your presentation.
  • Exploring Slide Show Options
Before you present your slideshow, set your show up to present in a variety of ways with the confidence that little will go wrong.
  • Using Presenter View
Use a special PowerPoint view so that even though your audience can only see the slide show, you can view slide timings, slide notes and even a preview of the next, upcoming slide.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel - Advanced-3035530865

Overview

Have some experience with Microsoft Excel and want to improve your skills? This online course will help you learn intermediate and advanced Microsoft Excel techniques.
In 25 engaging Microsoft Excel lessons you will learn how to find a value with VLOOKUP, create and format Pivot Tables, record basic Macros and more.
  • Microsoft Excel 2016, 2013 and 2010 compliant
  • Award winning Microsoft MVP instructor Ken Puls
  • Certificate of training upon completing the course
  • Accredited with CPD UK
  • Bite sized video tutorials, cheat sheets, exercise files and quizzes
  • Unlimited testing
  • Self-paced course can be completed in your own time over 12 months

Description

Course Syllabus includes 24 intermediate/advanced level lessons
  • Essential Formula Knowledge - Understand the most common and essential formula categories in Excel and how to use them.
  • Understanding Dates - Understand how dates work in Excel using the TODAY, YEAR, MONTH, DAY and DATE functions.
  • Understanding Time - Understand how time works in Excel, and how to change from whole numbers into time increments and back again.
  • · Intermediate Formula Knowledge - Learn more advanced formulas and gain a deeper understanding of how Excel formulas work.
  • Formula Auditing - Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.
  • Temporal Functions - Learn to work with the EOMONTH and EDATE functions that easily shift dates from one month or year to another.
  • VLOOKUP with Approximate Match - Learn to use VLOOKUP to find an approximate match and return it or the corresponding value from another column.
  • VLOOKUP with Exact Match - Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column.
  • Other Lookup Methods - Learn to work with INDEX, MATCH and HLOOKUP, as alternatives to the VLOOKUP function.
  • · Optimizing Data - Get your data into a usable form and unleash Excel's most powerful tools with it.
  • Naming Ranges - Learn about creating named ranges, and the benefits of doing so.
  • Excel Tables - Learn about creating Excel tables, and their advantages.
  • Recording Macros - Learn to record basic Excel macros to automate your actions (instead of doing them manually).
  • · Data Analysis - Analyze, summarize and highlight data quickly and easily using Excel's PivotTables.
  • Creating PivotTables - Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data).
  • Formatting PivotTables - Learn to control formatting and other options in PivotTables.
  • Calculated Fields in PivotTables - Learn to create and modify basic calculated fields for PivotTables.
  • What-If Analysis - Learn to perform what-if analysis in Excel using the Scenario Manager and Goal-Seek.
  • · Presenting and Reporting - Interpret your data and turn it into information using Excel's advanced formatting tools.
  • Outlining - Learn about adding and working with Excel’s outlining tools to quickly hide irrelevant sections of your worksheet.
  • Custom Number Formats - Learn to build your own custom number formats to display dates, values and variances how you want to see them.
  • Conditional Formats with Built-In Rules - Learn to create top/bottom and highlight cell rules, as well as to apply icon sets and data bars.
  • Conditional Formats with Custom Rules - Learn to create custom conditional formatting rules based on formulas.
  • Building Combination Line and Area Charts - When you want to graph 3 line series, but only want 2 in focus most of the time.
  • · Validating and Updating - Increase the integrity and longevity of your spreadsheet so that the right data is entered and can be easily updated.
  • Data Validation - Learn how to use Data Validation to ensure that users enter valid data in input cells.
  • Styles - Learn how to apply built-in number styles and create your own custom styles packages.
  • Preparing to Deploy - Set up Excel's aesthetics, including preparing to print, and protect your spreadsheet's key components.
  • Custom Views - Learn how to create and manage Custom Views in a worksheet.
  • Page Setup Options - Learn about page setup options, fitting print jobs on a page, headers and footers, and other ways to customize print jobs.
  • Security Considerations - Learn about the setup and weaknesses of Excel’s security systems.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Basic-3035530865

Overview

  • Microsoft Excel 2013 and 2010 compliant
  • Award winning Microsoft MVP instructor Ken Puls
  • Certificate of training upon completing the course
  • Accredited with CPD UK
  • Bite sized video tutorials, cheat sheets, exercise files and quizzes
  • Unlimited testing
  • Self-paced course can be completed in your own time over 12 months

Description

Course Syllabus includes 24 beginner level lessons
Getting to know Excel - Find your way around and learn the basics of Excel.
  • The Ribbon - Understand the terminology and elements of the Ribbon.
  • The Work Surface - Understand the main terms used to describe Excel’s work canvas.
  • Navigation - Navigate the Excel Interface and learn how to select cells and ranges.
  • First File - Create your first Excel file, enter data and create a table.
  • Formatting - Make information look more attractive in Excel.
  • Basic Math - Work with basic mathematics in Excel.
Essential Formula Knowledge - Understand the most common and essential formula categories in Excel and how to use them.
  • Formula Anatomy - Understanding Excel Formula Anatomy
  • Cell Referencing - Learn about working with absolute and relative cell referencing, and techniques for copying formulas.
  • Function Anatomy - Use to understand the anatomy of Excel functions, and what their components mean.
  • Math Functions - Learn basic math functions including SUM, ROUND and SUBTOTAL.
  • Basic Statistics - Learn basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE.
  • Logic Functions - Learn to build standalone logical IF functions, and make them more complex by nesting AND and OR within them.
  • Text Functions - Learn to break apart text with the LEFT, RIGHT, MID, FIND and SEARCH functions, and to combine text with the & character.
Intermediate Formula Knowledge - Learn more advanced formulas and gain a deeper understanding of how Excel formulas work.
  • Conditional Math - Learn to use SUMIF, COUNTIF and SUMPRODUCT to add cells only when certain conditions are met.
  • External Links - Learn about creating and updating external links, and about the potential dangers of external links in Excel.
Optimizing Data - Get your data into a usable form and unleash Excel's most powerful tools with it.
  • Sorting - Learn to sort data in Excel by a single column or by multiple columns.
  • Filtering - Learn to filter Excel data for specific words, dates, and apply multiple filters to a single data table.
  • Contiguous Data - Learn tricks for consolidating your data so it's vertically contiguous (without blank rows) – for Tables, PivotTables and Charts.
Presenting and Reporting - Interpret your data and turn it into information using Excel's advanced formatting tools.
  • Cell Formatting - Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells.
  • Building Column Charts - Learn how to create an effective column chart by reducing ink and 'noise' that distract from the main messages.
  • Building Bar Charts - How to create an effective bar chart by reducing ink and noise that distract from the story.
  • Building Pie Charts - Learn how to build an effective pie chart, and when you should and shouldn’t use them.
  • Building Line Charts - How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability.
Validating and Updating - Increase the integrity and longevity of your spreadsheet so that the right data is entered and can be easily updated.
  • Comments - Learn about creating, reviewing and printing Excel comments.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Project Training-3035530865

Description

Course Description:
This online MS Project Training course has been designed for 10 guided learning hours.
Course Curriculum : Microsoft Project Training
1.Introduction to project management
2. Managing project cost
3.Data exchange
4. Customising data
5. Sharing customisation
6.How to work with multiple projects
Method of Assessment:
At the end of the course learners will also take online multiple choice question assessment tests. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Certification:
Successful candidates will be awarded certificate for MS Project Training.
Benefits you will gain:
By enrolling in this course, you’ll get:
  • High-quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • Includes step-by-step tutorial videos and an effective, professional support service.
  • 24/7 Access to the Learning Portal.
  • The benefit of applying for NUS extra Discount Card.
  • Recognised Accredited Qualification.
  • Access Course Content on Mobile, Tablet or Desktop.
  • A study in a user-friendly, advanced online learning platform.
  • Excellent customer service and administrative support.

Who is this course for?

  • This entry-level course typically attracts attendees looking to develop an understanding of the MS Project Software.
  • It is recommended that individuals have basic experience with the Windows operating system and some understanding of Project management.
  • It is recommended to individuals who would like to start working as a Project coordinator, Project Manager or Project Assistant or any position related to Project Management.

Requirements

  • This course is available to all students, of all academic backgrounds. However, basic knowledge of Microsoft Project would be an advantage.
  • Learners should be ages 16 or over to undertake the qualification.
  • Basic understanding of English language, literacy, numeracy and ICT are required to attend this course.

Career path

  • Project Analyst
  • Project Coordinator
  • Project Manager
  • Business Developer

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

 

Touch Typing and Shorthand Certificate - CPD Accredited-3035530865

Description

What you will learn
This course teaches you:
  • Different styles of typing and how they impact speed and quality
  • How to train your fingers and brain to create muscle memory for effective touch typing
  • The basic finger position and posture needed to prevent injury and aid typing speed
  • Key drills for each hand to gradually build up the neurological connections needed for touch typing
  • The ancient origins of shorthand and why written script is inefficient
  • The theories and practical development of your own short hand style
Benefits of taking this course
After taking this course you will:
  • Have an enhanced typing speed and a foundation for accuracy and quality
  • Undo bad typing habits and develop a posture that ensures long term safety
  • Understand exactly how to enhance your note taking speed and apply it to your role
  • Have a personal reference book of shorthand abbreviations you can use immediacy
  • Have systematic and regular practices to continually improve typing and shorthand
  • Feel confident in your ability to effectively and efficiently take notes and record information
Modern business relies on the effective capture of information, but most people are wasting time and effort doing it ineffectively. Learning to touch type and write with shorthand can easily double your productivity, while empowering your fingers to do the hard work frees up your brain to think more clearly. Free you mind and speed up your work with touch typing and shorthand today.
Course Modules/Lessons
Module 1: Touch Typing Fundamentals
  • Understand the development of typing and keyboard layout
  • Learn about the different styles of typing and how they impact speed and quality
  • Understand the benefits of touch typing both mentally and physically
  • Discover how to train your fingers and brain to create muscle memory
Module 2: Touch Typing Practice
  • Introduce the basic finger position and posture needed to prevent injury and aid typing speed
  • Learn how to position and reposition the fingers on the home row and use the key bumps
  • Practise key drills for each hand to gradually build up the neurological connections needed
  • Increase finger dexterity and muscle memory by introducing each row at a time
Module 3: Shorthand Fundamentals
  • Discover the ancient origins of shorthand and understand why written script can be inefficient
  • Learn about the two most common styles of shorthand in use today and their evolution and derivations
  • Test your own natural writing speed and grasp the major benefits and pitfalls of shorthand writing
  • Understand the need for specialist equipment and be able to choose what is most suitable
Module 4: Shorthand Theory and Practice
  • Learn the basic Pitman stroke theory and practise some simple outlines
  • Find out how to simplify words to convey meaning without vowels
  • Practise the Teeline alphabet and use it in combination with word simplification
  • Discover how abbreviation can rapidly enhance your note taking speed and effectiveness
Module 5: Personal Development
  • Learn how to improve your typing skills with regular practice and personal development
  • Learn about the evolution of keyboards and how they suit specific individuals and tasks
  • Discover different technologies which can assist your typing development
  • Discover equipment and software for transcribing efficiently

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad


Touch Typing Course CPD Accredited
-3035530865

Overview

Our Touch Typing Course is very flexible and is taken anywhere that you have a broadband internet connection. The touch typing programme teaches the key technique required to be a successful typist. The training is done through an interactive typing training programme.
Remember that many online training programmes do not calculate your typing speed accurately. Therefore, when you are tested by employers or recruitment agencies, you will be surprised to have a lower speed than the other online programmes had stated.
This online training programme uses an accredited method of typing speed certification. This means that you will get an accurate typing speed that reflects the tests delivered by recruitment agents and employers.
The Training is Accredited by the CPD Institute and has assisted many Admin, Secretarial, PA and other related types of professional in boosting their careers and earning potential.

Description

The course moves forward at your own pace and requirements. It provides many practical exercises to help you learn the techniques for typing and builds your typing speed.
It can be used by all levels. It will teach beginners the basic and build a foundation for touch typing.
However, advanced typists can use the exercises to build their speed and accuracy.
You can opt to gain certification for your typing online or if you prefer you can go into our Training Centre and take an official test speed.

Who is this course for?

This course is ideal for anyone who is looking to build their typing speed. This is fundamental for Secretaries, PAs, EAs, Legal Secretaries, Medical Secretaries, Receptionists, Administrators, Admin Assistants and any other types of administrative roles.

Requirements

There are no requirements. You must have broadband internet access, however.

Career path

A strong typist can open up options to move into jobs for Secretaries, PAs, EAs, Legal Secretaries, Medical Secretaries, Receptionists, Administrators, Admin Assistants and any other types of administrative roles. You will find that you will be able to apply for jobs as a good typists that few can apply for, as they cant type fast enough.
This makes you more employable and command greater wages.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Touch Typing & Shorthand Training Course-3035530865

Description

What you will learn
  • Different styles of typing and how they impact speed and quality
  • How to train your fingers and brain to create muscle memory for effective touch typing
  • The basic finger position and posture needed to prevent injury and aid typing speed
  • Key drills for each hand to gradually build up the neurological connections needed for touch typing
  • The ancient origins of shorthand and why written script is inefficient
  • The theories and practical development of your own short hand style
Benefits of taking this course
After taking this course you will:
  • Have an enhanced typing speed and a foundation for accuracy and quality
  • Undo bad typing habits and develop a posture that ensures long term safety
  • Understand exactly how to enhance your note taking speed and apply it to your role
  • Have a personal reference book of shorthand abbreviations you can use immediacy
  • Have systematic and regular practices to continually improve typing and shorthand
  • Feel confident in your ability to effectively and efficiently take notes and record information
Modern business relies on the effective capture of information, but most people are wasting time and effort doing it ineffectively. Learning to touch type and write with shorthand can easily double your productivity, while empowering your fingers to do the hard work frees up your brain to think more clearly. Free you mind and speed up your work with touch typing and shorthand today.

Who can take the course?
Anyone who has an interest in learning more about this subject matter is encouraged to take the course. There are no entry requirements to take the course.

What is the structure of the course?
The course is broken down into 5 individual modules. Each module takes between 20 and 90 minutes on average to study. Although you are free to spend as much or as little time as you feel necessary on each module, simply log in and out of the course at your convenience.

Where / when can I study the course?
You can study the course any time you like. Simply log in and out of the web based course as often as you require. The course is compatible with all computers, tablet devices and smart phones so you can even study while on the move!

Is there a test at the end of the course?
Once you have completed all modules there is a multiple choice test. The questions will be on a range of topics found within the modules. The test, like the course, is online and can be taken a time and location of your choosing.

What is the pass mark for the final test?
The pass mark for the test is 70%. If you don’t pass the test first time you will get further opportunities to take the test again after extra study. There are no limits to the number of times you can take the test. All test retakes are included within the price of the course.

When will I receive my certificate?
Once you have completed your test you can log in to your account and download/print your certificate any time you need it.

How long does it take to complete the course?
We estimate that the course will take about 7 hours to complete in total, plus an additional 30 minutes for the end of course test. But, of course, practice will go on much longer!Course Content
  • Module 1: Touch Typing Fundamentals
  • Module 2: Touch Typing Practice
  • Module 3: Shorthand Fundamentals
  • Module 4: Shorthand Theory and Practice
  • Module 5: Personal Development

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Type Typing - Learn to Touch Type the Fun Way! -3035530865

Description

Whatever industry you work in, in whatever role – from secretarial and admin to supervisory and managerial roles – keyboard skills are essential if you wish to get your job done quickly, accurately and professionally. With this course, not only will you see your typing speed noticeably increase, but your typing accuracy will improve, too.
Cover Three Different Aspects
Sign up to this course and you will be able to make real improvements in three areas – the QWERTY keyboard, the Numeric Keypad and Single Case letters. Master these three key skill areas and you will be able to demonstrate your keyboard abilities with pride. Work through the three units and you will substantially increase your productivity, with expected results of in excess of 5000 key depressions per hour (kdph), once the 30 hours of QWERTY training is complete. A sought after skill bound to impress any employer!
KEY LEARNING POINTS
This course would be perfect for novice typists and anyone wishing to brush up on their keyboard abilities, whether for the benefit of their current job role or for future career aspirations. Competent typists may also benefit from the course, due to the self-paced, specifically designed courses.
Regardless of what position in a business you hold, keyboard skills are essential, and this course will help you to improve your abilities dramatically.
  • Get to grips with the Numeric Keypad, and how to touch type using the keypad quickly and accurately. Three exercises are available in this unit.
  • Learn how to use upper and lower case on the QWERTY keyboard, including the use of the ‘Shift’ key, with the help of 29 different exercises.
  • Work your way through a variety of hands-on exercises which can help you apply your new-found knowledge to master the keyboard and keypad with ease and precision.
  • Master single case letters, which help you to demonstrate a high standard of touch typing without worrying about the ‘Shift’ key. This unit consists of 26 exercises.
ADVANTAGES OF THIS COURSE
  • Study online at a pace that suits you with our online course delivery. Resources are available 24/7, 365 days a year.
  • Course is valid for a full 12 months, so there’s no need to rush. Take your time (and take breaks!), and improve your typing skills at your own convenience.
  • Technical support is available if you run into difficulty using the courseware at any point.
  • Scoring and tracking tools help you to monitor your progress and visually see your typing speed and accuracy improve.
  • Interactive typing tutors ensure you can enjoy self-paced training which is flexible and hands-on.
  • Plenty of exercises to help you build on your keyboard skills, including 26 exercises in single case training.
  • Gain the confidence and capability required to type with speed and accuracy. You won’t have to look at your keyboard to type, ever again!
  • Add a valuable core skill to your CV and demonstrate your new-found abilities to future employers, increasing your employability substantially.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Typaz with Pitman Training-3035530865

Description

Course Content
  • The course comprises 10 keyboard lessons to introduce and consolidate the alphanumeric keys. Punctuation and symbols are also covered.
  • Artificial intelligence built into the software creates a learning path tailored to each individual.
  • Friendly guidance encourages and helps with any difficulties, providing extra exercises to eliminate weaknesses. It creates a unique course for you, based on your strengths and weaknesses.
  • Guidance on ergonomics and good technique.
  • Comprehensive, easy to understand accuracy and speed feedback.

Who is this course for?

This course is aimed at anyone wanting to develop their skills in typing. A large majority of jobs, especially office-based jobs, involve the use of computer keyboards.
Suitable for beginner to intermediate level learners.

Requirements

No prerequisites.

Career path

Examples of jobs which commonly involve typing:
  • Data Analyst
  • Secretary
  • Receptionist
  • Executive PA
  • Administrator
  • Audio typist
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

-3035530865Keyboard Speed Development

Description

About Pitman
Pitman Training has led the way for growth in development and efficiency within the workplace since 1837 – when Sir Isaac Pitman invented Shorthand. Since then the business has developed to incorporate modern technologies and advances. Keeping true to the heritage of the brand, the key focus is to arm our students with the skills they need to get the jobs that they want.
Nowhere in the world offers anything like Pitman Training - because our students receive a unique combination of benefits.
Whether you're interested in secretarial, Microsoft Office, keyboard skills, book-keeping and accounts, IT or any of our other courses, our training is designed to help both boost your confidence and enhance your skills.
  • Your CV will stand out from the crowd
    Sir Isaac Pitman invented shorthand in 1837 and since then we’ve enjoyed an unrivalled reputation; highly respected by employers. When you've trained the Pitman Training way, you're already a cut above the rest.
  • You can train anytime, full-time or part-time
    We don't have rigid course timetables with fixed terms, like many others, which means training can fit around your work and home lives.
  • Handy city and town centre locations
    There's nothing more convenient. We're easy to get to so it's simple for you to pop in just when you need to - and we're open six days a week*. Some of our courses can also be done remotely online.
  • Help and support along the way
    Experienced course advisors are always on hand to help. Our exceptional levels of support and guidance mean whenever you need advice or encouragement, we'll be right there by your side.
Whether you want to improve your career prospects with one of our highly respected diplomas, gain that promotion, get back to work or simply stand out from the crowd, Pitman Training can help you like nobody else can.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Essential Skills for Designers - Working with Type Course-3035530865

Course Outline
Chapter 1 INTRODUCTION TO TYPOGRAPHY 20:10
1 Introduction
2 Examples of Use of Type
3 What Is a Font?
4 Types of Fonts
5 How to Choose a Font?
Chapter 2 ADDING AND EDITING TYPE 26:30
1 Typing
2 Adding Type
3 Choosing and Changing Color
4 Editing Type and Useful Keyboard Shortcuts
Chapter 3 ADVANCED TYPE TECHNIQUES 40:01
1 Text Frames
2 Text Frame Options
3 Text Warp
4 Type on a Path
5 Type Inside an Object
6 Drop Caps
7 Customize Fonts
8 Wrap Text Around an Object
9 Character and Paragraph Styles

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Secretary PA Diploma CPD Accredited-3035530865

Description

The course provides sound foundation skills to understand the Secretarial /PA role; builds confidence; enables early entry to job market through creating junior job readiness.

Course Content:
  1. Secretary PA Course
  • Job functions of a PA
  • Diary Management
  • Business Letter Writing foundation
  • CV Development
  • Composing Faxes, Memorandums and E-mails
  • Telephone skills
  • Making Travel/Hotel Arrangements
  • Filing Systems
  • Time Management
  • Invoicing/Petty cash
  • Client Care
  • Complaint Handling
  • Work Planning
  • Document Presentation and proofreading
  • Confidence building
  • Typing and audio skills to proficient level or further if you already touch type
2. Microsoft Office Diploma
Choose three Microsoft Office Courses:
  • Excel
  • Word
  • PowerPoint
  • Outlook
  • Access
This can be done on a flexi-time basis over 3 months.

Who is this course for?

This course has been taken by numerous successful PAs who have used the expert training to launch their careers. We have graduates in many great PA and Executive Assistant roles around London and further afield.
The course is ideal for anyone looking to become a PA or for PAs who are looking to build their CV with an accredited qualification.

Requirements

At least a good level of secondary education. There are no set pre-requisites. If in doubt ask us.

Career path

This course is aimed at people who are new to Legal Secretarial work and are looking to start successful career in Law.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Adobe Photoshop, Illustrator and Graphic Design Bundle Course-3035530865

Description

Adobe Photoshop is a raster graphics editor that allows both professional and amateur artists, designers, and photographers to create and manipulate art, graphics, photos and 3D designs. On the other hand, Adobe Illustrator is a vector graphics editor that is helpful for creating logos, icons, sketches, typography and other vector art.
The course illustrates the major tools and features of this two software so that you can work with the software and can able to create both vector and raster images.
Course Design
This course is designed with the following modules:
Adobe Photoshop
Getting Started
  • Introduction
  • The Photoshop CS3 Screen
  • File Management Basics
  • Modifying Your Photoshop Layout
  • Getting Help
Exploring Photoshop
  • Introduction to the Photoshop Toolbox
  • Using Tool Presets
  • Introduction to the Photoshop Palettes
  • Getting Started
  • Printing your Image
Images and Color
  • Understanding Digital Images
  • Image Size and Resolution
  • Working with Your Canvas
  • Working with Color
  • Working with Color Tools
Image Basics
  • Making Selections
  • Manipulating Selections
  • Editing with Selections
  • Adjusting Your Image
  • Basic Editing Tools
Adobe Illustrator
  • Illustrator Course Outline
  • The Power of Adobe illustrator
  • Achieve the best learning experience
Illustrator Fundamentals & Basics
  • Illustrator Documents
  • Ilustrator workspaces & Properties Panel
  • Artboards
  • Illustrator Navigation & zooming
  • Illustrator Prefrences & Settings
  • Illustrator Basic geometric shapes
  • Illustrator Transformation & Rotation (resized)
  • Illustrator Pathfinder & shape builder tool
  • Illustrator Selection tools & methods
  • Grouping elements in illustrator
  • illustrator Layers & Arranging elements
  • Illustrator Align & distribute panel
  • Illustrator Gudies, Grids & Rulers
  • Excercise (layers, selection, pathfinder, guides, coloring, Artboards)
Colors, Appearance & Graphic Styles in Illustrator
  • Illustrator Stroke Panel
  • Illsutrator color panels ( color, swatches, themes, guide)
  • Illustrator Gradiant colors panel
  • Illustrator Appearane & Graphic style panels
  • Illustrator effects
  • Excercise (Appearance, Graphic Style, Gradients, strokes)
Drawing Tools & Techniques
  • Illustrator pencil tool
  • Illustrator Brush tool
  • Drawing modes & blob brush tool
  • Illustrator Pen Tools
  • Illustrator curvature tool
  • Pen Tools & curvature tool exercise
  • Illustrator drawing modifying tools
  • illustrator Transform & Liquify tools
  • illustrator puppet warp tool
  • illustrator envlope distort
  • Drawing Symmetric Shapes
  • Drawing Concentric Symmetrical design
  • Illustrator Clipping Masks
  • Illustrator Opacity Masks
  • illustrator live paint bucket tool
  • Recolor Artwork
  • Exercise Complex Drawing
  • Illustrator Complex Drawing techniques explained
Illustrator Brushes
  • Illustrator Art Brushes
  • Illustrator Scatter Brush
  • illustrator Bristle Brush
  • Illustrator Calligraphic brush
  • Illustrator Pattern brush
  • Illustrator Images brushes
  • Exercise (Brushes)
Design With images in illustrator
  • handling images in illustrator
  • images modifications before tracing
  • Tracing images in illustrator
  • Enhancing traced Vectors & coloring hints
  • Exercise (Images)
Typography in Illustrator
  • Illustrator Typography Anatomy & Character control
  • illustrator Paragraphes control
  • Illustrator Chracter & paragraph styles panels
  • Illustrator Fonts (Filtering, Variable, glyphs, stylistic sets, open type panel, svg)
  • illustrator Touch type tool
  • Illustrator type on a path tools
  • Clipping Typography Masks
  • Illustrator Typography Art directions & trending visual effects
  • illustrator type envlope distort
  • illustrator text wrap-
  • Exercise (Typography Composition)
Illustrator Advanced Techniques & Tricks
  • Illustrator blend tool
  • illustrator perspective drawing
  • 67 Illustrator Symbols-
  • Creating Patterns in Illustrator
  • illustrator Graphs
  • illustrator gradiant mesh
Exporting & Finalizing Artwork in illustrator
  • exporting illustrator files & save for web
  • Preparing & exporting illustrator file for printing
  • Illustrator Asset Export panel
  • Creative cloud & libraries
  • Illustrator export for screens, save for web & Archiving files
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Secretarial Diploma-3035530865

Description

Core Subjects:
Typing (choose from a selection – 20 – 70 words per minute)
Effective Business Communication (business letters, email, phone and presentations)
or Business Document Production (routine and complex business documents)
Audio Transcription
Microsoft Word
or Microsoft Word Expert (advanced word processing skills including mail merge, creating graphs, creating and running macros, creating an index, table of contents and more)
Microsoft Excel
or Microsoft Excel Expert (advanced spreadsheet skills, covering importing and exporting data, creating templates, linking workbooks, data tools, analysis and pivot tables)
Microsoft PowerPoint
Microsoft Outlook
Successful Meetings and Minutes (logistics, preparation, note-taking, agenda planning and how to clarify actions)

Electives (choose two):
Microsoft Publisher (desktop publishing skills to create various publications, inserting text, pictures, frames and tables)
Microsoft Access
Microsoft Word Expert (advanced word processing skills including mail merge, creating graphs, creating and running macros, creating an index, table of contents and more)
Go – Make a Difference!
Health and Safety Essentials
Go – Get that Job!
Book-keeping Level 2 - Module 1 (manual accounts, the basics of VAT, checking invoices, day books, general ledger, purchase ledger and sales ledger, petty cash books and balancing ledger accounts)

Guideline Learning Time
180 hours flexi study or 6 weeks full-time
(Full-time is based on approx 20-30 hours a week)

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Office IT Diploma-3035530865

Description

Typing
We offer a full range of typing courses
whether you’re a beginner or need to
reach top speeds with maximum accuracy.
Effective Business Communication
Learn how to communicate effectively in
business by letter, email, telephone and
presentation. This will cover correct use of
grammar, punctuation, principles of letter
writing and CV writing.
Microsoft Word
Learn word processing skills to a good
business standard. This will enable you to
create professional looking documents,
produce tables, insert pictures and much
more.
or Microsoft Word Expert
Learn advanced word processing skills
including mail merge, creating graphs,
creating and running macros, creating an
index, table of contents and more.
Microsoft Excel
Learn spreadsheet skills to a good
business standard. This course will enable
you to create a spreadsheet, enter data,
formulas and functions; create charts and
more.
or Microsoft Excel Expert
Learn advanced spreadsheet skills,
covering areas such as importing and
exporting data, creating and using
templates, linking workbooks, data
management, using analysis tools and
pivot tables.
Microsoft Outlook
Learn how to share, manage and schedule
information electronically. Covers the use
of email, electronic calendar, scheduling
meetings and appointments; creating and
assigning tasks and creating address lists.
Microsoft PowerPoint
Gain competency in creating slide
presentations. Areas covered include
formatting, inserting tables, pictures,
sound and hyperlinks; applying transition
and timing effects.

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Certificate in Learn Keyboarding Skills Course-3035530865

Course Fast Facts:
  • Only 6 weeks to complete this course
  • Approximately only 2 to 4 hours per week of study is required
  • This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone
  • Instructors lead each course and you will be able to interact with them and ask questions
  • You can study from home or at work at your own pace in your own time
  • You can download printer friendly course material or save for viewing off line
  • You will be awarded a certificate at completion of this course
How to study online course?
Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand.
Course Structure
Through well-crafted lessons, expert online instruction and interaction with your tutor, participants in these courses gain valuable knowledge at their convenience. They have the flexibility to study at their own pace combined with enough structure and support to complete the course. And they can access the classroom 24/7 from anywhere with an Internet connection.
New sessions of each course run every month. They last six weeks, with two new lessons being released weekly (for a total of 12). The courses are entirely Web-based with comprehensive lessons, quizzes, and assignments. A dedicated professional instructor facilitates every course; pacing learners, answering questions, giving feedback, and facilitating discussions.
Recognition & Accreditation
All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email.
The Personal Success Training Program consists of 3 Comprehensive Courses:
  • Course 1: Create Personal Success Online Certificate Course
  • Course 2 - Certificate in Organizational Skills Online Course
  • Course 3 - Certificate in Goal Setting & Getting Things Done Online Course
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

An Introduction to Welding Safety-3035530865

Description

Lesson Plan
  • Welcome and Learning Outcomes
  • Welding Safety
  • Summary
Accreditation
The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines.
Certification
On completion of this course you will be able to download a Virtual College certificate.
Duration
Approximately 2 hours. The length of time taken depends entirely on how quickly you can study and absorb the material. You can proceed as quickly or slowly as you like.
Target Audience
This module is designed to be a pre-requisite for anyone starting a course on welding. By completing this short module and passing the associated online assessment, prospective students have shown they are aware of the key safety issues relating to a potentially dangerous activity.
Entry Requirements
There are no specific entry requirements for this course.
How it Works
What
This is an online course, all the training will be taken through your browser window. There will be no face-to-face sessions with instructors nor will you receive any training material through the post. If you wish you may print out any page of the training material and may also print the notes you took during the training.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

QUICKBOOKS IS A FINANCIAL ACCOUNTING-3035530865

Description

THE TOPICS COVERED IN THIS COURSE INCLUDE:
  • Introduction to Quickbooks
  • Setting up Quickbooks
  • Tools
  • Preferences
  • Email Preferences
  • Users and Security
  • Estimates
  • Sales and Orders
  • Account Receivable
  • Batch Invoicing
  • Customer Deposits
  • Bounced Checks
  • Vehicle Mileage
  • Class Tracking Transactions
  • Receiving Payments
  • Making Deposits
  • Credit Cards
  • Bank Accounts
  • Payroll Preferences
  • Employee Setup
  • Processing Payroll
  • Payroll Tax Forms
  • Job Costing with Payroll
  • Payroll Setup Advance
  • Workers Compensation
  • Special Transactions
  • Memorized Transactions
  • Other Account Types
  • Quickbooks Reporting
  • Advance Reporting
  • Budgets and Forecast
  • Writing Letters in Microsoft Word
  • Converting, Importing and Exporting
  • Quickbooks backup Data Integrity
  • Multi-Currencies
  • Advance Features
  • Update or Upgrade
  • Summary of Quickbooks
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Food Safety and Hygiene for Catering Level 2-3035530865

Description

Lesson Plan
Upon completion of this module learners will have an understanding of a wide range of key food safety issues, including the three main types of food safety hazard, their sources and methods of control. Learners will know the correct temperatures needed for storage and food handling activities from delivery through to sale, and be aware of common food pests and how to control them, along with the principles of cleaning and disinfection and how these apply to the workplace.
The sections covered include:
  • Learning Objectives and an introduction to Food Safety and Hygiene – Food Safety and Hygiene are terms commonly used, here we will look at how they relate to food that has been prepared and served.
  • Impact of Food-Borne Illness – looking at what food-bourne illnesses are and how they affect us.
  • Understanding Food Law – food often has a long journey from growing, harvesting, delivery, preparation through to being eaten. As a result there are many opportunities for it to become contaminated. In this section we look at legislation in place that relates to food hygiene and safety.
  • Food Safety Hazards and Contamination – exploring food safety hazards and how they arise and consider how they can be prevented and controlled.
  • Food Preservation, Storage and Temperature Control - how to preserve food, including appropriate storage and temperature controls.
  • Personal Hygiene – this section looks at why personal hygiene is so important when working with food – from hand washing to legal requirements.
  • Hygienic Premises and Equipment – this section looks at good housekeeping and the part premises and equipment design play in maintaining clean, pest-free conditions.
  • Hazards Analysis and Critical Control Point (HACCP) - it is a requirement of regulations that all businesses implement and maintain a documented Food Safety Management system based on HACCP. This section looks at what this involves.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

The Secret Life of Trees Diploma Course-3035530865

Research highlights the ways trees communicate with each other. The course explores research that has revealed how trees grow and protect their communities, using an underground network. It also discusses “the language of trees”.
Along with being essential to human life, trees also contribute greatly to wellness. The Secret Life of Trees Diploma Course delves into the healing power of trees, highlighting conventional and traditional medicine’s dependency on them. You’ll be introduced to various trees that can be used for your own medicine-making and how to harvest parts of a tree to make teas and poultices, to aid recovery from pain and sickness.
You’ll learn how embracing trees can help balance and build up the strength of your mind, as you discover practices that will deepen your connection with trees. You’ll explore meditation practices, taken primarily from the Taoist tradition of tree meditation, and touch on other traditional and contemporary practices, including the Shaman Tree Dieta practice of some Amazonian tribes and forest bathing.
By the end of the course you will:
  • Understand how important trees are to the life of the planet
  • Have a greater appreciation of the influence trees have had on the world over billions of years
  • Comprehend the significance of trees in world religions and cultures
  • Know how to determine the gender of a tree
  • Be aware of how trees communicate with one another
  • Understand what it means for trees to feel, see, hear, smell and speak
  • Be knowledgeable about which trees are prone to specific health complaints
  • Be able to harvest parts of a tree to make healing teas and poultices
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Receptionist Diploma-3035530865

Description

Typing or Typing Speed
Development
We offer a full range of typing courses whether
you’re a beginner or need to reach top speeds
with maximum accuracy.
Effective Business Communication
This excellent course will raise your game when it
comes to business communication skills. Effective
communication skills are top of the list of qualities
demanded by employers, it’s an essential skill
to master. Split into eight lessons, your business
communication training begins with examining
English language skills before looking at the use of
the appropriate tone.
or Business Document Production
Text processing, whether it’s part of secretarial
training or another discipline, is an integral part
of business document production - an important
aspect of communication skills training. This
course consists of four simple but comprehensive
lessons ensuring you cover every aspect of the
speciality.
Microsoft Word
Learn word processing skills to a good business
standard. This will enable you to create
professional looking documents, produce tables,
insert pictures and much more.
or Microsoft Word Expert
Learn advanced word processing skills including
mail merge, creating graphs, creating and running
macros, creating an index, table of contents and
more.
Microsoft Outlook
Learn how to share, manage and schedule
information electronically. Covers the use of email,
electronic calendar, scheduling meetings and
appointments; creating and assigning tasks and
creating address lists.
Professional Receptionist Seminar*
A one-day seminar which will give the individual
an understanding of the importance of the
receptionist’s role and how to project the best
image for their company.
Elective Courses (choose one)
Typing Speed Development
Microsoft Excel
Telephone Techniques Seminar*
Audio Transcription
Microsoft PowerPoint
SpeedWriting
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

No comments:

Post a Comment