CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APDBFNC - Database Functions in Excel

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Students will create formulas, functions and database functions to use in analyzing data stored in databases or in worksheets.

Prerequisites

Excel Level 1 or equivalent knowledge

Detailed Class Syllabus

Excel formulas "101"

Create basic formulas with cell references

Create formulas for a profit statement

Use functions and labels in formulas

Create a formula for income projection

Build formulas to project sales

Create formulas with mixed and absolute cell references

Use the Round function

Add Clip Art

Prepare the report for printing

Use lookup tables to find delivery charges

Experiment with the If function

Use the Vlookup function

Use the If and Vlookup functions in a formula

Calculate loan payments

Create formulas with the PMT function

Track elapsed time

Experiment with cell formats and dates

Use the Now function to keep the current date in a worksheet

Create formulas to calculate elapsed time

Use the Workday function to calculate project due dates

Get the information you need from your Excel list

Use the Dsum function

Use the Dcount function

Use the Sumif function

Use the If function

Apply filters

Simplify statistical analysis with functions

Use the Average, Median, and Mode functions

Use the Stdev function

Find highs and lows with the Max and Min functions

Count items in a list

Apply filters to a list

Apply error-handling and auditing techniques

Use the Iserror function

Nest the Iserror function within the If function

Use Excel’s auditing features