Identifying the kinds of field elements displayed using slicers than filters
Making use of timeline for dynamic time-based displays
Digging deep to know the details behind the summary
Categorizing of time/date data in various levels
Creating of a Pivot Chart in sync with a PivotTable
Putting in calculated fields in order to do additional analysis
Ways to reveal detail/hide/summary information/ with a click
Ways to deal with the “refresh” concept and the dynamic source data
Ways to create a PivotTable using data from various worksheets
Ways to provide Conditional Formatting to PivotTable Data
Generating PivotTables from various input sources (different workbooks and worksheets)
Using Slicers to accentuate field elements that are being shown at present (and which ones are not)
Making use of the new Timeline feature
Using Conditional Formatting with PivotTable data
Exploring the best techniques for updating PivotTables
Creating ad hoc and date-based groupings within a PivotTable
Session 12- Compelling Presentations with Excel and PowerPoint Session Highlights:
Pivot Tables and Charts
Logic-Based Summary Functions
Presentation Design Concepts
Conditionally-Formatted Charts
Building Office Themes
Link an Excel Chart to PowerPoint in Seconds
Storytelling with Data
Audience Analysis
Restoring missing data
Copying, pasting, linking, and embedding data
Presenting dense
Session 13 – File Triage: Work Smarter in Microsoft Word, Excel, and PowerPoint Training Highlights:
Learn how to remove extra line breaks from Microsoft Word documents
Find out how you can update data throughout Microsoft Excel spreadsheets
Discover how you can fix slides without slide numbers in your presentations
Learn how to create fillable forms using Microsoft Word
Learn how you can build Interactive Presentations using Microsoft PowerPoint
Find out how you can automate your inbox in Outlook
Use the calendar feature in Microsoft Outlook to maximize efficiency
Learn all about OneNote and its useful features
Also learn about the useful features in Visio, SharePoint, Evernote, and Acrobat Pro
About Our Speaker
Dennis Taylor is an author, speaker, seminar leader and facilitator. With over 25 years’ experience, he is well-versed in Microsoft Excel and has conducted nearly 600 webinars on the subject, throughout the United States and Canada. In addition, he has also authored and presented numerous courses on Excel, and authored (and co-authored) multiple books on spreadsheet software.
Mike Thomas has extensive experience of working in the IT training business, where he’s been actively involved for over 27 years. He is an expert in several subjects, including in Microsoft Office and Apple Mac.
Mike is the founder of The Excel Trainer, which provides training for Microsoft Excel. Here, he has produced nearly 200 written and video tutorials, which have helped people over the world increase their efficiency. He has also recorded training courses for pluralsight.com. In addition, he has conducted hundreds of webinars on a wide variety of topics, related to technology.
Neil Malek – Microsoft Certified Trainer, CompTIA CTT+, and Adobe Certified Expert – is founder and principal at Knack Training, a Southern California education company. He has over 15 years of experience teaching software and professional development skills, and has worked with individuals, non-profits, small businesses, and Fortune 100 companies to identify and address training needs.
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).