This event has ended

Creating Solutions with Excel and Access 2007

ThinkData Solutions, Inc

Thursday, April 26, 2012 at 9:00 AM - Friday, April 27, 2012 at 4:00 PM (CDT)

Birmingham, AL

Creating Solutions with Excel and Access 2007

Ticket Information

Ticket Type Sales End Price Fee Quantity
Creating Solutions with Excel and Access 2007 Ended $675.00 $0.00

Share Creating Solutions with Excel and Access 2007

Event Details

creating solutions with Excel and access 2007

 

Course Description

The course introduces you to building solutions using the power of Excel 2010 and Access 2010 together to streamline processes.

 


COURSE OBJECTIVES

Upon completion of this course, the student will be able to:

·        Perform calculations.

·        Calculate and analyze data.

·        Sort and filter data.

·        Create, run, and edit macros.

·        Create queries.

·        Generate reports.

Lesson 1 – Working with Data Analysis

·        What If Analysis?

·        Scenarios

·        Goal Seek

Lesson 2 – Calculating Data with Advanced Formulas

·        Basic Formulas

·        Built In Functions

·        Copy Formulas and Functions

·        Date Functions

·        Text Functions

·        Vlookup

·        Absolute/Relative Referencing

·        IF Function

·        ISNA Function

·        Remove Duplicates

Lesson 3 – Sort and Filter Data

·        Sort Data

·        Filter Data

·        Clear Filters      

·        Subtotal Data

·        Expand and Collapse Subtotals

 

Lesson 4 – Streamlining Workflow

·        Set the Default Options for Excel

·        Data Validation

·        Create a drop down from a list

·        Work with Conditional Formats              

·        Control Conditional Formats by Managing the Rules

·        Create a Macro

·        Edit a Macro

·        Adjust Macro Settings

·        Hide the results of macros while it runs

Lesson 5 – Querying a Database

·        Create a Query

·        Add Criteria to a Query

·        Filter Records

·        Add a Calculated Field to a Query

Lesson 6 – Joining Tables

·        Relate Data within a Table

·        Join Unrelated Tables

Lesson 7 – Creating Flexible Queries

·        Set Select Query Properties

·        Create Parameter Queries          

·        Create Append Queries

·        Create Update Queries

Lesson 8 – Writing Advanced Queries

·        Create Subqueries

·        Create Duplicate Queries and Unmatched Queries

Lesson 9 – Generating Reports

·        View an Access Report

·        Create a Report

·        Format the Controls in a Report              

·        Add a Custom Calculated Field to a Report

·        Apply an AutoFormat to a Report

·        Prepare a Report for Print

Lesson 10 – Simplifying Tasks with Macros

·        Create a Macro with the Command Button Wizard

·        Create a Macro from Scratch

·        Attach a Macro

 

Have questions about Creating Solutions with Excel and Access 2007? Contact ThinkData Solutions, Inc

When & Where


ThinkData Lab
1500 1st Ave N
Ste L142
Birmingham, AL 35203

Thursday, April 26, 2012 at 9:00 AM - Friday, April 27, 2012 at 4:00 PM (CDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.