Search for tag: "excel"

Excel Workspace Overview

Gives an overview of the Excel wprkspace, including the menus, formula bar, and worksheets

From  Chad Snow on May 16th, 2020 2 plays 0  

Getting Started with Microsoft Excel Webinar - April 14th, 2020

Rows & columns? Numbers & letters? Formulas & functions? How do I even get started in Microsoft Excel? Watch this quick webinar and jump into Microsoft Excel spreadsheets! To sign up…

From  ittrvid IT Training Video on April 23rd, 2020 30 plays 0  

Getting Started with Pivot Tables Webinar - April 21st, 2020

Your friends say they love Excel PivotTables, but all you can do is nod and smile? Attend this quick webinar to find out what the PivotTable excitement is all about. Learn how to get answers from…

From  ittrvid IT Training Video on April 21st, 2020 12 plays 0  

Getting Started with Sorting and Filtering in Excel Webinar - April 16th, 2020

Have good data in Microsoft Excel but need to re-organize it? Or narrow it down? View this quick webinar to learn how to see what you want to see in Microsoft Excel. To sign up for IT…

From  ittrvid IT Training Video on April 16th, 2020 10 plays 0  

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 96 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 116 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 118 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 95 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 85 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 102 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 159 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 104 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 209 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 117 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 67 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  

K201 Lab Class 23 - Charts and Tables

BL BUS K201 Lab Class 23, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on November 27th, 2017 76 plays 0  

K201 Lab Class 22 - Text Functions

BL BUS K201 Lab Class 22, Fall 2017 Adjunct Professor Adam

From  Adam Sweeny on November 15th, 2017 111 plays 0  

K201 Lab Class 21 - Data Validation

BL BUS K201 Lab Class 21, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on November 13th, 2017 77 plays 0  

K201 Lab Class 20 -Data Tables

BL BUS K201 Lab Class 20, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on November 8th, 2017 116 plays 0  

K201 Lab Class 19 - Index, Match

BL BUS K201 Lab Class 17, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on November 6th, 2017 94 plays 0  

K201 LAB Class 18 - Retrieval Functions (VLOOKUP, HLOOKUP, MATCH)

BL BUS K201 Lab Class 17, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on November 1st, 2017 114 plays 0  

K201 Lab Class 17 - Compound Nested Ifs

BL BUS K201 Lab Class 17, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on October 30th, 2017 105 plays 0  

K201 Lab Class 16 - Logical Functions

BL BUS K201 Lab Class 16, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on October 25th, 2017 86 plays 0