Links Launch Outlook Place Skype on Do Not

Links • Launch Outlook • Place Skype on Do Not Disturb

TECHNOLOGY INSTRUCTION Excel 2013 Essentials Please log in to your workstation with your KU Online ID and password.

EXCEL 2013 - ESSENTIALS COURSE INSTRUCTOR Tennille Fincham Microsoft Certified Trainer Technology Instructor & Learning Enthusiast Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

COURSE OVERVIEW EXCEL 2013 - ESSENTIALS Overview: Introduction | Tour | Terminology | Navigation | Selection Activity 1: Open Excel Workbook Resize Rows/Columns Insert Rows/Columns Fill Cells Copy & Paste Data Format Worksheet Format Page Activity 3: Flash-fill Min, Max, Average Relative and Absolute References Conditional Formatting If/Then Statements Macros Activity 2: Create a Table Format a Table Insert a Total Column Create Formulas Filter and Sort Activity 4: Charts Formatting Charts Sparkline Pictures Smart. Art Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

EXCEL 2013 - ESSENTIALS COURSE OBJECTIVES Manage and create workbooks and worksheets. Navigate through the Excel environment to find specific data or formulas. Format worksheets and workbooks using themes, page setup, headers and footers, and images. Manipulate views of the workbooks/sheets. Understand how to use Auto-fill and Flash-Fill. Format cells and ranges. Create and manage tables, formulas, and functions. Use conditional logic to format cells. Create and format Charts. Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

WHAT IS EXCEL? EXCEL 2013 - ESSENTIALS Microsoft Excel is a spreadsheet program that allows you to calculate and graph data sets. Excel can be used to create a number of items including: • Work Orders • Budgets • To-do lists • Timesheets • Financial/Account Reports • Sales Reports Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

EXCEL 2013 - ESSENTIALS OPENING EXCEL Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

EXCEL 2013 - ESSENTIALS TERMINOLOGY • Workbook – comprised of one or many worksheets containing data • Worksheet – contains a series of rows/columns containing data, charts, tables, etc. • Column – comprised of vertical cells • Row – comprised of cells running horizontally • Cell – individual space that contains formatted data, formulas, functions, etc. • Cell address – the location of particular cells within a Workbook/Worksheet. A cell’s address may be relative or absolute. Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

EXCEL 2013 - ESSENTIALS WHAT WE LEARNED Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

EXCEL 2013 - ESSENTIALS ? WRAP UP/QUESTIONS Instructor follow-up Once the session recording has been processed any outstanding questions have been addressed, the instructor will send an email to all users that have RSVP'd to the Quick Learn session. The email will include: • A link to the recording • Additional learning resources • Answers to outstanding questions Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.

ADDITIONAL TRAINING EXCEL 2013 - ESSENTIALS IT training opportunities There a number of training resources that the Technology Instruction department provides: • Departmental training • Interested in having us over to speak to your department about this topic or another technology? – Visit technology. ku. edu/request-instruction request a training session for your department or email training@ku. edu to speak to one of our instructors. • Open workshops and Quick Learn webinar series • Search and sign up for sessions at workshops. ku. edu. • Desk-side coaching • Want some one-on-one time? – Fill out our desk-side coaching request at technology. ku. edu/request-instruction to meet with an instructor individually. Technology Instruction email: training@ku. edu phone: 785 -864 -5155 Empower. Connect. Discover. Teach.