MOS: Excel 2013 Formulas

Description

In this course, you will cover how to: build a formula, use function formulas, work with range names in a
formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate
function formula, work with the Date, Proper, Upper and Lower function formulas, create a function formulas
from scratch & work with data tables.

Prerequisites

Excel Level 2 or equivalent knowledge

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

Function Formulas
• Review of Building a Formula
• Rules of Algebraic Order
• Function Formulas
• Cell Addressing
• Relative vs. Absolute Cell Addressing
• Review of Range Names
• A Review of Rules in

Advanced Functions
• Logical Functions
• Using IF Statements
• Nested IF Statements
• Lookup Functions
• The VLOOKUP Function
• The HLOOKUP Function
• Financial Functions
• The Payment Function
• Present Value
• Future Value
• Combining Text Fields
• Concatenate
• A Formula for Combining Text Fields
• Date Functions
• How Excel Stores Dates and Times
• DATEDIF Function
• NOW Function
• Addition with Dates
• DATE Function
• Other Function Formulas
• Proper, Upper, Lower Functions
• Proper Function

Advanced Options
• Creating a Function Formula
• Two Types of Macros
• Creating Function Macros
• Procedures
• Addition with Dates
• Using Data Tables
• To Create a One-Input Data Table
• Adding Formulas to Existing Data Tables
• Two-Input Data Table

Enrolled