Home
Videos uploaded by user “Prolific Oaktree”
Google Sheets - Highlight Duplicate Data in a Column or Row
 
02:07
Learn how to use conditional formatting in Google Sheets to highlight cells with duplicate data. To do a row instead of a column, use 1:1 to reference all of row one just like you use A:A to reference all of column A. I teach a course on conditional formatting here: http://bit.ly/cf_course This is an affiliate link and if you use it to make a purchase I will receive a portion of the proceeds. Thank you for supporting my channel!
Views: 138604 Prolific Oaktree
Google Sheets - Create an Interactive Task List
 
03:16
Create a to-do list in Google Sheets that formats tasks with a strike-through automatically when a check mark is clicked. I teach a course on conditional formatting here: http://bit.ly/cf_course This is an affiliate link and if you use it to make a purchase I will receive a portion of the proceeds. Thank you for supporting my channel! #prolificoaktree #googlesheets #checkbox
Views: 61808 Prolific Oaktree
Google Sheets - Compare Two Lists for Matches or Differences
 
04:22
If you have two lists and you want to see what values are in both, or what values are only in one list, this will show you how. Formulas used in video: =MATCH(D2,B$2:A$8,0) =ISNA(MATCH(D2,B$2:A$8,0))
Views: 44933 Prolific Oaktree
Google Sheets Pivot Tables - Basic Tutorial
 
05:53
Learn how to create a basic pivot table starting with the right kind of data and ending with an easy-to-read report. This tutorial will lead you through basic creation, how to fill columns and rows, fill the body of the table with data, and group by date. Timestamps: 0:33 Start with good data 1:09 Beginning to create 1:49 Make your columns and rows 2:53 Fill the middle with data 3:30 Analyze by date 3:45 Group by year 4:19 Filter by year 5:04 Other filters
Views: 15107 Prolific Oaktree
Google Sheets - Conditional Formatting Based on Another Cell
 
05:15
Conditionally format your data based on data from another range of cells. Learn how to do this using several examples based on real-world data. I teach a course on conditional formatting here: http://bit.ly/cf_course This is an affiliate link and if you use it to make a purchase I will receive a portion of the proceeds. Thank you for supporting my channel! #prolificoaktree #googlesheets #conditionalformatting
Views: 214213 Prolific Oaktree
G Suite vs. Free Google Apps | What is the difference?
 
08:10
See the enhancements in the G Suite (https://goo.gl/RhbaPv) calendar that are not in the free Google Calendar. They include office hours, resources, groups, and appointment slots. The link above will take you to the G-Suite program sign up page where you can use your discount code. Send me a message for your unique 20% off code at email: [email protected] Twitter: @ProlificOaktree FB: https://www.facebook.com/prolificoaktree G-Suite Pricing: http://bit.ly/gsuitepricing G-Suite Editions: http://bit.ly/geditions Timestamps 0:20 My calendars (co-workers, resources, tasks, reminders) 1:19 Other calendars (personal, holidays, etc.) 2:25 Looking at other g-suite calendars **When creating an event** 3:18 Find a time 3:32 Office hours 4:08 Hangouts meet 4:40 Choose a room 5:37 Out of office 5:45 Visitation hours 6:33 Groups 7:32 Resources 8:17 Calendar on Android 6:15 Document Sharing Options 7:03 Mobile Device Management 7:25 Security The first link in the description is an affiliate link. If you sign up for G Suite using the discount code that I send to you, I will receive a commission. This helps support the channel and allows me to continue to make videos like this. Thank you for your support! #prolificoaktree #gsuite #googleapps
Views: 67384 Prolific Oaktree
Google Sheets - Group Rows and Columns
 
03:31
Expand or collapse row and columns without losing any data. You can make groups and subgroups and only show the data that is most important.
Views: 35668 Prolific Oaktree
Google Docs - Hanging Indent
 
01:56
If you are writing an APA or MLA style works cited page, you probably want to use hanging indents. Follow these steps to format your Google Docs text with a hanging indent. ***There is an easier solution to this that was released in late 2018. See here https://youtu.be/4xJeBV6-7t4 ***
Views: 98013 Prolific Oaktree
Google Sheets - Pivot Tables | Summarize by Year, Month or Quarter
 
02:38
You can summarize pivot table data by any date or time section such as month, year, day of week, quarter, hour, etc. Build the table and then choose how to sort it.
Views: 8748 Prolific Oaktree
Excel Pivot Tables - Add a Column with Custom Text
 
03:22
See how to add a column (or row) of custom text to an Excel Pivot Table. The table will stay dynamic and, if you update the source data, the table will update with it. The column can contain any text that you want. Also, you can freely move and format the rest of the table once you make these changes.
Views: 11923 Prolific Oaktree
Microsoft Sway - Create, Design, and Share Your Story
 
08:22
See how to create a Sway in Office 365 (http://bit.ly/ofc_365) using a series of cards and how to use the built-in design templates to style it. Sway is meant to create presentations but it is very different from Powerpoint. Timestamps: 0:40 Create a Sway from a blank Sway 0:46 Title card 1:43 Header card 2:06 Text card 2:48 Comparison card 3:56 Design you Sway 5:30 Scroll direction 5:54 Custom palette 6:20 Templates 7:20 Sharing Sway is free or can be used as part of the Office 365 subscription service. For more information about Office 365, please use this affiliate link - http://bit.ly/ofc_365 #prolificoaktree #microsoftsway #office365
Views: 23949 Prolific Oaktree
Google Sheets - Calculated Fields in Pivot Tables
 
03:58
Learn how to use a Calculated Field to use formulas inside a Pivot Table. This video will show you show an example of a simple Pivot Table and then add to of the Pivot Table fields together.
Views: 41272 Prolific Oaktree
Google Sheets - Macro Tutorial with Examples
 
05:21
See a step-by-step description of using Macros in Google Sheets. This tutorial uses two examples to walk through the process of recording and using macros to format and prepare a spreadsheet.
Views: 14348 Prolific Oaktree
Google Sheets - Sum or Count Values Based on Cell Color
 
03:49
Learn how to create formulas that sum or count based on the background color of the cells. See the following links for the two formulas: http://igoogledrive.blogspot.lt/2015/11/google-spreadsheet-count-of-colored.html http://igoogledrive.blogspot.lt/2015/11/google-spreadsheet-sum-of-colored-cells.html Get Gmail, Google Sheets, Google Docs, etc at work by signing up for G Suite through this affiliate link - https://goo.gl/RhbaPv Send me a message for your unique 20% off code at email: [email protected] Twitter: @ProlificOaktree FB: https://www.facebook.com/prolificoaktree #prolificoaktree #googlesheets #spreadsheets
Views: 102575 Prolific Oaktree
Google Sheets - Add a Pop-Up Calendar Date Picker
 
02:14
Make it easy to insert dates using a pop-up calendar date selector in a cell in Google Sheets. There are just a few quick steps.
Views: 46607 Prolific Oaktree
Google Sheets - Count Cells Containing Specific Text
 
01:41
There are a few ways in Google Sheets that you can count cells with certain text. You can count the cells that contain only certain text or you can count cells that contain certain text inside of a longer string of characters.
Views: 39175 Prolific Oaktree
Add Email to Google Keep - No Extensions
 
02:01
You can add an email from your Gmail account directly into Google Keep. You can then use Keep to organize your notes including any emails that you added. #prolificoaktree #googlekeep #gmail
Views: 8577 Prolific Oaktree
Microsoft Sway - Embed a Live Excel Spreadsheet
 
02:15
Microsoft Sway allows you to embed an Excel spreadsheet, table or range from Excel online. Your Sway presentation will update automatically with the latest version of the Excel file.
Views: 3241 Prolific Oaktree
Google Sheets - Create Drop Down Lists and Check Boxes
 
07:03
Google Sheets lets you create drop down lists in a few easy steps. You can also create checkboxes and radio buttons, but they don't work quite as well as they are not built-in functionality. **+** As of April 2018, you can insert a checkbox right from the menus. See here: https://youtu.be/cOOrdL_JuF0 **+** Get Gmail, Google Sheets, Google Docs, etc at work by signing up for G Suite through this affiliate link - https://goo.gl/RhbaPv Send me a message for your unique 20% off code at email: [email protected] Twitter: @ProlificOaktree FB: https://www.facebook.com/prolificoaktree #prolificoaktree #googlesheets #checkbox
Views: 128690 Prolific Oaktree
Google Keep - Full Tutorial 2018
 
15:00
Learn all of the basics of using Google Keep. This tutorial covers everything that you need to know to start recording and organizing your notes. **Recording notes** - Start - Plain text note - 1:44 Drawing a note - 5:37 Note from an image (or camera) - 7:20 Note from voice - 7:53 Note from a link **Organizing notes** - 8:45 Coloring notes - 9:46 Labeling notes - 12:07 Pinning, archiving, and deleting - 13:09 Reminders - 14:02 Search and browse Get Gmail, Google Sheets, Google Docs, etc at work by signing up for G Suite through this affiliate link - https://goo.gl/RhbaPv Email me for your unique 20% off discount code at [email protected] #prolificoaktree #productivity #googlekeep
Views: 13713 Prolific Oaktree
Google Docs - Create a Table of Contents with Page Numbers or Links
 
04:43
Learn how to create a table of contents with page numbers or links. The formatting is driven by the formatting of your document as described in the video. Per the pinned comment below, Document outline has been moved to the View tab.
Views: 46593 Prolific Oaktree
Mask SSNs in a Spreadsheet
 
04:05
How to hide Social Security Numbers by changing them to XXX-XX-1234 using a few easy steps. Note: These SSNs are fictional so don't get to excited.
Views: 12876 Prolific Oaktree
Google Sheets - Comment vs Note
 
03:31
There are two methods of inserting extra text into cells without adding it to the content of the cell. Comment and Note. What is the difference?
Views: 11259 Prolific Oaktree
Google Docs - Setup your MLA Format Essay | New 2018 Features
 
06:42
How to setup your essay in Google Docs to adhere to the MLA standards. Learn the proper settings for your headers, margins, title, works cited page, etc. 0:15 Margins 0:43 Headers 2:20 Title 2:39 Double Spaced 3:29 First line indents 4:07 Horizontal Alignment 4:37 Font 4:49 Works cited general 5:31 Hanging Indent ***This video contains the vertical ruler and special hanging indent menu option that were added to Docs in late 2018.***
Views: 8067 Prolific Oaktree
Microsoft Forms | 2018 Full Tutorial
 
07:48
See how to create a survey, send it out, and analyze the results with this tutorial of Microsoft's Forms offered in Office 365. MS Forms has several different question types and gives you different ways to send the survey out to your respondents. Please use this affiliate link to find out more about Office 365 http://bit.ly/ofc_365 #prolificoaktree #microsoftforms #office365
Views: 84558 Prolific Oaktree
Google Sheets - Add (Or Subtract) Days, Months or Years to a Date
 
03:01
There are functions that you can use to add or subtract amounts to dates. It can be done in days, months, year, or any combination thereof.
Views: 19245 Prolific Oaktree
Create an Employee Timesheet Using Google Sheets
 
03:30
Create a simple template for tracking employee time, including overnights shifts, with no coding. Get Gmail, Google Sheets, Google Docs, etc at work by signing up for G Suite through this affiliate link - https://goo.gl/RhbaPv Send me a message for your unique 20% off code at email: [email protected] Twitter: @ProlificOaktree FB: https://www.facebook.com/prolificoaktree #prolificoaktree #googlesheets #spreadsheets
Views: 34730 Prolific Oaktree
Google Docs - Hanging Indent | New 2018 Hanging Indent Menu Option
 
02:43
If you are writing an APA or MLA style works cited page, you probably want to use hanging indents. Follow these steps to format your Google Docs text with a hanging indent.
Views: 2436 Prolific Oaktree
Google Sheets - Count Cells with Text Only - Not Numbers
 
03:05
Learn two different ways to count the number of cells in a range that have text instead of a number.
Views: 8530 Prolific Oaktree
Collect Data into Google Sheets | Forms, Quizzes, Surveys
 
08:18
You can gather data into your spreadsheet from users without them ever seeing or using your spreadsheet. Learn how to use Google Forms to get the data and bring it into Google Sheets for analysis. Timestamps: 0:35 Create a Form 1:07 Create your questions (different types) 4:37 Send the survey 5:14 Send by email 6:00 Send by link 6:17 Embed 7:05 Back to Sheet You can use Google Sheets and Forms for your business inside of G Suite (https://goo.gl/RhbaPv). Some benefits of G-Suite include custom email, user administration, and more storage in Google Drive. The link above will take you to the G-Suite program sign up page where you can use a discount code. Email me for your unique 20% off code at [email protected] G-Suite Pricing: http://bit.ly/gsuitepricing G-Suite Editions: http://bit.ly/geditions The first link in the description is an affiliate link. If you sign up for G Suite using this link, I will receive a commission. This helps support the channel and allows me to continue to make videos like this. Thank you for the support!
Views: 12044 Prolific Oaktree
Create a Check Register Using a Spreadsheet
 
02:53
A tutorial on the basics of creating a check register. Bring the register with you on your phone, tablet, or PC. Also, a little trick to create a low balance warning at the end of the video.
Views: 14615 Prolific Oaktree
Google Sheets - Group Data in a Pivot Table
 
02:05
You can group items together inside a pivot table without changing the source data. This tutorial will use example sales data and group it by territory.
Views: 4415 Prolific Oaktree
Google Forms - Create a Quiz
 
14:48
Learn all of the basics of creating a quiz in Google Forms. This tutorial covers what you need to know to make your first quiz including the different types of questions and overall settings. - Start - Creating your quiz - 0:32 Blank form - 1:57 Overall settings - 4:26 Multiple choice - 5:39 Short answer - 7:43 Check boxes and drop downs - 8:37 Previewing the quiz - 11:02 Multiple choice and check box grids - 13:05 Add a section Get Google Forms, Gmail, Google Docs, etc at work by signing up for G Suite through this affiliate link: https://goo.gl/RhbaPv Send me a message for your unique 20% off code at email: [email protected] Twitter: @ProlificOaktree FB: https://www.facebook.com/prolificoaktree #prolificoaktree #googleforms #forms
Views: 10858 Prolific Oaktree
Microsoft Whiteboard | 2018 Overview (Preview Version)
 
05:40
Whiteboard is Microsoft's attempt at a virtual whiteboard that can be shared with other users. We'll take a tour of the app's markers, ink-to-shape, shape-to-table, and other features. Please use this affiliate link to find out more about Office 365 http://bit.ly/ofc_365 Office 365 allows you to use Microsoft’s entire office suite for your business. #prolificoaktree #whiteboard #office365
Views: 4533 Prolific Oaktree
Microsoft To-Do vs. Google Tasks
 
10:30
Microsoft To-Do and Google Tasks are both productivity apps that help you record, organize, and complete tasks. They are similar, but there are several interesting differences that we will discover as we walk through this comparison. #prolificoaktree #MicrosoftToDo #GoogleTasks
Views: 5541 Prolific Oaktree
How to Find the Plus Code for any Location
 
01:58
Learn how to find the Plus Code for any area in the world. The Open Location Code method uses a new system to designate places around the globe. It is designed to be easier to use than latitude and longitude or street addresses.
Views: 2744 Prolific Oaktree
Google Sheets - Full Tutorial 2018
 
35:14
Learn all of the basics of using Google Sheets. This tutorial covers everything that you need to know to start using Sheets. - Start - Creating a Sheet - 4:58 Format your Sheet - 13:14 Use cell references - 20:39 Create formulas - 26:56 Sort and filter
Views: 285898 Prolific Oaktree
Microsoft To-Do | 2019 Full Tutorial
 
10:30
To-Do is a task management app that helps you organize your day. It has an innovative "My Day" feature that lets you plan every day from scratch by pulling in your tasks. Timestamps: 1:00 Adding our first task 1:32 Creating a list 3:00 Add a due date 3:14 Add a file attachment 3:28 Add a note 4:08 Add a reminder 5:16 Add steps (sub-tasks) 6:43 Flagged emails and assigned tasks 7:20 Planned (agenda view) 8:09 Important (starred) 8:31 My Day Please use this affiliate link to find out more about Office 365 http://bit.ly/ofc_365 Compare Microsoft To-Do to Google Tasks: https://youtu.be/bQ23vd_DqtI #prolificoaktree #office365 #microsofttodo
Views: 2112 Prolific Oaktree
Microsoft To-Do | 2018 Full Tutorial
 
05:01
To-Do is a task management app that helps you organize your day. It has an innovative "My Day" feature that lets you plan every day from scratch by pulling in your task. Please use this affiliate link to find out more about Office 365 http://bit.ly/ofc_365 Thanks to Gaming Genes (below) for pointing out that To-Do now accepts file attachments. #prolificoaktree #office365 #microsofttodo
Views: 97822 Prolific Oaktree
Microsoft Stream - Full Tutorial 2018
 
09:50
See how to upload, organize, and share videos using Microsoft's Stream app. It is part of the Office 365 (http://bit.ly/ofc_365) subscription service. Stream is designed to share videos within a company, enabling the creation of a corporate video library. Timestamps: 0:31 Upload and Described Your Video 1:58 Permissions (Groups, People, Channels) 3:12 Subtitles 4:29 Navigating Posted Videos 5:20 Channels 6:52 Auto-CC 7:35 Share (Email, Embed, Jump to Sections) The Office 365 link above is an affiliate link. Purchasing Office 365 through this link helps support the channel and allows me to continue to make videos like this. #prolificoaktree #microsoftstream #office365
Views: 12611 Prolific Oaktree
Combine Cell Contents from Two Different Columns in Google Sheets
 
02:03
Combine the data in two (or more) different columns in Google Sheets together. Each row's cells can be merged and the output is combined with optional extra characters added as well.
Views: 12013 Prolific Oaktree
10 Most Often Used Functions in Google Sheets
 
09:01
Learn how to use the most common functions available in Google Sheets. When you use a spreadsheet, you spend most of your time utilizing only a handful of the hundreds of available functions. We will review the top 10 and give examples of how to use them.
Views: 2733 Prolific Oaktree
Embed a Spreadsheet from Google Sheets into Google Slides
 
04:00
Learn how to add a live linked spreadsheet table into your Google Slide from Google Sheets. It will change if you update your spreadsheet. Includes tips on how to format and add rows or columns.
Views: 30899 Prolific Oaktree
Google Sheets - Show Formulas
 
01:39
You can see all of the formulas in your spreadsheet by following these easy steps. It will change the cell display from value to formulas.
Views: 3944 Prolific Oaktree
Embed a Spreadsheet from Google Sheets into Google Docs
 
04:42
Learn how to add a live linked spreadsheet table into your Google Doc from Google Sheets. It will change if you update your spreadsheet. Includes tips on how to format and add rows or columns.
Views: 47212 Prolific Oaktree
Google Docs - Full Tutorial 2018
 
25:35
Learn all of the basics of using Google Docs. This tutorial covers everything that you need to know to start using Docs. - 0:00 - Creating a Doc and Basic Formatting - 8:32 - Paragraph Styling and Page Setup - 15:10 - Bookmarks and Links - 20:41 - Table of Contents
Views: 77015 Prolific Oaktree
Excel Keyboard Shortcuts for Accountants
 
03:28
Become faster at Excel by learning to utilize keyboard shortcuts to get your job done faster. This video will show you how to use the keyboard to select an entire table and sum the data. It will walk you through deleting columns and rows and other useful tasks.
Views: 9216 Prolific Oaktree
Google Sheets - Protect Cells
 
02:54
How to lock the content of cells or ranges of cells and decide who can or cannot edit them. See written instructions at prolificoaktree.com
Views: 56170 Prolific Oaktree
Microsoft To Do | Use the "My Day" Function
 
03:26
To-Do is a task management app that helps you organize your day. It has an innovative "My Day" feature that lets you plan every day from scratch by pulling in your task. Please use this affiliate link to find out more about Office 365 http://bit.ly/ofc_365 #prolificoaktree #office365 #microsofttodo
Views: 3205 Prolific Oaktree
Google Sheets - Insert Text Box
 
03:37
Learn how to insert a text box into Google Sheets. It is not easy to find in the menus, so you have to dig a little bit to find it. The text box does not reside in a cell so it can lay on top of your data without changing it.
Views: 25999 Prolific Oaktree