Association of Office Professionals
2016-2017 Lunch and Learn Webinar Series
Page Content
Want 24/7 access to training on Excel for a low cost?
Look no further than the AOP Professional Excel Recorded Training (PERT).
6 PSP Credit Hours
PRICING
MEMBER PRICING
1 webinar $15
3 webinars for $20
4 webinar series for $25
NON-MEMBER PRICING
$25 per webinar series or package of 4 for $90
COURSE DESCRIPTION
Word Tips & Tricks
This session Tips and Tricks Session in MS Word will explore productivity little-known productivity generating strategies. Topics will include: Creating your own shortcuts using auto correct, fractional line spacing, adjusting font spacing, highlighting a field of text, auto date, reveal hidden characters, remove formatting, creating native and excel tables in word, sorting, creating bullet and numbered lists, styles, smart art, and customizing the quick access toolbar.
PowerPoint
This session will cover the basics but include many tips and strategies for experienced Excel users. Topics will include: cell fills, basics operations, merging cells and other cell options, logical operators, time functions and data validation. Practical applications of these tools will also be shared.
Excel Tips and Tricks Part 1
This session will cover the basics but include many tips and strategies for experienced Excel users. Topics will include: cell fills, basics operations, merging cells and other cell options, logical operators, time functions and data validation. Practical applications of these tools will also be shared.
Excel Tips and Tricks Part 2
This session will delve deeper into some of the areas we focused on in session 1 including, more advanced functions, nested if statements, Isblank, additional time functions, sorting and grouping, linking between multiple sheets, “Vlook up”, simple pivot tables and simple charts.
Records Management
This session will look at emerging trends in paperless operations and the effective use of both local networks and cloud services. Additionally, we will explore laws associated with records retention in an educational setting.
Verbal Judo
You cannot be effective on the job if you are not assertive. This session will examine the three communications styles, (hostile, aggressive and passive) and why in most cases assertive communication is best. How to use assertive communication to address common challenges in interactions with customer, colleagues, and administrators also will be addressed.
EMAIL%20US%20WITH%20QUESTIONS%20ABOUT%20THIS%20TRAINING%C2%A0