Search for tag: "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 43 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 55 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 56 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 51 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 19 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 23 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 39 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 23 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 52 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 38 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 59 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 62 plays 0  

K200 - Excel - In Class Saver 2

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

From  Margaret Lion on September 24th, 2018 55 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 52 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 73 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 49 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 80 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 71 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 87 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 74 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 61 plays 0  

K201 Lab Class 15 - Financial Analysis

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

From  Adam Sweeny on October 23rd, 2017 124 plays 0  

K201 Lab Class 14 - Conditional Aggregates and Dates

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

From  Adam Sweeny on October 18th, 2017 64 plays 0  

K201 Lab Class 12 & 13 - Excel and Cell Referencing

BL BUS K201 Lab Class 12/13, Fall 2017 Adjunct Professor Adam Sweeny

From  Adam Sweeny on October 16th, 2017 83 plays 0