Leery of those cryptic Excel Functions and syntax? The ultimate goal is to empower the attendee by demonstrating the most common formulas so they understand formula syntax to build and fix their own calculations as needed.
Leery of those cryptic Excel Functions and syntax? The ultimate goal is
to empower the attendee by demonstrating the most common formulas so
they understand formula syntax to build and fix their own calculations
as needed. And in this seminar, we have time to move into more advanced
formula features.
Plus, have you ever wished someone would just
tell you what you didn't know about Excel? It is amazing what has been
around the program since the beginning, and we will reintroduce some of
those features in this seminar.
1st 90 minutes: Tools of the Trade and Everyday Excel Hacks: These are
the old-school tips and tricks that have been forgotten by so many Excel
users. They will change how you handle your spreadsheets and data
projects and make you more efficient and productive.
2nd 90
minutes: Formulas and Functions: learn the most common, and also some
advanced formulas and understand formula syntax to build and fix your
own calculations as needed. These will include: VLookup, HLookup, IF
Error, SumIF, Nested IF functions, Text to Columns, Concatenate, and the
power of the Name Box when creating formulas.
A PDF handout will
be provided for download as well as an Excel file for practice and
review, or click along with the teacher to simulate a workshop training
environment.
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)