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
'
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.
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.
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.
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.
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
- Visual
Basic Editor
- Objects,
Methods, Properties
- Programming
Tools
- The
Menu Bar
- Running
Code
- Run
mode and Design mode
- Running
Code from the development environment & the host application
- The
Project Explorer
- Using
the Project Explorer
- The
Properties Window
- Changing
a Property
- Using
Constants
- Excel
& Variable Constants
- Excel
Objects
- Objects,
Properties and Methods
- Getting
& Setting Properties
- Calling
Methods
- Passing
Arguments
- Singular
Objects & Collections of Objects
- Variables
- Dimensioning
a variable
- Using
variables in routines
- Object
Variables
- Using
Visual Basic Functions
- InputBox
Function
- MsgBox
Function
- Using
a Set Statement
- Building
Formula Control Structures
- If…Then
Decision Structures
- Logical
Operators
- Select
Case Decision Structures
- Case
Else
- Comparison
Operators with Select Case Structure
- For…
Loops & Do Loops
- While…Wend
Statement
- UserForms
- Designing
& Creating Forms
- Working
with Controls
- Creating
Custom Dialog Boxes
- Userform
Properties Methods & Events
- Event
Handling
- VBA
Editing & Debugging
- Auto
Macros
- Error
Handling
Course Unit 2: Management Information Reporting
(MIR)
1. Decision
Making
•
Effective Decision Making
• Steps to Making Effective Decisions
• Steps to Making Effective Decisions
2. Introduction
to Management Information Reporting
• Sources
of Information and Data
• Uses of Management Information Reporting
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
- 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
- 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
- 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
- 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
- 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
- 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
-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
- 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
- Decision Making
- Who
Are Decision Makers
- Effective
Decision Making
- Steps
to Making Effective Decisions
- Introduction to Management Information
Reporting
- Basic
understanding and purpose
- Sources
of Information and Data
- Uses
of Management Information Reporting
- Enterprise Performance Management
- Defining
and Communicating Strategy
- Measuring
Performance
- Analysing
Performance
- Aligning
People and Culture
- Organisational Level and Reports
- Reporting
and reviewing Performance
- Understanding
business goals
- Key Performance Indicators
- What
are Key Performance Indicators
- Strategic
Vision and Objectives
- Benefit
of KPI’s
- KPI
Planning
- KPI
metrics
- Identify
KPI
- HR metrics
- Turnover
Rate
- Cost
Per Hire
- Human
Capital ROI
- Inventory
to Sales Ratio
- Service Level Agreement
- Introduction
to SLA
- Why
SLA is important to Management Information Reporting
- How
to use and apply SLA to reports
- Financial Metrics
- Understand
Financial Metrics
- Benefits
that you can get working with metrics
- Data
set-up
- Marketing/Sales Metrics
- Understand
Financial Metrics
- Benefits
that you can get working with metrics
- Data
set-up
- 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
- Data Analysis lifecycle
- Using
Information and Data Strategy to Analyse Business Objects
- Data Sources
- Transactional
Data
- Data
Flow
- Quality
Assurance
- Business
operational Data
- Lifestyle
Data
- Importing
and Exporting Data
- Static Reports
- Creating
Product Performance Reports
- Analysing
Business Performance
- Working
with complex databases
- Data
Validation techniques
- 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
- Identifying what you want to say
- Proportion
of the Whole
- Trend
Analysis
- Relationships
- Comparison
- Distribution
- Trend Analysis
- Visualisation
of trend Analysis
- Data Visualisation in report
- Common
Data Visualization Issues
- Dynamic
Reports
- Choosing
the right charts
- Pattern
recognition
- Pattern Recognition in Data and Charts
- Database types
- Transactional
Database
- Analytical
Database
- Introduction to Data Warehousing:
- Definition
of Data Warehousing
- Benefits
and challenges of Data Warehousing
- Data
Warehousing architecture
- Data
mart
- Dimensional
Modelling
- Star
Schema
- SnowflakeSchema
- Balance scorecards
- 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
- 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
No comments:
Post a Comment