Enter your keyword

Course

Advanced Excel with PowerPoint.

New Hot

About Instructor

Course Overview

This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyse data.

Prerequisite

Participants should have the knowledge of the outlined topics in the Intermediate Excel class.

Program Deliverables

  1. A training notepad with pen and a comprehensive study material
  2. Practice excel worksheets and cases
  3. Lunch and Teabreak
  4. Post training support
  5. A training certificate from us (alvaPROeSolutions, a registered Microsoft Partner
  6. You have to bring a laptop for the workshop.

WHAT YOU’LL LEARN

DATA VALIDATION

With Excel data validation tools, you can control users input data into workbooks and ensure data is entered consistently and accurately. You can control the dates, the times, even the length of the length of text they enter

OUTLINE

This will take you through Testing for whole numbers and decimals.
This will take you through Using the input message box.
This will take you through Sequencing and placing lists.
This will take you through Creating multitiered lists.
This will take you through Setting data and time limitations.
This will take you through Limiting text length.
This will take you through Locating data validation rules.
This will take you through Requiring entries to be unique.

POWER FUNCTIONS

  • Using the power functions: COUNTIF, SUMIF, and AVERAGEIF, COUNTIFS, SUMIFS, AVERAGEIFS
  • Performing basic math
  • Editing text with functions

HISTOGRAMS IN EXCEL

We are going to talk about going from data to histograms.Histograms are going to be really helpful to us especially because a lot of times we are going to have variables that have many values.We are going to talk about how do we have grouped, ungrouped values, which we have looked up before, and grouped values.Finally, we are just going to talk a little bit about plotting frequencies versus relative frequency.Relative frequency is just a fancy way of saying it is frequency but divided by how many cases you have. It is really like percentage.

VLOOKUP, HLOOKUP, INDEX AND MATCH, XLOOKUP, NESTED VLOOKUP

This advance Excel training course will teach you to use the advance features of Excel in any version to their full extent. By the end of this course, you will be able to report on data in a list using Pivot tables, edit and analyze complex data using advanced features such as scenarios, Goal seek and solver, incorporate built-in functions into a worksheet. 

  • VLOOKUP is one of the most requested Excel function tutorials that have received in over eight years of providing corporate training in Microsoft Excel users get caught up in inefficient and problematic workflows, and nested conditionals (nested if statements) are curtaining towards the top of the list. Learn to solve this and other problems, by utilizing the VLOOKUP, HLOOKUP, and index and match functions.
  • Some of the abilities you’ll gain by understanding these functions are;
  • Eliminate nested conditional (IF) statements
  • Pill data from disjointed or broken tables
  • Allow for auto fill even when a reference table

 

CHARTS

 In this topic, we will show how to analyse and communicate the value of data with charts in Excel. The topic starts with the foundation: what the parts of a chart are, what the different types of charges, and which charts work best for your data. The topic then shows how to create a presentation –ready charts in minutes.

OUTLINE

This will take you through Identifying the plot area, chart area, gridlines, legends, and more.
This will take you through Selecting the right chart type.
This will take you through Creating charts instantly with shortcuts.
This will take you through Choosing a layout.
This will take you through Dealing with empty and hidden cells.
This will take you through Switching rows and columns for a different view of the data.
This will take you through Moving and resizing a chart.
This will take you through Inserting pictures and shapes.
This will take you through Adding labels to a chart.
This will take you through Analysing existing and future data with trendlines.
This will take you through Charting a chart’s data source.

PIVOT TABLES AND PIVOT CHARTS

You will learn how to use pivot tables summarize, sort, count, and chart your data in Excel. We will show you how to navigate the complexity of Pivot Tables while taking advantage of their power. This topic shows how to build PivotTables from single data, add calculated fields, fields, filter your results and format your layout to make it more readable.

OUTLINE

This will take you through Formatting data for use in a PivotTable.
This will take you through Creating a new PivotTable.
This will take you through Connecting to data from multiple data sources.
This will take you through Creating calculated fields.
This will take you through Creating calculated fields.
This will take you through Summarizing field data.
This will take you through Sorting and filtering PivotTables.
This will take you through Summarizing field data.
This will take you through Sorting and filtering PivotTables.
 

TIME VALUE OF MONEY AND SOME FINANCIAL CALCULATION

We’ll show you how to perform some financial calculations quickly and easily using some financial functions in Excel variables returns 

Outline

  • Analyzing loans, payment, and interest
  • Discovering the interest rate of an annuity
  • E.g. future valve of Lump Sums

We’ll begin with a very simple problem that will provide you most of the skills to perform financial math using Microsoft Excel. An example using compounded value approach with excel commands. To find the future value of this lump sum investment we use the FV function which is defined as FV (Rate, Nper, Pmt,Pv,Type). Keep in that the example below does not detail the whole idea about the subtopic. It is just to give you a fill for some Excel capability. We’ll demystify the whole idea to you at the training, even if you are a novice. FV (Rate, Nper, Pmt,Pv, Type)

These formula/functions are already prewritten in Excel will just do it for us. What’s handy about Excel is (that) once you type in a function it will tell you what inputs you need. 

ANALYZING DATA

  • Using If formula
  • Working with Goal Seek
  • Using data table in formulas
  • Using Scenerio in Formulas

 

HOW TO CREATE DATA ENTRY FORM IN MICROSOFT EXCEL

Sometimes you need to manage lists where the information is arranged in rows. Excel offers a simple way to work with the big data in rows 

MS POWER-POINT AND DATA DRIVEN PRESENTATION

 Lean to create information- rich, visually compelling PowerPoint presentations driven by Excel data.

OUTLINE

This will take you through Navigating power-point.
This will take you through Working with presentation.
This will take you through Working with slides.
This will take you through Adding picture to slides.
This will take you through Office themes.
This will take you through Copy and paste content from Excel.
This will take you through Link and embed data with objects.
This will take you through Create data and charts directly in PowerPoint.
This will take you through Paste excel elements into power point.
This will take you through Animate a chart.
This will take you through Options for animating table.

 

 

 

 

 

 

 

 

 

Reviews Statistic

4.9
4.9 out of 4.9
10 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

10 reviews for Advanced Excel with PowerPoint.

  1. Avatar
    5 out of 5

    :

    EXcellent 5.

  2. Avatar
    5 out of 5

    :

    Well detailed And elaborate coursE CoNtent and look forward to starting class.

  3. Avatar
    5 out of 5

    :

    This free online resoUrse is so helpful in my cAreer. Thanks alot

  4. Avatar
    5 out of 5

    :

    Great resoUrCe

  5. Avatar
    5 out of 5

    :

    great

  6. Avatar
    5 out of 5

    :

    Thanks

  7. Avatar
    5 out of 5

    :

    To contribute my very best towards realizing the vision of an Establishment where my marginal efforts of hard working as well as skills can be valued and further improved upon for better service delivery.

  8. Avatar
    4 out of 5

    :

    Advanced excel with powepoint

  9. Avatar
    5 out of 5

    :

    To learn from this website for a beginning in life

  10. Avatar
    5 out of 5

    :

    To contribute my very best towards realizing the vision of an Establishment where my marginal efforts of hard working as well as skills can be valued and further improved upon for better service delivery.

Add a review

Start On February 1, 2020
Duration 2 Days
Level Master
AlvaPro eSolutions AlvaPro eSolutions
Seat avaiable 15

Share our course