Get 50% off with the coupon code
Webinar Pack
Modules:
Pack of FIVE : Best Excel Courses with 50% Off
Product Id: 6001
Training Options
Webinar Packs Access recorded version unlimited viewing for 6 months. (For Customize Webinar Packs Please Call Customer Care)
Overview: Embark on a journey to spreadsheet proficiency with our comprehensive Excel training tailored for beginners. This expertly designed session is the perfect launchpad for individuals with a foundational understanding of spreadsheets who aspire to delve deeper.
If you recognize a spreadsheet, can effortlessly navigate its interface, and are adept at basic data entry and editing, this session promises to elevate your skills to new heights.
Our training pledges to lay down a robust foundation, arming you with a repertoire of indispensable tools and techniques. Unleash Excel's full potential by mastering its essential features, ensuring you progress from novice to adept with remarkable speed and confidence.
Why should you Attend:
In an era where data is king, Excel's prowess as a tool for visualization, management, and analysis of information is unparalleled. Its significance transcends industries and job roles, positioning it as an invaluable asset in any professional toolkit.
Whether you're crunching numbers, organizing complex data, or simply streamlining daily tasks, Excel's versatility makes it a ubiquitous necessity across all professional landscapes. By embracing this training, you ensure you're not just keeping pace but setting the standard in your workplace.
Areas Covered in the Session:
Who Will Benefit:
Our training pledges to lay down a robust foundation, arming you with a repertoire of indispensable tools and techniques. Unleash Excel's full potential by mastering its essential features, ensuring you progress from novice to adept with remarkable speed and confidence.
Why should you Attend:
In an era where data is king, Excel's prowess as a tool for visualization, management, and analysis of information is unparalleled. Its significance transcends industries and job roles, positioning it as an invaluable asset in any professional toolkit.
Whether you're crunching numbers, organizing complex data, or simply streamlining daily tasks, Excel's versatility makes it a ubiquitous necessity across all professional landscapes. By embracing this training, you ensure you're not just keeping pace but setting the standard in your workplace.
Areas Covered in the Session:
- Discover lightning-fast data entry shortcuts to save precious time
- Transform your data into a visual masterpiece with advanced formatting techniques
- Master the essentials: Cut, Copy, Paste - the foundational trio of data manipulation
- Implement Conditional Formatting to dynamically alter cell appearance based on specific conditions
- Construct basic formulas to perform arithmetic operations like addition, subtraction, division, and multiplication with ease
Who Will Benefit:
- This course is aimed at individuals at the start of their Excel journey. If you're eager to expand your Excel expertise beyond basic familiarity, this training will serve as your stepping stone to becoming a proficient user
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. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session.
Why should you Attend:
In today's world, there are a ton of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information.
Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This webinar will show you how to take large amounts of data from many sources and process them into great reports.
Areas Covered in the Session:
Who Will Benefit:
You and your staff will be instantly more productive in Excel. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session.
Why should you Attend:
In today's world, there are a ton of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information.
Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This webinar will show you how to take large amounts of data from many sources and process them into great reports.
Areas Covered in the Session:
- Creating and managing Pivot Tables
- Changing the calculation type
- Adding additional calculations
- Creating custom calculations
- Multilayer reports
- Creating Daily, Monthly, quarterly, and yearly summaries
- Adding A pivot chart
- Adding Slicers
- Adding timelines
Who Will Benefit:
- Banking
- Finance
- Manufacturing
- Insurance
- Pharmaceutical
- Construction
- Entertainment
- Service
- Hospitality
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.
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: A customized practical PowerPoint example is provided with slides in sequence for each question posed to ChatGPT for demonstration and “hands-on” practice by attendees
Mastering ChatGPT is a fundamental and highly marketable skill set in PowerPoint and is vital in a wide range of professions and fields including public service, banking, accounting, financial analysis, and business administration.
Pose questions verbally and hear responses verbally. Understand the dynamic nature of ChatGPT and how it continually “evolves” in its understanding and responses. 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 PowerPoint’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 analyzing ChatGPT responses.
Gain a solid foundation using ChatGPT to effectively build your knowledge of PowerPoint capability, boost your work output, save significant time and produce outstanding professional results.
Seize this crucial opportunity to significantly advance ahead of your peers and competition.
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 you should Attend:
Areas Covered in the Session:
Who Will Benefit:
Pose questions verbally and hear responses verbally. Understand the dynamic nature of ChatGPT and how it continually “evolves” in its understanding and responses. 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 PowerPoint’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 analyzing ChatGPT responses.
Gain a solid foundation using ChatGPT to effectively build your knowledge of PowerPoint capability, boost your work output, save significant time and produce outstanding professional results.
Seize this crucial opportunity to significantly advance ahead of your peers and competition.
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 you should Attend:
- Using Artificial Intelligence (AI) and ChatBOT technology, ChatGPT represents a new frontier in mastering PowerPoint
- The global trend to AI is unstoppable and presents massive opportunities in efficiencies and time savings
- Understand how ChatGPT AI enhances its responses as it “learns” from millions of users globally every minute 24/7
- Take the initiative to surpass your competition using the power of AI and ChatGPT and avoid being “left behind”
- Save countless hours and boost your efficiency by consolidating your ChatGPT questions and answers into a fully referenced document
- This “hands-on” webinar replicating “in-classroom” approach maximizes understanding and retention of these highly sought-after skills
Areas Covered in the Session:
- ChatGPT Explained
- ChatGPT options, costs, disclaimers, copyright & knowledge base
- Tips and wider examples of uses
- Understand the screen, key options & ChatGPT capability
- Presenting effective questions to ChatGPT
- 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:
- Plan a PowerPoint Slide Show
- Influence of Colors on Emotions in a PowerPoint Slideshow
- Obtain Free Images Videos and Music for a Slideshow
- Starting a New PowerPoint Slideshow File
- Insert and Manage Bullet Points
- Edit Manage Format and Work With Shapes
- Insert and Manage a Chart and Supporting Data
- Insert and Edit an Organization Chart
- Animate Pictures and Set Timings
- Animate Bullet Points
- Add and Manage Slide Transitions
- Setup a Slide Show to Loop Continuously
- Save a Slide Show as a Movie
- Keyboard shortcuts – PowerPoint, general & web browser
- NOTE: Topic sequence may be subject to slight variation
Who Will Benefit:
- All MS PowerPoint Users
- Account Executives
- Accountants
- Auditors
- Bookkeepers
- Business Owners
- Chief Executives
- Controllers
- CPA's
- Cybersecurity staff
- Database Administrators (DBA)
- Educators
- Trainers
- Engineers
- Financial Analysts
- Human Resource Personnel
- 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.