Blended Learning is all about combining face to face teaching with online learning experiences in a way that complements each other. We have various tools to enable this, such as Moodle, Panopto, Teams etc. However it can be difficult if...
Search results
Access to the Business School Webserver is provided by a username and password sent to you in an email. If you don't have an email with these details, and you feel you should have access, then please log a support call at https://supportme.chi.ac.uk or speak with your lecturer.
In your...
Displaying hidden formattingWord has many formatting symbols which are not immediately obvious and are hidden from view by default.
The following formatting options have no visibility unless the ¶ button is selected:Section breaks, Page breaks, Soft and Hard carriage...
The following formatting options have no visibility unless the ¶ button is selected:
Charts and Graphs...
Create a chart
Select the data for which you want to create a chart.
Adding Chart Elements
When creating charts/graphs in Excel you may find that some labels are not added by default and must be added manually or are in an unsuitable place. Excel also allows for modification of these labels, as well as their placement. In this example i'm going to amend a pie...
Vlookup & HLookup
Excel can use a function to lookup and retrieve data from a specific column or row within a table. Vlookup works to return back a column of data and Hlookup works to return a row of data instead, therefore the V stands for vertical lookup and the H, Horizontal lookup.
...There are multiple ways of highlighting or removing duplicates from an Excel worksheet.
Conditional FormattingConditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....
Pivot TablesIntroduction to pivot tables
Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format. What we mean by this is that you should log each transaction individually and not...
Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns:
Text to Columns'Text to columns' is found in the 'data'...
Flash fill and the fill handle
The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area.
The fill handle is the name given to the green dot found on the bottom right corner of the selected...