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 95 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 114 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 115 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 41 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 53 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 81 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 62 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 117 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 69 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 70 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 100 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 66 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 104 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 84 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 110 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 93 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 76 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 150 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 85 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 113 plays 0