Python for Excel: Use xlwings for Data Science and Finance

PowerPoint 2016 Foundation TutorialsPowerPoint 2016 is included with Microsoft Office 365 This PowerPoint 2016 Foundation course, as the name implies is aimed at beginners. People who have little or no experience of using PowerPoint 2016. The course starts by showing you how to create a Presentation and then moves on to show how to manipulate slides and use the built-in in PowerPoint Design Themes. We then explore Font and Paragraph Formatting techniques within PowerPoint 2016. Next we explore the use of tables, Illustrations and Charts. After that we look at slide masters and see how to use them to impose a look and feel with your PowerPoint presentation. Next we examine the use of Footers and Slide Numbering within PowerPoint 2016 Slide Shows Finally we see how to print your presentations and how to convert a presentation in to a video format.

Do you hide when someone mentions Microsoft Excel, or do you pretend to know more about them than you do, hoping you won't get caught out. Worry no more, this Microsoft Excel 2013for beginners course, designed for all levels of learner, is taught from the bottom up and is focused on the most important parts of Microsoft Excel that you will need to enable you to work in a busy office, dealing with spreadsheets or even just to make your home budget work better for you. At the end of the course you will be a competent Microsoft Excel 2013 user that will be an addition to any office. Practice material is supplied for you to practice the skills that are being shown so that you can get the best from this course. This Microsoft Excel for Beginners course will start of at the Basics like creating spreadsheets and work right up to the slightly more advanced features like if statements. This Microsoft Excel for beginners course is taught using simple descriptions so anyone starting spreadsheets for the first time will be able to understand the terms that are used. Sample exercises are provided so that you can practice the things that we learn in the lectures. If you want to go from being a Microsoft Excel Beginner to an advanced user, this is the first step.

**This course includes downloadable course instructor and exercise files to work with and follow along.**Welcome to PivotTables for Beginners, your gateway to mastering one of Excel's most powerful data analysis tools. This beginner-friendly course teaches you how to quickly create and manipulate PivotTables to summarize and analyze large datasets. You’ll learn to identify and remove blank rows, eliminate duplicate records, standardize formatting, apply proper text functions, and more—all key skills to ensure your data is ready for advanced insights. PivotTables are essential for anyone looking to gain insights from data, whether for business decisions, measuring KPIs, or spotting trends.Join us and transform how you handle data with PivotTables, making your analysis more dynamic and efficient. Course files are included and available to download, allowing you to follow along and practice as you learn. Dive in and discover how PivotTables can enhance your data analysis skills today.In this course, you will learn how to:Create and format basic PivotTables.Clean and prepare datasets for analysis.Apply filters and sort data in PivotTables.Create and customize PivotChart from PivotTable data.This course includes:88 minutes of video tutorials15 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

Mac or Windows? Why not both? Do you already know how to use a Windows computer but need or want to learn how to use a Mac? If so, then this course is for you. In this class, you’ll learn how to apply what you already know about Windows to the Mac, making it much easier and faster to learn. The goal of this course is to give you an overview of how the Mac operates, how to change important settings, and how to manage your files. In doing that, we will go over the dock, the menu bar, window behavior, the mouse and the trackpad, keyboard shortcuts, managing applications, creating and removing shortcuts, understanding file management, finding your way around, making selections, using an external hard drive, changing preferences, and file sharing. At the end of the course, you will know enough to be dangerous, and you’ll be ready to start learning all about the different applications that came with your Mac. You’ll start to see how by just learning a few basics, that you become a Master of your Mac! This course is designed for those who were comfortable using Windows and are now switching over to the Mac. It’s also for those who are considering making a switch but haven’t taken the plunge yet. It’s helpful if you already have a Mac, but if you don’t, you could certainly just watch the course and decide if this is something that you want to dive into.

Master Excel 365 – from the basics to powerful tools – in this step-by-step essential training course.Microsoft Excel is the world’s most popular spreadsheet program, used every day by businesses, students, and professionals for managing and analyzing data. Whether you’re a complete beginner or looking to refresh your skills, this course will help you build a strong foundation in Excel 365.In this Excel for beginners course, you’ll learn how to:Enter, organize, and format data in worksheetsPerform calculations using basic Excel formulas and functionsApply formatting to rows, columns, cells, and data for clarityWork with multiple worksheets efficientlyBuild Excel charts to visualize dataCreate and analyze PivotTables for data summariesUse sorting and filtering to manage large datasetsUse Data Management features like Goal Seek, Scenario Manager and Data TablesBy the end of this training, you’ll be confident in handling spreadsheets, performing calculations, and using Excel’s most essential tools for work, study, or personal productivity.This Excel 365 Essential Training course is designed for:Beginners who are new to ExcelProfessionals who need to improve their spreadsheet and data analysis skillsStudents looking to gain practical Excel knowledge for academic or career useStart your journey today and gain the Excel skills you need to work smarter, save time, and boost productivity.

Modern day report writing involves creating interactive reports that are published and shared with others within an organization. These reports must be accessible and usable on mobile devices. Microsoft's Power BI Report Builder joins the Power BI platform, along with other products, to deliver this functionality. This course is for beginners who need to learn how to create basic reports. In this course, reports are created, published, and accessed through a browser. The course begins with explanations of the related technology and necessary terminology. The steps for downloading Power BI Report Builder are demonstrated. The Power BI Service is introduced. Several completed reports are examined in order to explore the Report Builder environment and learn where all the necessary features are located. Data Sources are created that connect to several different data sources, including the Power BI Service itself. Datasets, which are essentially queries, are created next. Basic table reports are created and techniques for sorting and grouping follow. Matrices are created after the standard tabular reports are created. A matrix is as close we get to an Excel-style PivotTable in Report Builder. Expressions are like miniature formulae that often use Excel-style functions to produce results. Expressions are one of the most powerful aspects of Report Builder, so expect to see Expressions covered in the Intermediate and Advanced courses as well. Moving back to the Power BI Service, workspaces are examined as the containers for reports. Reports are stored here so that they may be shared with others. Finally, skills for printing, exporting, and publishing reports round out the course.