Thank you Veterans and Families

Semper Fidelis

---

Contact us

Phone: (310) 625-7711

Email:   tim@timowens.com


-  Home
 


 


Webinars - Excel

 

Webinar #1 - Microsoft Excel Tips and Tricks

Are you tired of "fighting" to get your Microsoft Excel documents to look the way you want? Do you struggle for hours to make things "look right?" Do have a perfect Excel document until you copy and paste from a different document? In this class you will learn

(1) 5 easy steps to make your Excel document look perfect

(2) Tips and tricks for copying and pasting

(3) Easy tips for creating and formatting charts

(4) Shortcut keys to make your Excel job easier

If you spend hours of time frustrated using Microsoft Excel, this webinar is for you!

Click here let Tim know you want this webinar for your employees


Webinar #2 - Microsoft Excel New Features

Don’t have time to take a class? At least see the new features in Microsoft Excel. Microsoft has created many new features. Be sure to know what they are so you can take advantage of the latest shortcuts added to the newest version. 

Click here let Tim know you want this webinar for your employees


Webinar #3 - Microsoft Excel Advanced Formulas

For the experienced Excel user, this course provides an opportunity to learn more advanced techniques for creating calculations. Participants will learn: a) new ways to build formulas; b) Absolute Cell Reference versus Relative Cell reference c) tools on the Auditing toolbar; d) tricks with the Go To command; and e) how to use the Function Wizard for more complex functions such as:

  • Create A “Named Range”

  • New Ways To Build Formulas 

  • Absolute Cell Reference versus Relative Cell reference 

  • Tools On The Auditing Toolbar

  • Tricks with the Go To command

  • How To Use The Function Wizard For More

  • Complex Functions Such As

  • “IF” Formula with Yes / No

  • “IF” Formula with

  • “function” / No

  • “OR” Formula

  • “AND” Formula

  • “NOT” Formula

  • Nested “IF” functions

  • The “IFERROR” function

  • The “SUMIF” function

  • The “COUNTIF” function

  • The “AVERAGEIF” function

  • The “SUMIFS” “COUNTIFS” “AVERAGEIFS” function

  • ROUND

  • VLOOKUP –and- HLOOKUP

  • Use VLOOKUP for exact matches

  • Use VLOOKUP for approximate matches

  • Use HLOOKUP for exact matches

  • Use HLOOKUP for approximate matches

  • Protect your Worksheet

  • Protect your Individual Cells of a Worksheet

  • Subtotal with AutoFilter

  • PMT

  • DATE


If you want to know advanced formulas, this class is for you!

 

Click here let Tim know you want this webinar for your employees


 

Webinar #4 - Microsoft Excel Beyond The Basics and Ready for More

If you are an Excel user, this session will initiate you into the ranks of power users. Participants will learn: a) tricks for working with range names in formatting and calculations; b) how to use the outlining feature to display only the data you want; c) how styles can save you time and give you flexibility in formatting; and d) tricks for working with multi-sheet workbook files. For large analysis projects, you will learn to sort, filter, and subtotal. Topics will also include data validation techniques, custom views and conditional formatting. Participants should have Excel experience. 

 

Click here let Tim know you want this webinar for your employees


Webinar #5 - Microsoft Excel The Critical Basics

Excel is a powerful spreadsheet application that makes it easy to set up even the most complex row-and-column project with formulas and charts. Participants will learn to: a) create and modify a spreadsheet; b) enter text and values into cells; c) create formulas and functions; d) use AutoFill format; e) insert and delete columns and rows; and f) print and save your workbooks. Creating simple charts from worksheet data will also be covered. 

 

Click here let Tim know you want this webinar for your employees



Top of this page click

Go to webinars listed page click

Go to timowens.com home page click