*Update*  The correct date for this event is Thursday May 14th!

In this free 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.