Microsoft Excel 2013 - Advanced

Learn to Master Microsoft Excel In Easy To Follow Step-By-Step Training
Course Created by Christine
Dr Christine has a BSc Computer Science and a Masters in Computer Science from University of Wollongong, Australia. She also has a PhD in the area of Intelligent Tutoring Systems from University of Malaya. She is currently the Deputy Head of School of Engineering and Computing at one of the leading colleges in Malaysia. Her passion and expertise is in Java Programming, Software Design and Implementation (C++), Visual Programming, Security Technologies and Artificial Intelligence. She has travelled to United Kingdom and Hong Kong to present at Conferences. In September 2014, she was invited by NCC Education, United Kingdom to conduct the Teacher Standardization Event in Myanmar.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

In this Microsoft Excel 2013 (Advanced) Training, your instructor, Christine, will lead you step-by-step in mastering the Advanced aspects of Microsoft Excel.

You will learn the advance functionality of Excel from working with Pivots, What Ifs, and Charts, to customising your Workbook and Excel for a more personal experience.

Check out our Course Outline for a more comprehensive listing of topics covered!

21 Videos (120 minutes of video content)

Why you should learn from this course?

  • Easy to follow and understand tutorials
  • Step-by-step detailed instructions
  • Hands on examples
  • Taught by an excellent instructor

Course Objectives

  • To learn the advance functionality of Excel
  • To understand and use functions such as Pivot Table and Pivot Charts, WhatIfs, etc
  • To equip the user to maximise Excel's capability

Who Is This For?

  • Excel users who wants to master the software
  • Power Excel users who wants to harness the full power of the program

Course Outline

Chapter 1: Pivottable and Pivotchart

  • Lesson 1
    Using Outlines
  • Lesson 2
    Working with Pivottable
  • Lesson 3
    Creating Pivotchart

Chapter 2: Working with Charts and Graphics

  • Lesson 4
    Working with Charts
  • Lesson 5
    Insert Online Pictures
  • Lesson 6
    Adding Shapes
  • Lesson 7
    Adding a Text Box
  • Lesson 8
    Customizing Graphic Objects
  • Lesson 9
    Working with SmartArt

Chapter 3: What-If Analysis and Consolidate Data

  • Lesson 10
    Goal Seek
  • Lesson 11
    Scenario Manager
  • Lesson 12
    Consolidating Manager

Chapter 4: Customizing Workbook

  • Lesson 13
    Import or Exporting Workbook
  • Lesson 14
    Customizing Quick Access To…
  • Lesson 15
    Custom Styles
  • Lesson 16
    Custom View
  • Lesson 17
    Document Theme
  • Lesson 18
    Sending a Document
  • Lesson 19
    Creating Web Pages

Chapter 5: Customizing Excel

  • Lesson 20
    File Properties
  • Lesson 21
    Customizing Excel

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)