MS Excel® Course Foundation Level

Upcoming Training

Course Details
  • Organizations rely on the information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2019 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Course Outline
Day 01: Foundation to Intermediate Level
    • Getting Started with Excel 2019
      • Navigate the Excel User Interface
      • Use Excel Commands
      • Create and Save a Basic Workbook
      • Enter Cell Data
      • Use Excel Help
    • Performing Calculations
      • Create Worksheet Formulas
      • Insert Functions
      • Reuse Formulas and Functions
    • Modifying a Worksheet
      • Insert, Delete, and Adjust Cells, Columns, and Rows
      • Search for and Replace Data
      • Use Proofing and Research Tools
    • Formatting a Worksheet
      • Apply Text Formats
      • Apply Number Formats
      • Align Cell Contents
      • Apply Styles and Themes
      • Apply Basic Conditional Formatting
      • Create and Use Templates
    • Printing Workbooks
      • Preview and Print a Workbook
      • Set Up the Page Layout
      • Configure Headers and Footers
    • Managing Workbooks
      • Manage Worksheets
      • Manage Workbook and Worksheet Views
      • Manage Workbook Properties
    • Working with Functions
      • Work with Ranges
      • Use Specialized Functions
      • Work with Logical Functions
      • Work with Date & Time Functions
      • Work with Text Functions
    • Working with Lists
      • Sort Data
      • Filter Data
      • Query Data with Database Functions
      • Outline and Subtotal Data

77-727 : Microsoft Office Excel 2016 Exam
Location Date Duration Delivery Price
Sat 14th Sep, 19 2 Day(s) Live Online Instructor Led $1199  $599

Why Train With Us?

At ITIC System, our industry experts and professional trainers, deliver the best courses to help you get the knowledge and also get the certification in the least cost and time. Accredited as a registered education provider of Project Management Institute, US (REP ID 4562) ITIC System provides quality training to help you boost your career.

Highest Value

We price our courses lower than others offering best value for the investment you are making in your career.

Flexible Delivery Modes

We know that your time is precious, so we offer multiple modes of delivery methods to suit your availability and schedule.

Complete Courseware

Our courses come with a comprehensive course ware and everything you need to learn to get the certification you are looking for.

Customer Support

We provide customer support service in case if you need more information while enrolling a course, we are available any time to help you.

Related Courses