Sign up for the CNET Deals Text to get daily deals sent straight to your phone. Add the free CNET Shopping extension to your browser for real-time price comparisons and cash-back offers. And peruse our gift guide, which includes a full range of ideas for birthdays, anniversaries and more.

Simply click it and you will be taken to a page where you can give a quick rating and leave a short comment for the product. Each time you give feedback, TPT gives you feedback credits that you use to lower the cost of your future purchases. Your feedback is much appreciated, and helps me provide more work that you are looking for. „I enjoyed the course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you.“ Use to restrict users ability to enter invalid data in cells by providing them with a drop down list of valid options.

Buy Microsoft Office and Windows 11 Pro for just $50

Microsoft Excel remains the go-to spreadsheet software for millions of people around the world. If you’ve been meaning to learn Excel for years but haven’t quite got around to it, or if you use Excel every day but feel lost when you log in, then this course is for you. Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells.

Just like charting, Excel’s PivotTables are too big a topic to fit into one lesson. So, today, we’ll take PivotTables to the next level by taking a tour through some of Excel’s more advanced techniques. You’ll learn how quick and easy it is to group your data to give your PivotTable even more power.

Start Your Membership

Learn to break apart text with the LEFT, RIGHT, MID, FIND and SEARCH functions, and to combine text with the & character. Learn to build standalone logical IF functions, and make them more complex by nesting AND and OR within them. Format cells by selecting fonts and color fills to make information more attractive. Utilize the keyboard or mouse to select cells and ranges in a spreadsheet.

Microsoft will offer extended support for this version through Oct. 14, 2025, though there is always a risk that Microsoft could terminate the license at any time. That said, we’ve been running other versions of Office from StackSocial since early 2022 and it still works just fine. This course includes an optional online quiz that will generate a course certificate upon completion.

Microsoft Office 2019 Basics Bundle

Lesson 6 – This lesson covers sparklines, pareto charts, and subtotals, and also provides an overall review of the most common features on the MOS test. They will learn some of the file features as well like customizing quick access bar and ribbons, show formulas, etc, and review graphing. There’s nothing more exciting than learning how to master a useful and eye-catching feature in Excel. In today’s lesson, we’ll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you’ll have the skills to create dashboard-like mini charts sure to make you the envy of your office.

This bundle contains lessons all 8 lessons in my 8 part series and includes all files needed to complete the unit. This bundle will save you money if you get it instead of getting the bundles separately. These tutorials can serve as a time-saver in terms of shortcuts and help users Microsoft Excel 2019 Lessons craft better resumes and presentations. The courses on Excel alone will open up the data analysis possibilities of this data-crunching powerhouse and be a great help in many IT careers. If you’ve used Excel for a while, you know there are hundreds of functions at your disposal.

Intermediate Microsoft Excel 2019 (Self-Paced Tutorial)

Even though they aren’t well-known, these options can add tremendous value to your worksheets in the right situations. We’ll walk through a few of them step-by-step, so you’ll see the value for yourself. This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. Microsoft Excel has a wide range of tools and functions and it can take you time to become proficient in it and all its features.