Category: Microsoft Excel

Microsoft Surface 2019 event in under 11 minutes

Microsoft’s 2019 Surface event was filled with big announcements, including the Surface Neo dual-screened device that runs Windows 10X, the Android-powered Surface Duo, and the Surface Pro X that’s built with a custom Qualcomm SQ1 chipset. The Surface Pro 7’s debut wasn’t much of a shock, but there were other surprises, too, like the new Surface Earbuds, and the debut of a Surface Laptop 3, which will be available in 13- or 15-inch sizes.

Read more:
Microsoft Surface Neo first look:
Surface Laptop 3 hands-on:
Surface Pro X and Surface Pro 7 hands-on:
Surface Earbuds hands-on:

Like The Verge on Facebook:
Follow on Twitter:
Follow on Instagram:

Why’d You Push That Button Podcast:
The Vergecast Podcast:
More about our podcasts:

Read More:
Community guidelines:
Wallpapers from The Verge:

Subscribe to Verge Science on YouTube, a new home base for our explorations into the future of science:

Learn Pivot Tables in 6 Minutes (Microsoft Excel)

Interested in more? You can use the following link to enroll in my $10 course, “Become a Microsoft Excel Wizard in 1 Hour”:

Learn pivot tables in 6 minutes… Pivot tables allow you to automatically summarizes your data… so you can “slice-and-dice” in a million ways. This means you can replace lots of hand-typed summary calculations with more automated reporting. To create a pivot table, select a cell in your table and click “PivotTable” on the “Insert” tab. This works in Microsoft Excel 2010, 2013, and 2016.

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Download file used in the video:

In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts.

Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac

Don’t worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables.

Download the files to follow along at the following link.

I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I’m using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video.

Get PivotPal:

Free webinar on The 5 Secrets to Understanding Pivot Tables:

Subscribe to my free newsletter:

Top 25 Excel 2016 Tips and Tricks

The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly. My personal favorite is #21. Become more productive using Excel at work, school and home.

Check out the Advanced Excel video at

Another 15 Excel 2016 Tips & Tricks:

1. Quick Analysis Tool 0:47
2. Filter 1:44
3. Drop-Down List 2:25
4. AutoFit Column Width 3:12
5. Transpose 3:47
6. Remove Duplicates 4:13
7. Goal Seek 5:23
8. VLOOKUP 6:55
9. Flash & Auto Fill 9:06
10. Paste Special Values 10:47
11. Images in Charts 11:50
12. IF Function 12:28
13. Insert Screenshot 13:40
14. Absolute Cell Reference 14:15
15. Show Formulas 15:54
16. Text to Columns 16:57
17. Conditional Formatting 18:11
18. PowerPivot 19:36
19. Freeze Panes 20:46
20. Ctrl-Arrow Keys 21:40
21. 3D References 21:58
22. Forecast Sheet 23:43
23. SUMIFS Function 24:16
24. IFERROR Function 25:38
25. Filled Maps 26:30

The Beginner’s Guide to Excel – Excel Basics 2017 Tutorial

Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it’s easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.
***Consider supporting Technology for Teachers and Students on Patreon***:

Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels:
The Princess Bride:
Young Sherlock Holmes:
Mystery Men:

Excel Tutorial: Learn Excel in 30 Minutes – Just Right for your New Job Application

Learn how to use Excel in exactly 30 minutes starting with the very basics (for the complete beginner) and then move to more intermediate features such as charts, mail merges and reports. For more info. and to learn more visit

I have designed it to be a resource for anyone starting to learn Excel or is applying for a job and wants to know how to use Excel and enhance their resume with Excel skills. The tutorial is based on Excel 2016 and all features also work in Excel 2013, Excel 2010 and 2007.

If you like the video, please “Like,” “Favorite,” and “Share” it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

The full Excel 2016 Tutorial is available from here:….

In more detail, as you can see below, it includes everything you would need to know to sharpen your skills for a new job application.

Data File if you need to follow the tutorial hands-on:

Learn concepts related to Excel spreadsheets such as cells and references and formulas.
Learn how to enter formulas in Excel including, SUM, AVERAGE, MAX, MIN etc.
Learn about other mathematical calculations in Excel.
Learn how to sort and filter data in Excel.
Learn how to create charts in Excel.
Learn how to change the page layout and create headers and footers and change the margins including setting the printing area.
Learn how to use conditional formatting and other formatting features in Excel.
Learn how to do cross-sheet calculations in Excel.
Learn how to even perform mail merges in Excel
Learn how to link a spreadsheet with Word for reports.
Learn how to email an Excel spreadsheet and even save it as a PDF.

Excel in 30 minutes URL:

Keep in touch:
YouTube Channel:
If you want to take get a deeper understanding of Microsoft Office applications, take a look at

**Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

Microsoft Build 2018 // Vision Keynote

CEO Satya Nadella takes the stage at Microsoft Build, our annual developer conference, at 8:30AM PT Monday, May 7. Join us to learn what’s next for developers:

Subscribe to Microsoft on YouTube here:

Follow us on social:

For more about Microsoft, our technology, and our mission, visit

Introducing Microsoft Surface Hub 2

Turn any space into a teamwork space. Built for teams to work seamlessly together wherever they are, it scales and adapts to any space. Say hello to Surface Hub 2, coming in 2019.

Read the announcement: