Monday, January 6, 2020

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

No comments:

Post a Comment