To summarize what you learn: 1. How to use Excel Dynamic Array referencing in charts 2. How to use Excel FILTER & SORTBY functions 3. How to Sort categories based on their values Step 1: Data Preparation Table Whenever the chart has a different setup than the source data, a data preparation table is needed in between. We will use the new Excel FILTER function for that. In order to get the chart properly sorted we will apply the new Excel SORTBY function. This function is used when the sorting criteria is not in the result. The tricky part is to ensure that the array for the sorting (by_array1) has the same size and order as the array for the visible sales data. We will solve this by nesting another FILTER function in the formula. To get the respective sales data we’ll use a simple VLOOKUP. Step 2: Excel Chart For the visualization we’ll use a column chart that’s connected to the data preparation table. However, we want the Excel chart area to update automatically based on the number of data points in the data preparation table. In other words, we want the chart to be dynamic and to include any new selections from the data preparation table and exclude any blank areas. Excel Chart references can either take direct references or they can take names. Therefore, to keep the chart dynamic we’ll use names in the Name Manager and we’ll use the “#” for the reference to spill. Then we’ll update the Series Values and the Axis Labels of the chart with the names we created. Step 3: Dynamic Dashboard This technique can easily be used to create dynamic dashboards. Based on a dropdown selection the chart is automatically updated. I used the Excel IF and SUMPRODUCT functions to help with that. In order to make sure that new data is added to the chart I converted the data into an official Excel table. Course Length: 12:32 minutes Source: Leila Gharani
Most frequent questions and answers
Co-operative education is a three-way partnership between the university, students and employers. Students apply their classroom knowledge in a series of four-month work experiences. You, the employer, enhance a student’s education, while reaping the unique benefits of CO-OP employees.
- Year-round access to well-motivated, qualified employees.
- Access to potential full-time staff in a controlled environment, reducing your costs and risks.
- Access to a cost-effective source of temporary employees for peak periods or special projects.
- A say in what students learn by working with the university.
- Promotion of your organization as one that believes in developing the potential of young people.
- Access to a great pool of French-speaking, English-speaking and bilingual students.
Most work terms run at least 15 weeks, or four months. They can be no shorter than 13 weeks. Some master’s students, as well as some science and engineering students, are available for 8 or 12 months’ work terms.
All jobs are reviewed by a CO-OP Program Coordinator, and only those providing students with work experience related to their professional development are approved. Administrative activities involved in a job should be less than 10% of the entire workload.
When you first contact SSC, you are assigned one of our Program Coordinators, depending on your discipline of interest. This person is your main contact in our office. As you move through the recruitment process, you also work with a representative from CO-OP Administrative Services, who assists with job posting and interview scheduling.