• Course Categories
    • Business
    • Finance
    • Personal Development
    • Productivity
    • Marketing
    • Trading
    • Design
    • Health & Fitness
    • Languages
    • Videography
    • Photography
    • Web Development
  • Cart
  • Gift Bundles
  • Popular courses
  • All Courses
  • All Access Pass
      • Sign UpLogin
    Edplx Online CoursesEdplx Online Courses
    • Course Categories
      • Business
      • Finance
      • Personal Development
      • Productivity
      • Marketing
      • Trading
      • Design
      • Health & Fitness
      • Languages
      • Videography
      • Photography
      • Web Development
    • Cart
    • Gift Bundles
    • Popular courses
    • All Courses
    • All Access Pass
    • Browse
    • Cart
    • All Access Pass
      • Sign UpLogin
      • Build
      • Business
      • Finance
      • Personal Development
      • Productivity
      • Marketing
      • Trading
      • Create
      • Design
      • Health & Fitness
      • Languages
      • Photography
      • Videography
      • Web Development
      • All Courses
      • Gift Bundles
      • Popular Courses
      • Live Courses

      Productivity

      • Home
      • All courses
      • Productivity
      • Microsoft Excel – Learn Advanced Tips

      Microsoft Excel – Learn Advanced Tips

      Admin bar avatar
      admin
      Productivity
      £99.00
      Buy Membership
      A320
      • Overview
      • Curriculum

      Microsoft Excel – Learn Advanced Tips is a course aimed at the excel user who is fairly competent on the software but is just looking for a few more handy tips and tricks to really get to know what this software can do. If you are handling data, or have the responsibility for analyzing data or presenting information in a useful format – reports for your team, or managers etc., then this course will be very handy.

      We don’t want you to spend a day of your life in the classroom… learn 4 useful, practical things which you can apply on your job or on your projects.

      1. Goal seek and ‘what if’ analysis
      • When working with worksheet models – do you have the answer you want, but must work backward to find the input value that gives you that answer? Goal seek will help you. If you have to analyse scenarios for forecasting – what if X happens, instead of Y? The ‘what if’ section will help you.
      1. Data Tables
      • Data can be confusing and difficult to interpret or understand if it’s not presented in logical format. Data tables can really help.
      1. Using Pivot Tables
      • A pivot table is an interactive worksheet table that quickly summarizes large amounts of data using a format and calculation methods that you may choose yourself.
      1. Extended graphics
      • Analyse the trends that are apparent and create charts to present information clearly for work reports, essays and assignments.

      A booklet with screen shots is given in lecture one, so that you can follow step by step what we do in each lecture. We also provide a spreadsheet with each lecture – for you to practice what was done in that lecture.

      Why choose Edplx?

      • Internationally recognised accredited qualification
      • Access to our free career advisors
      • Approved UK Learning Centre
      • 1 year accessibility to the course
      • Attain PDF or hardcopy certificate to show employers
      • Study at your own pace anywhere
      • Employer has access to certificate validation
      • Tutor Support available Monday-Friday
      • Invitation to job fairs

      Course Curriculum

      This Course will cover some of the following topics:-

      Introduction

      • Introduction to Excel
      • Downloadable Resource

      Goal Seek

      • Goal Seek and “what-if” analysis
      • Creating a Chart
      • Loan Mortgage Analysis
      • Changing Interest Rate
      • One Input Data Table
      • Two Input Data Table
      • Using Pivot Tables
      • Changing Layout of Pivot Table
      • Filtering Fields
      • Format Report
      • Creating a Chart From a Pivot Table
      • Extended Graphics
      • Combi Charts

      Conclusion 

      • Final Words

      Course Features

      • Lectures 16
      • Quizzes 0
      • Duration 1h 10m
      • Skill level All levels
      • Language English
      • Students 491
      • Certificate No
      • Assessments Yes
      CoursesProductivityMicrosoft Excel – Learn Advanced Tips
      • Introduction 2

        • Lecture1.1
          Introduction to Excel 03 min
        • Lecture1.2
          Downloadable Resource
      • Goal Seek 13

        • Lecture2.1
          Goal Seek and “what-if” analysis 07 min
        • Lecture2.2
          Creating a Chart 05 min
        • Lecture2.3
          Loan Mortgage Analysis 02 min
        • Lecture2.4
          Changing Interest Rate 03 min
        • Lecture2.5
          One Input Data Table 04 min
        • Lecture2.6
          Two Input Data Table 05 min
        • Lecture2.7
          Using Pivot Tables 10 min
        • Lecture2.8
          Changing Layout of Pivot Table 02 min
        • Lecture2.9
          Filtering Fields 02 min
        • Lecture2.10
          Format Report 06 min
        • Lecture2.11
          Creating a Chart From a Pivot Table 06 min
        • Lecture2.12
          Extended Graphics 05 min
        • Lecture2.13
          Combi Charts 09 min
      • Conclusion 1

        • Lecture3.1
          Final Words 01 min
      • Overview
      • Curriculum
      £99.00
      Buy Membership
      • Share:

      You May Like

      Copywriting Beginner To Advance Read More
      Admin bar avatar
      admin

      Copywriting Beginner To Advance

      497
      £99.00
      Stock Trading & Investing Diploma Read More
      Admin bar avatar
      admin

      Stock Trading & Investing Diploma

      1068
      £99.00
      Introduction to Web development Read More
      Admin bar avatar
      admin

      Introduction to Web development

      877
      £99.00
      Python 3 Programming Complete Course Read More
      Admin bar avatar
      admin

      Python 3 Programming Complete Course

      254
      £99.00
      Pilates For Beginners Read More
      Admin bar avatar
      admin

      Pilates For Beginners

      1358
      £99.00

      Categories

      • Business
      • Design
      • Finance
      • Health
      • Language
      • Marketing
      • Personal Development
      • Photography
      • Productivity
      • Technology
      • Trading
      • Videography

      Edplx is learning community with online courses in design, business, web development, photography, fitness and more. Anyone can join the community to learn cutting-edge skills, network with other creatives and discover new oppotunities.

      Company
      • About
      • Blog
      • Contact
      • FAQ
      Community
      • Become an Instructor
      • Redeem Voucher
      new-logo

      @2022 All rights reserved. Privacy Policy and Terms and condition.

      Facebook-f
      Youtube
      Twitter
      Instagram

      Connect with

      Login with Facebook

      logo

      Login

      Connect with

      Login with Facebook

      logo


      Lost your password?

      Not a member yet? Register now

      Sign up with your Email

      Are you a member? Login now

      • Login
      • Sign Up
      Forgot Password?
      Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.