You work for a company that does educational consulting.Your boss knows that you are a genius when it comes to Excel and decides to impose upon you a little – he assigns you a project to create an Excel spreadsheet that will be a teacher’s companion.It has to have an input area for the grades, rank them, split them into different quartiles, create relevant charts, give all the summary statistics that are relevant, color code grades that need to be looked into, have a conditional format highlighting when a student does better or worse than previous exams, show relevant lookup values for grades according to number and letter, have relevant pivot tables, etc.The goal is that it is a stand-alone tool for teachers to use to assess everything possible about a student. You work for a finance firm and are asked to firstly prepare a report detailing whether or not your company should invest in one of the following companies of your choice: CREE, TSLA, PCLN, AMZN, NFLX, KO, PG, CIT, AIG, or something else (with a market cap of over 10B).You must prepare a report that details all the financial information (using Excel functions) and presents it in a clear and concise manner.Secondly, you were asked to come up with a system to invest in this stock. You must create something based on past history, test it, and show that your system is a relevant and important approach. L, FILTER, and DISTINCTROWS (at least). You should be using the measures in your pivot table (at the least). Extra credit: A copy of your Power BI dashboard as a picture. You should have two (2) different pages (dashboards) from Power BI. Your Power BI dashboard should include at least 2 custom visuals as per: https://www.youtube.com/watch?v=8S4YblyU22k&list=PLAQtmrhlOUzHhx_6Kbrz-bPkyGIAgb2lg include relative absolute and mixed cell reference use all the summary statistics (sum, average, min, max, count, etc.) use at least two different instances of date and time functions use at least three different formats such as number, date, custom etc. use at least three different instances of nested if functions use vlookup and index/match functions create and use range names and use them in formulas have at least 7 charts with axis names, chart title, etc. describing the data use data bars use at least three instances of conditional formatting, one of which needs to be custom formatted design at least 2 tables design at least 4 pivot tables freeze panes text boxes to explain name your sheets and give them colors sort the table at two levels or more use the subtotal function have grouped data have at least four relevant pivot tables with at least two calculated fields (measures) and a calculated item have a slicer available for the pivot table create a one variable data table create a two variable data table use solver (with saved and summarized scenarios) use advanced filters use the database functions use the sumif(s), countif(s), averageif(s) functions use rank, percentrank, quartile, frequency, stdev, and correl functions create a histrogram at least four different formulas using arrays at least two cases of data validation use dynamic charts connected to lists use some VBA (even just something simple) use at least 4 different types of buttons (non-VBA) use a doughnut chart and other effective visualizations from Udemy section: Data and Visualizations Overview use the Advanced Review section from Udemy for ideas
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
