Present Your Data Effectively With Microsoft Excel and PowerPoint

Views:
 
Category: Education
     
 

Presentation Description

Watch video: http://tiny.cc/jrk9qz on How to Present Your Data Effectively With Microsoft Excel and PowerPoint. Are you tired of presenting your data in boring tables at work? If you wish to brush up your Excel and PowerPoint skills, then this training is what all you need. Earn 1 PDU approved by Project Management Institute (PMI)® by attending this webinar to support your continuing education. 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

Comments

Presentation Transcript

slide 1:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | Present Your Data Effectively With Microsoft Excel and PowerPoint James Laws NetCom Learning

slide 2:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.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 QA session with the speaker

slide 3:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | • Use Excel Tables • Use Suggested Charts Feature BUILD GREAT TABLES CHARTS

slide 4:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | • IFS Formulas • Pivot Tables COLLATING DATA

slide 5:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | • Flash Fill Feature • Custom Tables PivotTables Charts • 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 APPLY CUSTOM DATA FORMATS LAYOUTS

slide 6:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | • VLOOKUP • Index • Match • Offset • Trim • Clean • Randbetween • Proper CREATE ADVANCED FORMULAS

slide 7:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.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 | |

slide 8:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | ABOUT NETCOM LEARNING NetCom Learning is an award-winning global leader in managed learning services training and talentdevelopment. Founded : 1998 Headquarters : New Y orkCity Delivery Capability : Worldwide C E O : RussellSarder 100K+ Professionals trained | | © 1998-2019 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 12K+ C orporate clients 3500 IT Business Soft Skillscourses 96 Of customers recommend us to others 8.6/9 Instructor evaluations 20+ Leadingvendors recognitions Microsoft ’s Worldwidetraining partner of the year 80 Trained ofthe Fortune 100 T op20 ITTraining Company © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 9:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.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 | | © 1998-2019 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 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 Heres What You Need to Know » Blog - How are Major Organizations Coping with COVID and Using Microsoft T echnologies » Microsoft Application Digital Learning Library © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 10:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.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 thats Flexible Personalized Intelligent and Intuitive More | | © 1998-2019 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 11:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.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 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 12:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.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 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 13:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | PROMOTIONS Worry-Free Training with Price Match Guarantee Our Price Match Guarantee ensures that well 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 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 14:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | FOLLOW US ON LinkedIn T witter Y ouTube | | © 1998-2019 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 Instagram © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 15:

© 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.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. DOWNLOADe-book | | © 1998-2019 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

slide 16:

Thankyou © 1998-2019 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | | | | © 1998-2020 NetCom Learning www.netcomlearning.com infonetcomlearning.com 1-888-563-8266 | |

authorStream Live Help