Skip Main Navigation
Page Content
This event has ended

Introduction to Excel 2010 Functions & Creating Productivity Macros

ThinkData Solutions, Inc

Tuesday, August 7, 2012 from 10:00 AM to 2:00 PM (CDT)

Birmingham, AL

Introduction to Excel 2010 Functions & Creating...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Introduction to Excel 2010 Functions & Creating Productivity Macros   more info Ended $175.00 $0.00

Share Introduction to Excel 2010 Functions & Creating Productivity Macros

Event Details

Course Overview

This ½ day course covers introduces Microsoft Office Excel 2010’s Functions, like IF, ISNA and Lookups. It will also cover What If Data Analysis and the basics of recording macros to automate processes.

Enjoy a great session and lunch on us at the ThinkData Lab at the Innovation Depot.

Course Objectives:

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

·        Recognize and utilize functions and formulas.

·        Create, run, and edit macros.

Lesson 1 – Functions and Formulas

·        Absolute/Relative Referencing

·        Use the Name Manager

·        Create Names from Selection

Lesson 2 – Date and Time Functions

·        Today, Now, Day/Month/Year

·        Additional new Date Functions in Excel

Lesson 3 – Text Functions

·        Concatenate     

·        Left and Right String

·        Trim

·        Len

Lesson 4 – ADVANCED FUNCTIONS

·        Vlookup

·        Work with IF

·        Work with SUMIF

·        Work with COUNTIF

·        Work with AND/OR

·        Work with SUMPRODUCT

Lesson 5 – Streamlining Workflow

·        Set the Default Options for Excel

·        Create a Macro

·        Edit a Macro

·        Adjust Macro Settings

·        Hide the results of macros while it runs

 

Have questions about Introduction to Excel 2010 Functions & Creating Productivity Macros? Contact ThinkData Solutions, Inc

When & Where


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

Tuesday, August 7, 2012 from 10:00 AM to 2: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.