MOS: Microsoft Excel 2013

Business, Business Adminstration, Information Technology
25 Hours

Gain hands-on expertise in the Microsoft 77-420 certification exam with MOS: Microsoft Excel 2013 course and lab. The lab simulates real-world, hardware, software and command line interface environments and can be mapped to any text-book, course or training. The course and lab completely cover the 77-420 exam objectives and teach you how to create and manage worksheets and workbooks; create cells and ranges; create tables, apply formulas and functions; and create charts and objects.

students at BITTS

The Microsoft Office Specialist certification is targeted at professionals who can create and manage worksheets and workbooks with MOS: Microsoft Excel 2013 and have experience with previous versions of Microsoft Office Excel.

Quick Application Form

Entry requirements

  • High School Diploma or Equivalent
  • Age must be 18 years or above
  • English Proficiency

Course structure and modules

  • Introducing Excel
  • Entering and Editing Worksheet Data
  • Essential Worksheet Operations
  • Working with Cells and Ranges
  • Introducing Tables
  • Worksheet Formatting
  • Understanding Excel Files
  • Using and Creating Templates
  • Printing Your Work
  • Introducing Formulas and Functions
  • Creating Formulas That Manipulate Text
  • Creating Formulas That Count and Sum
  • Getting Started Making Charts
  • Learning Advanced Charting
  • Visualizing Data Using Conditional Formatting
  • Creating Sparkline Graphics
  • Enhancing Your Work with Pictures and Drawings
  • Customizing the Excel User Interface
  • Using Custom Number Formats
  • Using Data Validation
  • Creating and Using Worksheet Outlines
  • Excel and the Internet
  • Importing and Exporting Data
  • Introducing Visual Basic for Applications
  • Appendix
  • Appendix B

Career opportunities

  • Accountants
  • Data Analysts
  • Financial Analysts
  • Sales Professionals
  • Office Professionals
  • Information Workers
  • Commercial Bankers
  • Program/Project Managers