Search for tag: "microsoft excel"

In Class Saver - Excel 4 - Part 2- K200

This video demonstrates how to: Insert Table; Table Design Ribbon; Total Row; Total Row: Sum, Min, Max; Copy/Paste variables; Currency & Accounting in Number Section; Filter; Remove table

From  Margaret Lion on October 4th, 2019 67 plays 0  

In-Class-Saver-Excel-4-Part-1-K200

This video demonstrates how to: Create an IF function; Use Conditional Formatting

From  Margaret Lion on October 4th, 2019 83 plays 0  

In Class Saver - Excel 3 - K200

Using Excel 2019, this video demonstrates how to: Use Function Library; Use PMT Function; Copy worksheet; Format titles; Rename worksheets; Color worksheet tabs

From  Margaret Lion on September 26th, 2019 114 plays 0  

In-Class-Saver-Excel-2-K200

Using Excel 2019, this video demonstrates how to: Create clustered column chart; change chart style; change chart color; create percentage formula; and anchor cell.

From  Margaret Lion on September 26th, 2019 93 plays 0  

Excel: Working with Data - Organizing Source Data for PivotTables

Explore how to organize source data in PivotTables in Excel.

From  ittrvid IT Training Video on January 16th, 2019 33 plays 0  

Excel: Working With Data - Introduction to PivotTables

Learn more about PivotTables in Excel with this video.

From  ittrvid IT Training Video on January 16th, 2019 43 plays 0  

Excel: Working With Data - Splitting Cell Contents

Explore how to split up data from a single cell into multiple cells in Excel.

From  ittrvid IT Training Video on January 16th, 2019 71 plays 0  

Excel: Working with Data - Working with Data and Formulas Across Worksheets

This video walks you through working with data and formulas across multiple worksheets in Excel.

From  ittrvid IT Training Video on January 16th, 2019 55 plays 0  

Excel: Working with Data - Copying Named Ranges

In this video, learn how to copy named ranges in Excel.

From  ittrvid IT Training Video on January 16th, 2019 103 plays 0  

Excel: Working With Data - Concatenating Data

Explore how to concatenate data in Excel in this video.

From  ittrvid IT Training Video on January 16th, 2019 62 plays 0  

K200 - Excel - In Class Saver 4

In this video you will learning: IF Function; Conditional Formatting; Table Creation & Table Uses; Total Row; Label Arrows > View and Filter Data; Copying from Table; Sorting Data; Filtering…

From  Margaret Lion on October 2nd, 2018 64 plays 0  

K200 - Excel - In Class Saver 3

Video covers: 1. PMT function; 2. Creating several PMT functions for comparison

From  Margaret Lion on September 24th, 2018 66 plays 0  

K200 - Excel - In Class Saver 2

Video covers: 1. Renaming file; 2. Chart creation;

From  Margaret Lion on September 24th, 2018 66 plays 0