Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Free Excel Webinar: VLOOKUPS/ FORMULAS/ TRACKING

Simplex-IT LLC

Thursday, May 14, 2015 from 11:00 AM to 12:00 PM (EDT)

Ticket Information

Type End Quantity
Attendees Ended Free  

Who's Going

Loading your connections...

Share Free Excel Webinar: VLOOKUPS/ FORMULAS/ TRACKING

Event Details

In this session, we will look at creating Vlookup formulas – since most tables are created vertically, you can look up values from a table to populate another worksheet, then when you update the main table, it updates the other worksheets.   We will create name ranges to use in formulas and when selecting large areas of a worksheet, work with IF statement functions, the Sumif and Sumifs formulas, and the DGET function (grabs one record from a large database).

We will also look at working with comments and tracking a workbook so you can send and then review changes and accept or decline those changes to update workbook. Learn how to protect a workbook and worksheet so others can only change cells you choose.

Will also look at creating a simple macro in Excel and learn more about the Personal workbook which is a hidden workbook that stores macros.

We look forward to you participating in our next Office webcast.

One attendee will win a copy of Microsoft Office Pro 2013, thanks to Microsoft!

At Simplex-IT, we specialize in sharing our knowledge with several free webinar and Lunchinar events each month on topics such as Microsoft Office, Project Management and Data Practices. Contact us at Info@Simplex-IT.com, Twitter (Simplex_IT), LinkedIn (http://www.linkedin.com/company/simplex-it) or FaceBook: (http://www.facebook.com/simplex.it).  Also, watch any of our over 100 videos at https://www.youtube.com/user/simplexITBob.


Questions?  Email us at Events@Simplex-IT.com.

Have questions about Free Excel Webinar: VLOOKUPS/ FORMULAS/ TRACKING? Contact Simplex-IT LLC

When

Organizer

Simplex-IT LLC

Simplex-IT is: 

-IT solutions-

The experience of our Certified Network Engineers and Technicians, combined with our strategic partnerships, allows us the ability to competently evaluate all of your organization's IT needs. Our solutions are designed to reduce your costs, increase your revenue and mitigate your business risks through their productivity and efficiency enhancing benefits.

-Business Solutions/Managed Services-

Simplex-IT delivers proactive maintenance services through our flat-rate IT Support Service. Designed to reduce your costs, increase your profits and mitigate your business risks, we partner with you as your Virtual CIO and IT Department, allowing you to focus on running your business, not your technology.

-Disaster Recovery-

There is no reason a temporary setback should turn into a permanent failure - if you protect your organization before disaster strikes. The first step is to create a Disaster Recovery, or Business Continuity Plan. We can help you get started right away. We will put together a comprehensive plan for your entire organization

 

  Contact the Organizer
Free Excel Webinar: VLOOKUPS/ FORMULAS/ TRACKING
Class Business

Interested in hosting your own event?

Join millions of people on Eventbrite.

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.