Present Your Data Effectively With Microsoft Excel and PowerPoint James Laws
NetCom Learning
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
AGENDA Learn how to build great tables and charts Be able to collate data together Learn to apply custom data formats and layouts Create Advanced Formulas
Q&A session with the speaker
Š 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
BUILD GREAT TABLES & CHARTS • Use Excel Tables • Use Suggested Charts Feature
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
COLLATING DATA • IFS Formulas • Pivot Tables
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
APPLY CUSTOM DATA FORMATS & LAYOUTS • Flash Fill Feature • Custom Tables PivotTables & Charts
© 1998-2020 NetCom Learning
• • • • • • •
Dark background and Light fonts Soft Grey Lines Dotted VS solid lines White Borders Uniform Column Widths Pastel Highlights Embed Excel Bars instead of color scales
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
CREATE ADVANCED FORMULAS • • • • • • • •
VLOOKUP Index Match Offset Trim Clean Randbetween Proper
© 1998-2020 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
RECORDED WEBINAR VIDEO To watch the recorded webinar video for live demos, please access the link: http://tiny.cc/jrk9qz
© 1998-2020 NetCom Learning
www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
ABOUT NETCOM LEARNING
100K+
12K+
3500
Professionals trained
Corporate clients
IT, Business & Soft Skills courses
96%
8.6/9
20+
Of customers recommend us to others
Instructor evaluations
Leadingvendors recognitions
Microsoft’s
80%
Top20
Worldwide training partner of the year
Trained of the Fortune 100
ITTraining Company
Š 1998-2019 1998-2020NetCom NetCom Learning Learning
NetCom Learning is an award-winning global leader in managed learning services, training and talent development.
www.netcomlearning.com www.netcomlearning.com
Founded
: 1998
Headquarters
: New YorkCity
Delivery Capability
: Worldwide
CEO
: RussellSarder
|| info@netcomlearning.com || 1-888-563-8266
RECOMMENDED COURSES AND MARKETING ASSETS NetCom Learning offers a comprehensive portfolio for Business Application Courses » EXCEL LEVEL 1 (2019/2016/2013) – Class scheduled on July 13 » EXCEL LEVEL 2 (2019/2016/2013) – Class scheduled on July 14 » EXCEL LEVEL 3 (2019/2016/2013) – Class scheduled on July 15 » POWERPOINT LEVEL 1 (2019/2016/2013) – Class scheduled on July 20 » POWERPOINT LEVEL 2 (2019/2016/2013) – Class scheduled on July 21
You can also access the below Marketing Assets » Free On-Demand Training- 5 Steps to Master Microsoft Excel: Workbooks » Free On-Demand Training- Fed Up with Rebuilding PowerPoint? Here's What You Need to Know! » Blog - How are Major Organizations Coping with COVID and Using Microsoft Technologies? » Microsoft Application Digital Learning Library
© 1998-2019 NetCom Learning 1998-2020 NetCom Learning © 1998-2020 NetCom Learning
www.netcomlearning.com www.netcomlearning.com | |info@netcomlearning.com | |1-888-563-8266 www.netcomlearning.com| info@netcomlearning.com| 1-888-563-8266
UPCOMING WEBINARS
▪ ▪ ▪ ▪ ▪ ▪
Prevent Unauthorized Access to Your Systems and Applications with Security Automation Building the Next-level Hybrid Cloud for The Next Generation of IT - Advance your app development strategy Mastering Agile Adoption - The way forward Master Business Analysis in 30 Minutes Develop your Autodesk Designing Skills with Conceptual Design Collaboration Citrix: How to Develop a Smart Workspace that's Flexible, Personalized, Intelligent, and Intuitive
& More
© 1998-2019 1998-2020NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
PROMOTIONS
Learn How To Work Remotely Without Feeling Remote - For FREE Microsoft Teams is the hub for team collaboration in Office 365 that integrates the people, content, and tools your team needs to be more engaged and productive. NetCom Learning brings a complimentary 2-Hrs Microsoft Teams training to support you and make sure your organization remains productive - and safe! Learn More
Š 1998-2019 1998-2020NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
PROMOTIONS
Buy More to Save More! Now fulfill all your training needs without disturbing your business funds. Choose from the bundle of our Learning Saving Pass (LSP) pre-pay plans and get up to 100% value back on your investment. Unlock Now
Š 1998-2019 1998-2020NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
PROMOTIONS
Worry-Free Training with Price Match Guarantee Our Price Match Guarantee ensures that we'll match the offers of any other authorized training provider if you succeed at finding anyone offering the same publicly scheduled class within 30 days of our schedule at a lower regular price. Learn More
Š 1998-2019 1998-2020NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
FOLLOW US ON
© 1998-2019 1998-2020NetCom NetCom Learning Learning
YouTube
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
BUILDING AN INNOVATIVE LEARNING ORG.
A BOOK FROM RUSSELL SARDER, CEO AT NETCOM LEARNING
A framework to build a smarter workforce, adapt to change and drive growth.
DOWNLOAD e-book
© 1998-2019 1998-2020NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
Thank you
1998-2019 NetCom Learning Š 1998-2020
www.netcomlearning.com www.netcomlearning.com
| || info@netcomlearning.com || 1-888-563-8266