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.

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

'

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.

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.

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.

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.

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

1. Visual Basic Editor
2. Objects, Methods, Properties
3. Programming Tools
4. The Menu Bar
5. Running Code
6. Run mode and Design mode
7. Running Code from the development environment & the host application
8. The Project Explorer
9. Using the Project Explorer
10. The Properties Window
11. Changing a Property
12. Using Constants
13. Excel & Variable Constants
14. Excel Objects
15. Objects, Properties and Methods
16. Getting & Setting Properties
17. Calling Methods
18. Passing Arguments
19. Singular Objects & Collections of Objects
20. Variables
21. Dimensioning a variable
22. Using variables in routines
23. Object Variables
24. Using Visual Basic Functions
25. InputBox Function
26. MsgBox Function
27. Using a Set Statement
28. Building Formula Control Structures
29. If…Then Decision Structures
30. Logical Operators
31. Select Case Decision Structures
32. Case Else
33. Comparison Operators with Select Case Structure
34. For… Loops & Do Loops
35. While…Wend Statement
36. UserForms
37. Designing & Creating Forms
38. Working with Controls
39. Creating Custom Dialog Boxes
40. Userform Properties Methods & Events
41. Event Handling
42. VBA Editing & Debugging
43. Auto Macros
44. Error Handling

Course Unit 2: Management Information Reporting (MIR)

1. Decision Making

• Effective Decision Making
• Steps to Making Effective Decisions

2. Introduction to Management Information Reporting

• Sources of Information and Data
• 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

4. Organisational Level and Reports

5. Key Performance Indicators

• What are Key Performance Indicators
• 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

7. Service Level Agreement

• Introduction to SLA
• 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

11. Data Analysis lifecycle

• Using Information and Data Strategy to Analyse Business Objects

12. Data Sources

• Transactional Data
• 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

17. Identifying what you want to say

• Proportion of the Whole
• 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

22. Introduction to Data Warehousing

• Definition of Data Warehousing
• 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

25. Customer-Based Reports

• Customer Segmentation
• 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

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

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

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

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

Adjusting Specific Chart Types

- Column, line and pie charts
- 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

Printing and Sharing Charts

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

1. Decision Making

• Who Are Decision Makers
• Effective Decision Making
• Steps to Making Effective Decisions

1. Introduction to Management Information Reporting

• Basic understanding and purpose
• Sources of Information and Data
• Uses of Management Information Reporting

1. Enterprise Performance Management

• Defining and Communicating Strategy
• Measuring Performance
• Analysing Performance
• Aligning People and Culture

1. Organisational Level and Reports

• Reporting and reviewing Performance
• Understanding business goals

1. Key Performance Indicators

• What are Key Performance Indicators
• Strategic Vision and Objectives
• Benefit of KPI’s
• KPI Planning
• KPI metrics
• Identify KPI

1. HR metrics

• Turnover Rate
• Cost Per Hire
• Human Capital ROI
• Inventory to Sales Ratio

1. Service Level Agreement

• Introduction to SLA
• Why SLA is important to Management Information Reporting
• How to use and apply SLA to reports

1. Financial Metrics

• Understand Financial Metrics
• Benefits that you can get working with metrics
• Data set-up

1. Marketing/Sales Metrics

• Understand Financial Metrics
• Benefits that you can get working with metrics
• Data set-up

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

1. Data Analysis lifecycle

• Using Information and Data Strategy to Analyse Business Objects

1. Data Sources

• Transactional Data
• Data Flow
• Quality Assurance
• Business operational Data
• Lifestyle Data
• Importing and Exporting Data

1. Static Reports

• Creating Product Performance Reports
• Analysing Business Performance
• Working with complex databases
• Data Validation techniques

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

1. Identifying what you want to say

• Proportion of the Whole
• Trend Analysis
• Relationships
• Comparison
• Distribution

1. Trend Analysis

• Visualisation of trend Analysis

1. Data Visualisation in report

• Common Data Visualization Issues
• Dynamic Reports
• Choosing the right charts
• Pattern recognition

1. Pattern Recognition in Data and Charts

1. Database types

• Transactional Database
• Analytical Database

1. Introduction to Data Warehousing:

• Definition of Data Warehousing
• Benefits and challenges of Data Warehousing
• Data Warehousing architecture
• Data mart
• Dimensional Modelling
• Star Schema
• SnowflakeSchema

1. Balance scorecards

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

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