Project Instructions: Excel 2 Instructions U24.pdf (Word version: Excel 2 Instructions U24.docx ) ...

---

Project Instructions: Excel 2 Instructions U24.pdf (Word version: Excel 2 Instructions U24.docx ) Project Data: Ex2-Bicycles U24.docx Check this page to get started, get help on individual techniques & compare your results:Excel Overview & Tips (U24) and be sure be sure you are using the downloaded and installed version of Excel (free) from portal.office.com/home. Don't use the online version for class projects. By submitting this assignment, you confirm that this is all your own, individual work. No help from other individuals, collaborative or group work was involved in completing this assignment. Academic Integrity violations will result in a failing grade and be reported to the Muma College of Business . Submission Instructions: Upload by clicking the 'Submit Assignment'. Be sure you are uploading the file that ends with .xlsx or .xls. To check your upload, look at the submission information on the right side of your screen and 1) download a copy a copy of your project FROM Canvas to another folder on your computer. 2) Open this copy, be sure it’s the right project, etc. and then 3) close / save this copy. This is your back up copy and the creation and last modified dates will be retained as long as it is unopened. Here are some quick video Tips to help refresh your 'Excel Memory.' Excel 1 Project Instructions with embedded video links: coming soon & data: . Excel 2 Project Instructions with embedded video links: coming soon & data: Excel 3 (only offered in the spring and fall semesters) - there is no overview video for this project, as you are using the skills from Excel 1 and 2 to create your own workbook. Some sample worksheets & Individual tip videos are below. Sample worksheets: Excel 3 Samples.pdf Misc Video Tips: Copy, paste, wrapping and sorting video Conditional formatting and the format paintervideo Concatenation / Joining Cells video Named ranges video Merge and center, dates, borders, comments video Shapes video Data Validation video VLOOKUP w/ column function and absolute cell referencing video Basic Calculations video and the INT function Reference Formulas video Sparklines & Quick Analysis for Windows Excel ~ Sparklines for Mac Excel IF function video Chart basics with titles that change video Pivot tables and charts video Note: if you are using a Mac, pivot charts aren't available. Instead create the pivot table and use the table as the input to create a standard chart. Filtering video IFERROR function video Protecting a worksheet video -If you are using Safari and the videos don't work, try using Chrome as your browser. -For Basic Excel instruction - please refer to or Grade Calculator Overview page (Excel Basics video), any number of online tutorials (see our FAQ page) or your prerequisite text book.