Quick autosum | Cornerstone Learning Hub

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Microsoft office tips and timesavers

Office 365

Office 365 apps vs. desktop applications
Access your Office 365 account
Do you know Office 365, OneDrive, and Windows 10 Quiz
Quick reference guides

OneDrive for Business

OneDrive for Business (14:27)
OneDrive Environment (1:19)
OneDrive AutoSave (1:37)
OneDrive File and Folder Options - File Versions (1:43)
OneDrive File Storage and Navigation (1:41)
OneDrive Folder and File Actions (1:03)
OneDrive Introduction (1:39)
OneDrive Open Files in Web View (1:57)
OneDrive Save Files from Applications (1:35)
OneDrive Search (1:48)
OneDrive Share Files (1:58)
OneDrive Sign In to OneDrive (1:24)
OneDrive Sorting Bar Introduction (1:23)
OneDrive Upload and New (3:15)

Onenote features

Getting organized with electronic notebooks (1:19)
Create notebooks, sections, and pages (5:41)
Inserting objects (8:11)
Onenote and Microsoft applications (7:17)

Word features

Word Dictation and Read Aloud Features (2:18)
Quick tables (6:28)
Quick parts (4:36)
Reuse headers and footers (3:50)
Convert pdf to word document (3:01)
Building blocks (4:41)
Word Building Block Organizer (4:41)
Word Convert PDF to Word document (3:01)

Excel features

Use autofill for patterns (2:46)
Quick autosum (3:03)
Shortcuts for charts (2:20)
Use flash fill for data manipulation (6:42)
Separating data and combining data (17:25)
Excel 3D Maps (4:09)
Excel 3D Maps add dates (4:30)

PowerPoint features

Creating slides quicker (3:09)
Inserting media (3:18)
PowerPoint Quickstarter (4:47)
Working with bullets (4:15)
Design ideas (3:13)
PowerPoint Shapes Merge Shapes Create Logo (3:05)
Smart Art (7:14)
New transitions
Adding animations
PowerPoint Design Ideas2 (6:08)
PowerPoint Show - Save as PPSX - file format (2:55)
PowerPoint Summary Slide Zoom (7:43)
PowerPoint Slide show = Rehearse coach (3:25)
Creating a video (4:21)
PowerPoint Format Using Eyedropper (2:15)
PowerPoint Handouts - in PowerPoint or Word (2:44)
PowerPoint Hyperlinks (2:51)
PowerPoint Sections (2:16)
PowerPoint Shapes Align Shapes (2:02)

Planner

Planner Basics (20:22)
Planner app introduction (1:28)
Planner Create New Plan and Add Buckets (2:30)
Planner Export to Excel (1:36)
Planner Favorites (0:25)
Planner Filter (1:04)
Planner Group By (1:22)
Planner Members Add New Members (0:46)
Planner My Tasks (1:09)
Planner Tasks Add Checklist (2:27)
Planner Tasks Add Labels (1:46)
Planner Tasks Add Tasks (3:00)
Planner Tasks Copy Task (3:33)
Planner Tasks Editing Tasks (2:47)
Planner Teams Add Plan to Teams (3:01)
Planner Teams Go to Website (1:14)
Planner Views (2:21)

Windows 10

Windows 10 Intro 2 (0:41)
Windows 10 Intro (0:44)
Windows 10 Steps Recorder (3:22)
Windows 10 Dictate (2:10)
Windows Tip 2 Show Desktop (0:57)
Windows Tip 1 Snip and Sketch (2:03)
Windows 10 Snip and Sketch (no audio demonstration) (2:14)
Windows 10 Hide Desktop Icons (0:51)
Windows 10 Whiteboard (1:50)

Power Query

Power Query - Split Columns (9:05)
Power Query - Unpivot Data (6:18)

Outlook

Outlook Email Selecting data 4 shortcuts (1:32)
Outlook Email Screen Clipping timesaver (2:32)
Outlook Email attach files shortcut (1:35)
Outlook Shortcut Email Quick part (2:22)
The organized inbox
Outlook Email attach files shortcut (1:35)
Outlook Email Selecting data 4 shortcuts (1:32)

Teams

Teams Conversations and Options (6:16)
Teams Chat (2:35)
Teams Overview Teams Application Overview (5:59)
Teams Files add, delete, upload in channels (4:38)
Teams Channel add an Outlook email to Channel conversation (1:35)
Teams Phone Calls (2:12)
Teams Create channels (3:02)
Teams Tabs Using and Adding (4:29)
Teams Search functionality (2:50)
Teams Pro Tip Conversations Format to add subject (3:01)
Teams Create a team (3:52)
Teams Files Working with files on tabs and files view (4:06)
Teams Filter (1:37)

Teach online with

Quick autosum

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock