Excel at Work

Excel at Work

image

We invite you to participate in our upcoming session where we will explore practical applications and techniques for optimizing Excel in the workplace. We will explore templates for things like tracking expenses so that a clean new file can be generated for each new file. Formatting of data will be discussed including tips for printing versus onscreen usage, formatting stubborn data that won’t convert to a number, using the format painter, and conditional formatting. Various tools to effectively manage and clean up data will be reviewed including efficiently removing duplicate data, merging and splitting columns, using cross reference formulas between worksheets, advanced sort and filter options, paste special options and creating summary charts using pivot tables. Join us and discover the full potential of Excel in enhancing your productivity and efficiency.

Total CEU 0.1

Registrations expire 30 days after registration

Deanna Marquez

Partner, Litigation Support

Modern Information Solutions, LLC

Deanna Marquez began her legal technology career over 20 years ago working internally at an Indianapolis based law firm in the IT department and eventually transitioning to litigation support.  Over the years Deanna has worked both internally at law firms and externally as a consultant primarily in the roles of application support and litigation support.  Deanna’s strengths lie in strategically identifying solutions to business problems through process improvement and implementation of technology.  She strives to continually share knowledge in creative ways to help provide efficiencies and real-world applications to others, specifically in a legal setting.

Deanna currently leads the Software Training and Litigation support divisions of Modern Information Solutions where she serves as the Project Manager in multiple mass tort litigations including Johnson & Johnson Baby Powder, Boeing Ethiopian Air Flight 302 crash, and several other products liability litigations. She obtained her Bachelor of Science degree in Computer Technology from Purdue University School of Engineering & Technology and a Master of Business Administration from Indiana Wesleyan University.  

Key:

Complete
Failed
Available
Locked
Excel at Work
Select the "View On-Demand Recording" button to begin.  |  63 minutes
Select the "View On-Demand Recording" button to begin.  |  63 minutes The video screen must remain your foremost screen in order for the minutes viewed to be counted correctly. Minimizing the screen will result in having to rewatch the video in order to complete this component and have the quiz and certificate available.
QUIZ - Excel at Work
2 Questions  |  2 attempts  |  100/100 points to pass
2 Questions  |  2 attempts  |  100/100 points to pass To receive 0.1 CEU credit, you must answer both questions correctly. If you miss one, you will have one more attempt. If both attempts are unsuccessful, you will be required to repurchase the test at $10. *After passing the quiz, do not forgot to view / print your certificate to gain your CEUs.
Webinar Survey
5 Questions
Certificate - Excel at Work
0.100 CEU credits  |  Certificate available
0.100 CEU credits  |  Certificate available You must click on "VIEW/PRINT YOUR CERTIFICATE" in order for the credit to be posted to your NCRA transcript.