Looks like this event has already ended.

Check out upcoming events by this organizer, or organize your very own event.

View upcoming events Create an event

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 THIS EVENT

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

 

When & Where



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

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


  Add to my calendar

Organizer

ThinkData Solutions, Inc

At ThinkData Solutions, our name says it all. We thoughtfully provide a wide variety of solutions to data and technology related challenges.

While every solution designed by ThinkData is customized to meet specific needs, we divide our services into three main categories: Training, Development, Consulting.

Training: Utilizing our technology lab at Innovation Depot and our full mobile training lab, we host a wide variety of technology training classes. Our training expertise ranges from productivity tools such as Microsoft Office to complex and integrated business systems. Whether the training is for an individual or several hundred employees in multiple locations, we customize our training to fit both your needs, and your budget. In addition to training classes held in our technology lab in the Innovation Depot, our team is also available for on-site training at your business.
 
Consulting: Through our corporate consulting services, we help companies stay ahead of technology trends to ensure employees can skillfully utilize the tools at their disposal. All engagements are different. For example, we have provided consulting from customized human resource skills tests and competency assessments to technology purchase evaluations and budget planning. If your company is looking bridge the gap between technology and success, we can provide options to maximize technology investments by designing a custom program to achieve your goals.
 
Development: In addition to training and consulting, the team at ThinkData is fully equipped to manage custom development projects. Our team is comprised of top-level programmers versed in multiple programming languages. From database development to custom software applications, we can build the tools your company needs to succeed. As experts in rapid custom development of web-based, distributed and standalone applications, we can quickly and efficiently meet your specific requirements and business needs. At ThinkData, programming is our passion.

 

  Contact the Organizer

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.