Microsoft Excel 2013 - Intermediate

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 (Intermediate) Training, your instructor, Christine, will lead you step-by-step in mastering the more aspects of Microsoft Excel.

You will learn to work with Advanced Functions, Databases and Tables, as well as using Arrays and Multiple Sheets. You will also learn to Link Workbooks up and collaborating on it with different parties.

This course also covers Advanced Formatting and Protection of your workbooks.

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

20 Videos (over 100 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 Excel beyond the basics of a simple worksheet
  • To empower Excel users to harness the capability of the software beyond the basic level
  • To turn casual Excel users to Power users

Who Is This For?

  • Casual Excel users who wants to learn more about what Excel is capable of
  • Power users who wants to master Excel further
  • Professionals who uses Excel in their work

Course Outline

Chapter 1: Advanced Functions, Database and Table

  • Lesson 1
    Finding and Replacing Data
  • Lesson 2
    Using Block Names
  • Lesson 3
    Working with Dates
  • Lesson 4
    Using the IF, PMT and PV Fu…
  • Lesson 5
    Working with Database
  • Lesson 6
    Working with Tables

Chapter 2: Using Arrays and Linking Workbooks

  • Lesson 7
    Using Arrays
  • Lesson 8
    Linking Files

Chapter 3: Protecting Worksheets and Workbooks

  • Lesson 9
    Protecting Workbooks
  • Lesson 10
    Freezing and Unfreezing Col…
  • Lesson 11
    Splitting Worksheet
  • Lesson 12
    Hiding/Unhiding Columns

Chapter 4: Working with Multiple Sheets

  • Lesson 13
    Working with Multiple Works…

Chapter 5: Working with Chart Sheets

  • Lesson 14
    Inserting and Working with …

Chapter 6: Collaborating Workbooks

  • Lesson 15
    Inserting Hyperlink
  • Lesson 16
    Sharing Workbooks
  • Lesson 17
    Tracking Changes
  • Lesson 18
    Working with Comments

Chapter 7: Advanced Formatting

  • Lesson 19
    Conditional Formatting
  • Lesson 20
    Custom Formatting

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