Monday, January 6, 2020

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


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.


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


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
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


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


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.


  • 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


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