Project 1 – Create a basic business budget with income and expenses.
Project 2 – Add a chart as directed that shows net income
Project 3 – Use and Apply Conditional Formatting and Absolute Values
Copy and paste the link into your browser to download a PDF with specific directions and pictures. Please note that this attachment will also be used for all three projects and you will only submit one Excel File. It should be named Your Name_Final Excel Project.
https://drive.google.com/file/d/1ekRfSBdfqE7UbiKgMLeyo8KZltRWvO4e/view?usp=sharing
Review the three scholarly sources listed below.
Write an essay which answers the following question. Why is it important for college graduates to learn and use Excel? (150-250 Words)
Microsoft Excel: Is I An Important Job Skill for College Graduates? (May, 2017) Authors: Formby, Medlin, & Ellington
Hands-On Learning: A Problem-Based Approach to Teaching Microsoft Excel (2018)
Authors: Erik Slayter and Lindsey M. Higgins
Excel: Collaboration in an Excel Workbook (November 2019) Author: Bill Jelen
Incorporate two of these scholarly sources into this essay. Ensure all information provided is relevant to the question.
Copy and paste the link into your browser to download a PDF with specific directions and pictures.
https://drive.google.com/file/d/1f8B5vXlmUfPhuRO4gC7D_R2Lg9OUtcec/view
Copy and paste the link into your browser to access the articles
https://drive.google.com/drive/folders/1S82B9oidPaP4yIVDOk76_sS58I9QxYDi?usp=sharing
Name as directed, save to the Week Three folder in One Drive, submit to the drop box.
• Create a basic business budget in Excel / Save in One Drive
• Add a chart to the same page as the data / Save in One Drive
• Format and add functions and formulas as directed.
• Insert conditional formatting on basic information
• Demonstrate the effective use of absolute cell formatting.
• Review and analyze partial excerpts from the scholarly sources on the importance of learning how to use Excel.
• Write an essay (between 150 and 250 words) Must use introduction, body, conclusion format.
• Cite the two scholarly sources that were integrated into the above essay (APA 7 format) ***All sources used should have been written within the past seven years.***
• Follow specific assignment directions to create Projects one, two, three, and four. Projects 1-3 – Excel document Project 4- Word document.