Webinar Pack
Modules:
Pack of FOUR: Best HR Analytics and Reporting Courses
Product Id: 60003
Training Options
Webinar Packs Access recorded version unlimited viewing for 6 months. (For Customize Webinar Packs Please Call Customer Care)
Overview: "Every Picture Tells a Story" is a popular saying which is true not only in everyday life but in Excel too. Behind every set of numerical data is a story waiting to be told. The telling of this story needs to be succinct, easy to understand, and engaging.
For most people, it's much easier to understand data, uncover important insights and make better decisions if that data is displayed in a visual way.
Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it.
This training covers how to visually represent your data using traditional charts (bar charts, line charts, etc.)
Why should you Attend:
Until a few years ago it was enough to take a set of numbers and with a couple of mouse clicks, create a basic chart. But things have moved on and now it's time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world.
Learning Objectives:
Areas Covered in the Session:
Who Will Benefit:
Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it.
This training covers how to visually represent your data using traditional charts (bar charts, line charts, etc.)
Why should you Attend:
Until a few years ago it was enough to take a set of numbers and with a couple of mouse clicks, create a basic chart. But things have moved on and now it's time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world.
Learning Objectives:
- Learn how to select the most appropriate chart to convey your message
- Learn how to create a chart from a set of data and change its appearance
- Learn how to create infographic-style charts
- Learn how to integrate Excel charts with other applications such as Word and PowerPoint
Areas Covered in the Session:
- Selecting the appropriate visual
- Creating a basic chart (bar, column, line, pie)
- Changing the chart type and data source
- Dynamic charts - automate adding new data to a chart
- From Drab to Fab - convert a basic chart into an eye-catching visual
- Fill the bars with images and shapes to create infographic-style charts
- Creating a chart from a pivot table - the gotchas
- Using Excel charts with other applications
Who Will Benefit:
- This training is categorized as introductory. It is aimed at users who have little or no knowledge of how to produce charts and represent data visually in Excel. Although the training will be delivered using the latest version of Excel, this training is relevant for users of Excel 2010 and above
Mike Thomas - In a career spanning over 30 years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.
Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes
He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.
Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes
Overview: In this webinar, you will learn how to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. We will start with the basics and built up to more complex pivot tables.
Many people struggle with how to create Pivot Tables, or maybe they don't even know what they can do, or maybe they think they are too difficult. I'm going to show you what they are, how to use them, and that they are not difficult, and they can give you tremendous results. We will then make Pivot Charts, to graphically show the data. Then, we will add sorts, filters, slicers, and timelines to create a very easy-to-use, but very powerful dashboard that can give you instant results, and allow you to slice and dice your data any which way. You and your staff will be instantly more productive in Excel.
Why you should Attend: In today's busy world, everybody wants quick results. Plus, people don't have time to look at tons of data. They want a visual summary of the data. Excel dashboards will allow you to change the criteria of the data very quickly, and then see the reports right away in a visually pleasing format.
Areas Covered in the Session:
Who Will Benefit:
Why you should Attend: In today's busy world, everybody wants quick results. Plus, people don't have time to look at tons of data. They want a visual summary of the data. Excel dashboards will allow you to change the criteria of the data very quickly, and then see the reports right away in a visually pleasing format.
Areas Covered in the Session:
- Creating and managing Pivot Tables
- Adding A pivot chart
- Adding Slicers
- Adding timelines
Who Will Benefit:
- Business Owners
- CEO's / CFO's / CTO's
- Managers of all levels
- Anybody who uses Excel on a regular basis, and wants to be more efficient and productive
- Administrators
- Salespeople
- Trainers
- Bankers
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, and a Microsoft Certified Expert in Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training.
His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects.
His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects.
Webinar#
ChatGPT for Excel
Overview: This course is designed to teach learners how to use CHATGPT for Excel, a powerful tool that can help you automate tasks, analyze data, and create reports in Excel.
Throughout the course, learners will explore the features and capabilities of CHATGPT for Excel, like basic navigation and data import/export. Whether you are a data analyst, business professional, or simply someone looking to improve your Excel skills, this course will provide you with the knowledge and tools you need to take your Excel game to the next level.
Areas Covered in the Session:
Who Will Benefit:
Areas Covered in the Session:
- Learn how to navigate the CHATGPT for Excel interface with ease and familiarity
- Learn the features and capabilities of CHATGPT for Excel, including how to use it to automate tasks and analyze data
- Learn how to import and export data using CHATGPT for Excel, enabling them to work with a wide range of data sources and formats
- Learn the power and flexibility of CHATGPT for Excel
Who Will Benefit:
- Business Owners
- CEO's
- CFO's
- CTO's
- Managers of All Levels
- Administrators
- Salespeople
- Trainers
- Bankers
- Office Workers
- Anybody who uses Excel on a regular basis, and want to be more Efficient and Productive
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, and a Microsoft Certified Expert in Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training.
His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects.
His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects.
Overview: This easy to follow demonstration clearly explains how to effectively post ChatGPT questions on more advanced Excel topics and extract more accurate responses.
Mastering ChatGPT is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including public service, banking, accounting, financial analysis, and business administration.
Seize this crucial opportunity to significantly advance ahead of your peers and competition.
Learn the correct question format and smart techniques to use, and ChatGPT will teach you guiding you step by step with little need for in-depth knowledge of Excel’s functions and features!
Document your ChatGPT questions and answers in a fully referenced template with a table of contents for easy future reference.
Work "hands on" during this webinar to interact live with ChatGPT, submitting clear questions with relevant data and analysing ChatGPT responses.
Gain a solid foundation using ChatGPT to effectively build your knowledge of Excel capability, boost your work output, save significant time and produce outstanding professional results.
Replicating the in-person classroom experience using a step by step guide, student files and data samples this interactive webinar offers clear understanding and maximum knowledge retention for attendees.
Grasp essential fundamental techniques and apply your knowledge with skills and shortcuts as used by experienced professionals
Why should you Attend:
Areas Covered in the Session:
Who Will Benefit:
Seize this crucial opportunity to significantly advance ahead of your peers and competition.
Learn the correct question format and smart techniques to use, and ChatGPT will teach you guiding you step by step with little need for in-depth knowledge of Excel’s functions and features!
Document your ChatGPT questions and answers in a fully referenced template with a table of contents for easy future reference.
Work "hands on" during this webinar to interact live with ChatGPT, submitting clear questions with relevant data and analysing ChatGPT responses.
Gain a solid foundation using ChatGPT to effectively build your knowledge of Excel capability, boost your work output, save significant time and produce outstanding professional results.
Replicating the in-person classroom experience using a step by step guide, student files and data samples this interactive webinar offers clear understanding and maximum knowledge retention for attendees.
Grasp essential fundamental techniques and apply your knowledge with skills and shortcuts as used by experienced professionals
Why should you Attend:
- Work smarter, faster and more effectively
- Know MS Office capabilities & features without asking Google or peers
- Achieve more in less time with higher quality results
- Boost profit, efficiency, and productivity
- Improve job satisfaction, team performance, and professionalism
- Gain strong competitive advantage at peer and business level
- Strengthen your resume and job applications
- Confidently apply key features and capabilities in Microsoft Office
Areas Covered in the Session:
- Present more advanced questions with your own data for best results
- Record more advanced ChatGPT responses in your own referenced document
- Work effectively in ChatGPT with questions and answers to these examples:
- Suppress error messages in formula results
- Group data and add calculated summary formulas per group
- Record and edit a macro to manage data in a table
- Use VLookup function
- Filter data for a specified range
- Create a Pivot Table
- Count only specified items in a large list
- Split data into smallest meaningful components in separate cells
- Join data from multiple cells into 1 cell
- Display only specified number of characters for each text item in a large list
- Formula to calculate monthly loan repayments
- Remove unwanted space at start of each piece of data
- Remove duplicates in data
- Keyboard shortcuts - Excel, general & web browser
- NOTE: Topic sequence may be subject to slight variation
Who Will Benefit:
- Account Executives
- Accountants
- Excel users seeking to boost skill levels
- Auditors
- Bookkeepers
- Business Owners
- Chief Executives
- Controllers
- CPA's
- Cybersecurity Staff
- Database Administrators (DBA)
- Educator / Trainers
- Engineers
- Financial Analysts
- Human Resource Personnels
- IT Professionals
- Managers
- Marketers
- New Recruits
- Project Managers
- Social Media Specialists
- Staff at all level
- Supervisors
Ray Evans professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher. Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 120,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher. Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 120,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.