Learning Office Tutorials

Learn to use Excel Form Controls & PivotTable (spin button, scroll bar, slicer,...) to create dynamic charts & graphs.
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 827.43 MB | Duration: 1h 32m

Excel VBA
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 17.24 GB | Duration: 26h 22m

This course includes downloadable instructor files and exercise files to work with and follow along.**Take control of your data and discover the power of Access 2021, the latest on-premises release from Microsoft and the newest addition to the Access family of applications. Microsoft Access 2021 is so much more than a way to create customizable desktop databases. It is fair to say that Access 2021 is a user-friendly tool that allows us to create business applications and templates from scratch without the need for high-level development skills.Access 2021 allows even the novice database builder to start creating tables, forms, queries, and reports quickly. It is a full life-cycle database management tool that makes creating small to large databases easy.In this course, we will explore the basic functionality of Access and get familiar with the terminology, the interface, and the commands. We'll look at the available templates and build tables and populate them with data. We'll create relationships between tables and build queries to interrogate the data. We'll look at building nicely formatted forms so others can interact easily with our database and build custom reports to help us gain deeper insight.This course is for the absolute beginner or anyone who is looking to refresh their basic skills. It will provide a fantastic starting point from which to build more advanced Access database knowledge.In this course, students will learn how to:Explain what a relational database isDownload and install Access 2021Know the differences between Access 2019 and Access 2021Locate, open, and save Access database templatesOpen, close, and save a blank database fileNavigate the Access interface, ribbons, and commandsCustomize the quick access toolbar with frequently used commandsUnderstand the different menu systems in AccessUse keyboard shortcuts to navigate and execute commandsAccess the help filesCustomize Access optionsCreate tables and fieldsModify field propertiesUnderstand index fields and primary keysCreate lookup menusAdd data validation and data validation text to fieldsImport data into a table from Excel and from a text fileUse datasheet view to manage dataSort and filter records in a tableCreate relationships between tables that share a common fieldCreate relationships between tables using a link tableUnderstand one-to-many relationshipsCreate and design user-friendly formsSetup subformsBuild simple and complex queries to interrogate table dataAggregate numeric dataCreate expressions to perform simple calculationsCreate and run a basic reportCreate a custom reportUse form controls to add checkboxes, attachments, and option buttons to formsModify a form's design and themeCreate a navigation formExport an Access database to other file formatsProtect a database file by adding encryption and password protectionPrevent database issues using compact and repairPrint tables, forms, and reports.This course includes:7 hours of video tutorials66 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
Published 2/2023
Created by Simon Sez IT
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Students: Excel is commonly used in many fields of study, including science, finance, and business, and having a strong understanding of the program can help students succeed in their coursework.Professionals: Excel is a powerful tool for data analysis and management, and professionals in fields such as accounting, finance, marketing, and project management can benefit from a deep understanding of the program.Entrepreneurs: Excel can help entrepreneurs manage their finances and track their business growth, as well as create marketing plans and analyze customer data.Job seekers: Many jobs require knowledge of Excel, so taking an Excel course can make job seekers more competitive in the job market.Anyone looking to improve their productivity: Excel can be used to streamline many different tasks, from creating lists and charts to managing schedules and budgets.You can learn how to enter and format data in Excel, including how to add, delete, and modify cells and rows, format numbers and text, and use Excel's built-in functions to manipulate data.Excel provides a wide range of data analysis tools, including pivot tables, data sorting and filtering, and various statistical functions. You can use these tools to explore and understand large data sets and to identify trends, patterns, and outliers.Excel is widely used for financial modeling, including creating and analyzing financial statements, forecasting revenue and expenses, and conducting sensitivity analysis. By learning how to use Excel for financial modeling, you can develop a range of valuable skills that are highly sought after by employers.Excel also includes a variety of tools for creating graphs and charts to help you visualize your data. You can learn how to create different types of graphs and charts, including bar graphs, line charts, pie charts, and more.Overall, an Excel course is for anyone who wants to improve their knowledge and skills with the program, regardless of their background or profession.
The complete Excel course compatible with MS Office 365, or any version of Excel
What you'll learn
Master Microsoft Excel from Beginner to Advanced

Description
If you're looking to become an Excel pro and level up your skills, you've come to the right place. In this comprehensive course, you will learn everything from the basics of formatting and formulas to advanced techniques such as creating pivot tables and charts, working with text functions, and auditing your spreadsheets. Whether you're a beginner or looking to brush up on your skills, this course is designed to take you from a basic level to an advanced level of proficiency in Excel.We will start with the basics of formatting, including how to format fonts, numbers, cells, freeze rows and columns, and use the Text-to-Columns feature effectively. Then, we will dive into essential Excel functions such as SUM, SUMPRODUCT, CONCATENATE, VLOOKUP, HLOOKUP, COUNT, COUNTA, COUNTIF, SUMIF, AVERAGE, MAX, MIN, and many more. You will learn how to create pivot tables and charts, and use the latest text functions such as TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, CHOOSECOLS, CHOOSEROWS, TAKE, DROP.Moving on, you will learn about Excel finance functions such as NPV, XNPV, IRR, XIRR, MIRR, RATE, NPER, PV, PMT, IPMT, FV, FVSCHEDULE, and EFFECT. Additionally, you will learn how to protect and unprotect sheets and break the password if you forget it. You will also explore amazing copy and paste options such as paste math operations, paste column widths, paste visible cells, and paste comments. You will learn how to manage external links, print an Excel workbook, and round numbers using functions such as ROUND, ROUNDDOWN, ROUNDUP, TRUNC, INT, MROUND, CEILING, FLOOR, EVEN, ODD.We will then cover functions to extract data from cells, including LEFT, MID, RIGHT, and the game-changing Flash Fill. You will learn how to switch rows and columns using the TRANSPOSE function, and how to use XLOOKUP effectively. Additionally, you will learn how to change the case of text and remove unnecessary spaces.By the end of this course, you will have a comprehensive understanding of Excel, and be able to confidently use it to analyze data, create reports, and make informed decisions. You will have the skills to take your career to the next level, and stand out as an Excel expert.So, what are you waiting for? Sign up for this Excel online course today and start your journey to becoming an Excel pro!

Description
Hey there, software sales superstar! Are you ready to boost your sales game to the next level in 2023? I'm talking about making those deals rain like confetti at a New Year's party! And don't worry. You won't need to wear a top hat or wield a magic wand to make it happen.In this course, we'll take your Excel skills from 'meh' to 'yeah!' You'll be able to crunch numbers faster than a hungry beaver chomping on wood. We'll even show you how to use ChatGPT to write your formulas for you, so you can take all the credit for being a spreadsheet ninja.But that's not all, my friend! We'll also teach you how to turn soft product benefits into hard, cold cash that your customers will salivate over. You'll learn how to create custom quotes that will make your competitors green with envy. They'll be scratching their heads, wondering how you managed to close those mega deals with ease.And let's not forget about our good friend, ChatGPT. This AI wonder will help you tailor your story to each customer's unique needs. It's like having a personal storyteller in your pocket, except without the funny hat and silly voice.So invest in yourself. Sign up for this class and start raking in those sales like it's going out of style. Your competition won't know what hit them, and your bank account will thank you!

Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.32 GB | Duration: 4h 9m
The Virtual Assistant's Guide to Excel
What you'll learn

Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.05 GB | Duration: 2h 46m
Build powerful add-ins in Excel
What you'll learn

Published 2/2023
Created by Arthur Cameron
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 11 Lectures ( 4h 3m ) | Size: 2.4 GB
Microsoft Excel, create basic formulas

Published 2/2023
Created by Phillip Burton
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 109 Lectures ( 8h 24m ) | Size: 5.16 GB
Learn the skills for the new MO-210 Excel certification. Create tables, formulas, charts and manage workbooks.