CCTV CAMERAS AND SURVEILLANCE COURSES PROFESSIONAL SECURITY TRAININGS Rawalpindi Islamabad Pakistan

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