MOS: Microsoft Excel 2013

Business, Business Adminstration, Information Technology
25 Hours

Gain hands-on expertise in the Microsoft 77-420 certification exam with the 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 Microsoft Office 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