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: http://bit.ly/2n1n9I0
Microsoft Surface Neo first look: http://bit.ly/2owUIC3
Surface Laptop 3 hands-on: http://bit.ly/2ovb5za
Surface Pro X and Surface Pro 7 hands-on: http://bit.ly/2owDKnv
Surface Earbuds hands-on: http://bit.ly/2n4Dpbi

Subscribe: http://goo.gl/G5RXGs
Like The Verge on Facebook: https://goo.gl/2P1aGc
Follow on Twitter: https://goo.gl/XTWX61
Follow on Instagram: https://goo.gl/7ZeLvX

Why’d You Push That Button Podcast: https://pod.link/1295289748
The Vergecast Podcast: https://pod.link/430333725
More about our podcasts: https://www.theverge.com/podcasts

Read More: http://www.theverge.com
Community guidelines: http://bit.ly/2D0hlAv
Wallpapers from The Verge: https://bit.ly/2xQXYJr

Subscribe to Verge Science on YouTube, a new home base for our explorations into the future of science: http://bit.ly/2FqJZMl

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”: https://www.udemy.com/microsoft-excel-in-just-1-hour/?couponCode=youtube10.

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)

WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y
Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt

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.
http://www.excelcampus.com/pivot-table-checklist-yt

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. http://www.youtube.com/watch?v=Jt_QqG-vRRw

Get PivotPal: http://www.excelcampus.com/pivotpal

Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt

Subscribe to my free newsletter: http://www.excelcampus.com/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 https://youtu.be/PU8ACyYxJBk.

Another 15 Excel 2016 Tips & Tricks: https://youtu.be/L9SKTj2gevA

Contents:
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***: https://www.patreon.com/technologyforteachersandstudents

Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels: http://amzn.to/2xTpck1
The Princess Bride: http://amzn.to/2yk3tDc
Ladyhawke: http://amzn.to/2xOhLsA
Stardust: http://amzn.to/2yjJvs9
Young Sherlock Holmes: http://amzn.to/2xaJJNv
Mystery Men: http://amzn.to/2yRmQ3r

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 http://learn.kaceli.com.

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: https://www.youtube.com/watch?v=8lXer….

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: https://kaceli.com/a/excel-2016-data-file/

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: https://youtu.be/7RCdzTpKO0A

Keep in touch:
Website: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli
If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com

**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: https://news.microsoft.com/build2018/

Subscribe to Microsoft on YouTube here: https://aka.ms/SubscribeToYouTube

Follow us on social:
LinkedIn: https://www.linkedin.com/company/microsoft/
Twitter: https://twitter.com/Microsoft
Facebook: https://www.facebook.com/Microsoft/
Instagram: https://www.instagram.com/microsoft/

For more about Microsoft, our technology, and our mission, visit https://aka.ms/microsoftstories

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: http://bit.ly/2rFSr67