CBT IT Certification Training

Unlimited IT Certification Courses via Streaming Video

Login to this site requires ssl communication.
Click here to reload the page over ssl.

  • Lost your password?

  • Back to login
Loading
Login to this site requires ssl communication.
Click here to reload the page over ssl.

  • Lost your password?

  • Back to login
Loading
  • Home
  • New Courses
        • Cisco
          • Cisco CCNA Primer
          • Cisco CCNA
  • Courses
        • Amazon
          • AWS Certified Solutions Architect – Associate
          • Amazon AWS SysOps – Associate
        • Career
        • Cisco
        • NetApp
        • CompTIA
        • ITIL
        • Juniper
        • Custom menu
          • custom menu 1
          • custom menu 2
          • Custom menu 3
          • custom menu 4
        • Linux
        • Microsoft
          • Security Fundamentals
          • Windows OS
          • Windows Server
          • Microsoft MCSA – Windows Server 2012
          • Microsoft MTA – Database Administration Fundamentals
          • Microsoft MCSA – Administering Windows Server 2012
          • Microsoft MCSA Configuring Advanced Windows Server 2012 Services
        • TCP-IP
        • Wireshark
        • VMware
        • Web Development
  • Racks
    • vRack
    • Live Cisco Racks
  • Tour
  • Join
  • Join
  • Free Training
  • Meet the Trainers
  • Help
    • Helpdesk
    • FAQ
    • Contact Us
    • Privacy
  • Products
    • Books
    • Audiobooks
  • Login
  • Members
    • Account
    • Exams
    • Forum
    • Live Cisco Rack Training
    • Members Training
    • Member Bonuses
    • My Courses
  • Home
  • New Courses
        • Cisco
          • Cisco CCNA Primer
          • Cisco CCNA
  • Courses
        • Amazon
          • AWS Certified Solutions Architect – Associate
          • Amazon AWS SysOps – Associate
        • Career
        • Cisco
        • NetApp
        • CompTIA
        • ITIL
        • Juniper
        • Custom menu
          • custom menu 1
          • custom menu 2
          • Custom menu 3
          • custom menu 4
        • Linux
        • Microsoft
          • Security Fundamentals
          • Windows OS
          • Windows Server
          • Microsoft MCSA – Windows Server 2012
          • Microsoft MTA – Database Administration Fundamentals
          • Microsoft MCSA – Administering Windows Server 2012
          • Microsoft MCSA Configuring Advanced Windows Server 2012 Services
        • TCP-IP
        • Wireshark
        • VMware
        • Web Development
  • Racks
    • vRack
    • Live Cisco Racks
  • Tour
  • Join
  • Join
  • Free Training
  • Meet the Trainers
  • Help
    • Helpdesk
    • FAQ
    • Contact Us
    • Privacy
  • Products
    • Books
    • Audiobooks
  • Login
  • Members
    • Account
    • Exams
    • Forum
    • Live Cisco Rack Training
    • Members Training
    • Member Bonuses
    • My Courses

MOS – Microsoft Office Excel 2013

Video training course for the Microsoft  77-420 Office Specialist exam. The MOS exams are a must-have for any desktop support technician or if you regularly use Excel and want to sharpen your skills.

By the end of the course you will be able to:

  • Create and Manage Worksheets and Workbooks
  • Create Cells and Ranges
  • Create Tables
  • Apply Formulas and Functions
  • Create Charts and Objects

The exam is entirely practical in nature so instead of exams we use case studies throughout the course to prepare you. The exam is very hard so please don’t take it lightly!

LawrenceR
SUBSCRIBE NOW

Your Instructor

Lawrence ‘Toby’ Rose 
Is a graduate of the University of London, and has a background in project management, software development and user training. He is a Microsoft Certified Professional with extensive experience across the whole of the Microsoft Office product set and with many Adobe products.

Lawrence has worked in several countries and is a keen traveler.

  • Over 12  hours of video training
  • Instructor set case studies
  • End-of-course certificate
  • Captions available
  • Access to members only forum
  • Exam vendor – Certiport or Prometric
  • Prerequisites – None
  • Recommended – A+
Module 1 Create and Manage Worksheets and Workbooks
Unit 1 Introduction
Unit 2 Create Worksheets and Workbooks
Unit 3 Create Worksheets and Workbooks 2
Unit 4 Navigate through Worksheets and Workbooks
Unit 5 Navigate through Worksheets and Workbooks 2
Unit 6 Format Worksheets and Workbooks
Unit 7 Format Worksheets and Workbooks 2
Unit 8 Format Worksheets and Workbooks 3
Unit 9 Format Worksheets and Workbooks 4
Unit 10 Format Worksheets and Workbooks 5
Unit 11 Format Worksheets and Workbooks 6
Unit 12 Format Worksheets and Workbooks 7
Unit 13 Customize Options and Views for Worksheets and Workbooks
Unit 14 Customize Options and Views for Worksheets and Workbooks 2
Unit 15 Customize Options and Views for Worksheets and Workbooks 3
Unit 16 Customize Options and Views for Worksheets and Workbooks 4
Unit 17 Customize Options and Views for Worksheets and Workbooks 5
Unit 18 Configure Worksheets and Workbooks to Print or Save
Unit 19 Configure Worksheets and Workbooks to Print or Save 2
Module 2 Create Cells and Ranges
Unit 1 Insert Data in Cells and Ranges
Unit 2 Insert Data in Cells and Ranges 2
Unit 3 Insert Data in Cells and Ranges 3
Unit 4 Format Cells and Ranges
Unit 5 Format Cells and Ranges 2
Unit 6 Format Cells and Ranges 3
Unit 7 Format Cells and Ranges 4
Unit 8 Order and Group Cells and Ranges
Unit 9 Order and Group Cells and Ranges 2
Unit 10 Order and Group Cells and Ranges 3
Unit 11 Order and Group Cells and Ranges 4
Module 3 Create Tables
Unit 1 Create a Table
Unit 2 Modify a Table
Unit 3 Filter and Sort a Table
Module 4 Apply Formulas and Functions
Unit 1 Utilize Cell Ranges and References in Formulas and Functions
Unit 2 Summarize Data with Functions
Unit 3 Utilize Conditional Logic in Functions
Unit 4 Format and Modify Text with Functions
Module 5 Create Charts and Objects
Unit 1 Create a Chart
Unit 2 Format a Chart
Unit 3 Insert and Format an Object
Unit 4 Insert and Format an Object 2
Module 6 Case Study 3
Unit 1 Introduction
Unit 2 Part 1
Unit 3 Part 2
Unit 4 Part 3
Unit 5 Part 4
Unit 6 Part 5
Module 7 Case Study 4
Unit 1 Introduction
Unit 2 Part 1
Unit 3 Part 2
Unit 4 Part 3
Unit 5 Part 4
Unit 6 Part 5
Module 8 Case Study 5
Unit 1 Introduction
Unit 2 Part 1
Unit 3 Part 2
Unit 4 Part 3
Unit 5 Part 4
Unit 6 Part 5
Unit 7 Part 6

About Us

This site has been created to help you make the best out of your IT career. Whether you are trying to get your first job, get promoted, or start your own IT business, we have a course for you.

Most Popular

Cisco ICND1 Wireshark WCNA NetApp NCSA CompTIA Network+ VMware VCA-DCV Microsoft MTA OS Fundamentals

Members

  • Account
  • Forum
  • Live Cisco Rack Training
  • Members Training
  • Member Bonuses
  • My Courses

Newsletter

Free IT Webinar Training

Secure Site

website security

Copyright 2016 Reality Press Ltd . / Paul Browning