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