Excel 2013 Essential Training

Material was recorded using Microsoft PowerPoint 2019 on a Windows machine, but is relevant to PowerPoint 2010, 2013 and 2016, 2019, Microsoft 365/2025. MAC users, since the videos are recorded with the Windows version of Microsoft PowerPoint, the interface will be a bit different.This Course Includes 3 SectionsMicrosoft PowerPoint 101 - Introductory LevelMicrosoft PowerPoint 102 - Intermediate/Advanced LevelMicrosoft PowerPoint 103 - Tips and TricksEnroll now to go from beginning PowerPoint user to Advanced user. This course will take you through a comprehensive understanding of the most popular presentation tool on the market. As your instructor I will use my 20+ years of Microsoft Office training to guide you step by step as you further develop your skills in Microsoft PowerPoint. Even if you're a seasoned PowerPoint user you'll be amazed at the techniques and tools you'll pick up to help you become more productive and efficient in PowerPoint.At completion of this course you will have mastered the most popular and sought after Microsoft PowerPoint tools and come away with confidence to complete many PowerPoint tasks with efficiency and grace. Below are just a few of the topics you will master:Build and Deliver Effective PowerPoint PresentationsIntegrate Data from other Microsoft Office ApplicationsPick the Proper PowerPoint Slide Layouts for your ContentAnimate PowerPoint Content without Distracting the AudienceAutomate PowerPoint Formatting and Slide Layouts with Master Slidesand much, much more...So, what are you waiting for, enroll now and take the next step in mastering Microsoft PowerPoint and go from PowerPoint Newb to PowerPoint Guru!

Unlock the power of data with our comprehensive "Data Analysis in Excel" course. Designed for beginners and seasoned professionals alike, this course will equip you with essential skills to analyze, visualize, and interpret data effectively using Microsoft Excel.What You'll Learn:Data Cleaning and Transformation: Discover techniques for organizing and preparing your datasets to ensure accuracy and consistency. Learn how to handle missing values, duplicates, and formatting issues.Statistical Analysis: Gain proficiency in using Excel’s built-in statistical functions to perform descriptive and inferential analysis. Understand key concepts such as averages, standard deviations, and hypothesis testing.Data Visualization: Master the art of creating compelling charts and graphs that clearly communicate your findings. Explore different visualization tools and best practices for presenting data insights.Pivot Tables and Advanced Formulas: Learn how to use pivot tables to summarize large datasets and uncover trends. Dive into advanced formulas, including VLOOKUP, INDEX-MATCH, and conditional formatting, to enhance your analytical capabilities.By the end of this course, you will have a solid foundation in data analysis techniques, enabling you to make informed, data-driven decisions in your personal or professional projects. Join us and transform the way you work with data in Excel!In this "Data Analysis in Excel" course, you will:Data Cleaning and Preparation:Techniques to organize and prepare raw data for analysis, including removing duplicates, filling in missing values, and applying data formatting.Statistical Analysis:How to utilize Excel's statistical functions for descriptive analysis and inferential analysis to draw meaningful conclus

TallyPrime is simple and designed to be used by people from non-IT and non-accounts background as well. Ease of discovering information, consistent options, navigating without the need to remembering the paths and much more makes you start using TallyPrime right away. The course content is going to teach students in detail on how to manage accounting, Inventory, orders and payroll in Tally.If you are going to learn TallyPrime you must get well acquainted with MS Excel.Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. In this 7 hours of training with 74 lectures videos, you will be taken through the fundamentals of Excel till the Expertise level.

MAKING SUCCESSFUL PRESENTATIONSIf you have effective presentation skills, this means you are good at communicating. By speaking clearly and, getting your ideas and message across to people well, there will be less miscommunication. Developing killer presentation skills are essential for improving communication and creating positive learning experiences.Everyone must give a presentation at some point in their lives, whether they are a student, perhaps at a funeral, school leaver in their first job or a professional. Presentations are a great way to communicate to groups and ensure your audience understand the message you are conveying. Presentations can be useful in numerous in the workplace, which is why it’s a good idea for organisations to invest time in training their employees to present, well.Develop the awareness, knowledge, skills and attitudes needed to deliver effective professional presentations. The course is divided between what good communication is, how to prepare an effective presentation, and delivering your presentation so that you have a persuasive impact on your audience.Course Content:Effective CommunicationUnderstanding our audiencePresentation skillsDelivering your presentationWho will this package benefit?Business professionals that require the skills to make successful presentations will also benefit from this self-study package as well as practitioners who may benefit from learning shortcuts that will enable them to use Microsoft Excel and Word more effectively and efficiently.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce need to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system rollouts.This course begins the Tableau journey. The basics are covered, including data sources, basic data prep, and many visualizations. Basic Dashboards and Stories are created at the conclusion.You will learn more about the following listed items:• Present the suite of Tableau tools and their purposes.• Explain how to navigate the software.• Connect to data sources. Several are used in the course.• Understand basic data prep.• Manage data drilldown and rollup with hierarchies.• Create various visualizations.• Build basic dashboards.• Create Stories.Instructor: Eric W. Brockway

When you write PowerPoint presentations, do you - Pretend it's a Word document in landscape? - Stick objects on a page until the white space is filled up? - Write a bunch of slides, then think about how they go together? It's easy to get the basics in PowerPoint but hard to write compelling stories that your audience will find memorable and meaningful. Don't let insights you've discovered get lost in a maze of mediocre slides. In this 90-minute primer you'll go from slide monkey to slide master. We'll take an accelerated 'learn-by-doing' approach: picking up where we left off in Use Excel Like a Pro. Fast., we'll design a PowerPoint template, write a storyboard and craft a polished presentation. Along the way, we'll unpack the principles of great slide writing and cover time-saving shortcuts. What makes this course different? - It's practical. The instructor has worked in management consulting for eight years. That's a lot of real-world experience to share - It's fast; only 90 minutes. You'll have what you need in no time - It uses the case-method pedagogy. By teaching in the context of an example, retention is far higher than a traditional approach