Excel Training Course
Instructor:  David Kirk | Dallas College Eastfield Campus

 Topic Terms Projects / Files 8 - Data Types Excel Training Video stocks geography movies 9 - Format Cells (Number) number, currency, date, time, percentage, fraction, custom Project 2: Donut Orders Data File: donut_orders.xlsx 10 - Basic Charts column, bar, line, pie, area, scatter, bubble Project 3: Coffee Shop Gigs 11 - Basic Functions math and order of operations SUM, AVERAGE, MIN, MAX, COUNT, COUNTA cell reference between sheets autofill Project 4: Megabites Restaurant Data File: megabites.xlsx Project 5: Converter

 Topic Terms Projects / Files 12 - Copy & Paste relative versus absolute formulas transpose paste special Project 6: toolsales.jpg Data File: toolsales.xlsx 13 - Filters allows you to sort and filter a table UNIQUE function SORT function Data File: coffee.xlsx 14 - Named Ranges assign a name to a range of cells Name Manager under Formulas menu 15 - Additional Functions Excel Training Video COUNTIF - count cell based on a criteria SUMIF - sum cells based on a criteria IF - return a value based on a condition AND, OR VLOOKUP - find things in a table by first row Project 7: Coffee Sales

 Topic Terms Projects / Files 16 - Data Validation help control the type of data entered show a message when you click in a cell 17 - Sorting change the order of your data Project 8: Lotto Home  Drawings  Frequency 18 - Additional Functions RAND, RANDBETWEEN, RANDARRAY DATE, NOW, TODAY Project 9: Roulette Wheel 19 - Pivot Tables a tool to summarize and analyze data Project 10: pivot.xlsx 20 - Evaluation Click Here For Evaluation