GCFGlobal.org
Word: Formatting Text
Do formatting choices like font size and color really matter when creating a document? Scholars learn how to make text stand out and grab readers' attention in Microsoft Word. They discover how to highlight text, change the text...
GCFGlobal.org
Word: Text Basics
If only life had an Undo button. Pupils learn how to use the Undo and Redo features in Microsoft Word. They also discover all things text, exploring how to select, delete, copy, paste, cut, drag, and drop text in a Microsoft Word...
GCFGlobal.org
Word: Saving and Sharing Documents
Sharing is caring! A lesson from the Microsoft Word series shows viewers how to save and share Word documents online. They also learn how to access files from OneDrive, Microsoft's online storage space.
GCFGlobal.org
Word: Creating and Opening Documents
What's the best way to create a new, blank document in Microsoft Word? Scholars learn how to open existing Word documents and discover how to access templates. Viewers also explore Using Compatability mode and learn about pinning and...
GCFGlobal.org
Word: Getting Started
How does Microsoft Word help people make professional-looking documents? Scholars explore the Word interface and learn how to access a blank document in a matter of seconds. They also discover the Quick Access Toolbar and learn how to...
GCFGlobal.org
Excel 2016: Creating More Complex Formulas
Please Excuse My Dear Aunt Sally! The 13th of 27 instructional videos from the Microsoft Excel 2016 set covers the order of operations. First, scholars review how to use the order of operations to solve math equations. Next, they see how...
GCFGlobal.org
Excel 2016: What-if Analysis
When someone wants to know what grade he or she needs on the final exam to pass the class, Excel's What-If Analysis feature helps figure it out. With the 27th and final installment from the Microsoft Excel 2016 video series, scholars...
GCFGlobal.org
Excel 2016: Doing More with PivotTables
How does pivoting add excitement? Learners discover how to make even the most mundane data more exciting with the 26th video from the 27-part Microsoft Excel 2016 series. In addition, they learn how to add filters and slicers to their...
GCFGlobal.org
Excel 2016: Intro to PivotTables
Sometimes too much information can be overwhelming. PivotTables to the rescue! Show scholars how to use PivotTables to summarize and manipulate content with a short, engaging video. Learners also discover how to use the feature to...
GCFGlobal.org
Excel 2016: Inspecting and Protecting Workbooks
What are the final steps to take when finalizing an Excel workbook? Scholars learn how to finalize and protect their files to keep others from making changes. Additionally, pupils learn how to use the Document Inspector to remove...
GCFGlobal.org
Excel 2016: Track Changes and Comments
Two heads are better than one! One convenient feature of Excel is that it allows users to collaborate on documents. With video 23 from the 27-part Microsoft Excel 2016 set, scholars discover how to use the Track Changes command. Viewers...
GCFGlobal.org
Excel 2016: Conditional Formatting
Under what conditions should people use conditional formatting in Excel? Using video 22 of 27 in the Microsoft Excel 2016 educational series, pupils learn how to use the conditional formatting command. Scholars discover how to use data...
GCFGlobal.org
Excel 2016: Charts
Sometimes, a chart is all a person needs to make sense of numerical data. With the 21st installment of the 27-part series on Microsoft Excel 2016, scholars learn how to create charts in Excel. Specifically, they discover how to change...
GCFGlobal.org
Excel 2016: Tables
How do Excel users create tables to format their worksheets? With the informative 20th video from the 27-part Microsoft Excel 2016 series, viewers learn how to format data as a table within a spreadsheet. Pupils also discover how to add...
GCFGlobal.org
Excel 2016: Groups and Subtotals
How do Excel users make their data more manageable? Video 19 of 27 from the Microsoft Excel 2016 set has the answer. Scholars learn how to use groups and subtotals to summarize and outline data. Users also discover how to manage a...
GCFGlobal.org
Excel 2016: Filtering
Is it possible to control which parts of an Excel spreadsheet are displayed? The answer is yes, and viewers learn how by watching the 18th video from the 27-part Microsoft Excel 2016 series. With a brief yet thorough overview, learners...
GCFGlobal.org
Excel 2016: Sorting
Sorting helps make sense of a lot of information at once. Using the 17th of 27 videos from the Microsoft Excel 2016 set, scholars learn about the types of sorting within an Excel spreadsheet. They explore sorting sheets and ranges,...
GCFGlobal.org
Excel 2016: Freeze Panes and View Options
Freeze! It's time to learn about freeze panes and view options. Using video 16 from the 27-part Microsoft Excel 2016 series, viewers learn how to freeze and unfreeze rows and columns in a spreadsheet. The video also includes information...
GCFGlobal.org
Excel 2016: Functions
When working with numerical data in a Microsoft Excel spreadsheet, which is better: formulas or functions? Pupils discover the answer through a short, instructional video. First, scholars learn about the parts of a function and...
GCFGlobal.org
Excel 2016: Relative and Absolute Cell References
What are the two main types of cell references in Excel? Scholars discover the answer through a short instructional video that models how to create and copy formulas using relative and absolute references. Additionally, users explore how...
GCFGlobal.org
Excel 2016: Intro to Formulas
How do techies use formulas in an Excel spreadsheet to calculate numerical data? A short instructional video teaches scholars about cell references, mathematical operators, and models how to create, copy, and edit formulas.
GCFGlobal.org
Excel 2016: Page Layout and Printing
Technology isn't always reliable, so it's important to know how to print back-up files of Excel workbooks. Viewers learn how to access and navigate the print pane with a short, instructional video. From there, they see how to print...
GCFGlobal.org
Excel 2016: Working with Multiple Worksheets
Is it possible to save a lot of data with customizable worksheets, all within the same Excel workbook? It sure is! Scholars learn exactly how with the 10th installment from the 27-part Microsoft Excel 2016 video set. Additionally, pupils...
GCFGlobal.org
Excel 2016: Using Find and Replace
There's a Lost and Found equivalent for Microsoft Excel, and it's called Find and Select! Viewers learn how to search for cell content in a spreadsheet and discover how to replace words and phrases within a Microsoft workbook.