Excel Level 2
 
Organizing WorkbooksTime
   Organizing your WorkbookName Worksheet tabs and color coding.3:26
   Copy A WorkbookCopy a worksheet within a workbook.2:43
   Copy A Worksheet (New File)Copy a worksheet to a new file or existing open workbook.2:22
   Group WorksheetsWorking with multiple worksheets at the same time.5:25
   View Multiple WorksheetsHow to view multiple worksheets or files on the same screen.2:58
   Printing Mulitple WorksheetsHow to print multiple worksheets2:36
 
Linking & ConsolidatingTime
   Link FormulasCreate a formula across the worksheets.5:07
   Link FilesCreate a formula across excel files.5:14
   Consolidation Part 1Consolidating various excel files into a worksheet.3:48
   Consolidation Park 2 (Labels)Consolidating various excel files into a worksheet using labels.1:54
   HyperlinksCreating hyperlinks with the workbook, open a file and link to a website.4:44
 
Working with Large DoucmentsTime
   Split Screen/Freeze PanesHow to split a workbook screen into two, How to freeze row or columns or both in a worksheet.3:57
   Auto OutlineHow to create an outline to view detail, subtotals and grandtotla.2:57
   Manual OutlineHow to manually create an outline to view detail, subtotals and grandtotals.3:39
 
ListsTime
   Rules for ListsRules for lists, used in sorting, tables and pivottables.2:10
   Flash FillThe flash fill feature, how to extra data from cells .3:47
   Remove DuplicatesHow to removed duplicate records defined by you.2:07
   Basic SortingHow to sort data in a worksheet.3:57
   Additional SortingAdditional sorting, by cell color, by columns, or a custom sort.5:49
   Create SubtotalsHow to create a subtotal on a sorted file.3:34
 
TablesTime
   Format as TableHow to take a list/range and convert to a table for filtering.4:56
   Filter DataHow to filter data in a table4:34
   Add Data to a TableHow to add data to a table.3:04
   Advance FilterWorking with a criteria range and a table.4:37
   Convert To RangeHow to convert a table back to a range/list.1:19
   Database FunctionsHow to use a criteria range to calculate a total for a list of data.3:45
 
ChartsTime
   Create ChartHow to create a pie or column chart.3:26
   Change ValuesHow to change information in cells and update chart data, and change the chart type.1:59
   Format ElementsHow to format parts of a chart. Title, plot area, Legend.2:44
   Format Data SeriesHow to format a data series.4:48
   Add Data ElementsHow to copy data from worksheet and paste into a chart.2:58
   FormatHow to change a chart type for a data series.3:47
   Add GraphicsHow to add a graphic to a chart and create floating text.4:04
   TrendlinesHow to display a trendline for a data series.3:05
   Custom ChartHow to save a chart type and use on future charts.1:57
   Print ChartsHow to print a chart or print the worksheet and chart.1:22
   Bubble ChartsHow to create a bubble chart .2:29
   SparklinesHow to display a trend in a cell.2:59
...
126 Lakedale Drive, Lawrenceville, NJ 08648 USA - 1 609 695 1125
John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz John Conroy, RA in Lawrenceville, NJ on Houzz
© 2012 - 2017 Princeton Design Collaborative