Our IT Practical workshops flip traditional training on its head by presenting learners with a problem to be solved and encouraging them to use their prior experience, web searches, in-application Help programs, and their fellow students or colleagues to find the solutions.
By the end of the session, students will:
-
leave with improved problem-solving skills
-
an increased knowledge of the topic and a ‘suggested solution’ to the real-world problem they worked on
-
work on materials for either Office 2013 or Office 2016 for Mac.
To find out more and to book a workshop, see our range of session topics below:
Pre-requisite(s): None
This workshop is ideal for those who are self-taught or new to Excel as it incorporates good practice principles. It is also useful for anyone who needs to be able to design and create a budget. By the end of this session you will understand how to:
-
Create and copy formulas
-
Format numbers and text
-
Set a print range for large spreadsheet
Book a workshop
This workshop is a pre-requisite for
-
Excel: Numeric Calculations
Pre-requisite: Calculated Worksheets
This workshop builds upon the skills taught in the Calculated Worksheets workshop and covers skills that are fundamental to the accurate use of Excel in all contexts and industries.By the end of this session you will understand how to:
-
write accurate and efficient formulas
-
calculate totals and percentages
-
complete large tables of calculated data
Book a workshop
This workshop is a pre-requisite for
-
Excel: Essential Functions
-
Excel: Pivot Tables
Pre-requisite: Numeric Calculations
This workshop is ideal for anyone who needs to use Excel functions to do a number of calculations, such as quickly adding up columns of numbers and calculating averages.
The session also contains additional formatting, calculation and troubleshooting techniques. By the end of this session you will understand how to:
-
find the maximum and minimum value in a range
-
perform basic logical tests
-
understand how to fix errors
-
use automatic formatting
Book a workshop
This workshop is a pre-requisite for:
-
Excel: Lookup Functions
-
Excel: Sorting and Filtering
Pre-requisite: A basic understanding of how to create and format a simple chart
This workshop is ideal for anyone who needs to present data in chart form and assumes a basic understanding of how to create and format a simple chart. By the end of this session you will understand how to:
-
use Excel to create a number of different charts
-
use charts to compare different sets of data and predicting trends
-
represent percentages in chart form
-
display stock figures or confidence intervals
Book a workshop
Pre-requisite: Essential Functions
This workshop is ideal for anyone who needs to quickly organise large amounts of data. By the end of this session you will understand how to:
-
perform complex sorts
-
apply filters to retrieve a subset of information
-
use date functions
-
perform a basic summary calculation of information
-
set up worksheets for the repeated application of complex filters
Book a workshop
Pre-requisite: Numeric Calculations
This workshop is ideal for anyone who needs to quickly summarise large amounts of data and present it in an easily understandable format. By the end of this session you will understand how to:
-
summarise large amounts of data using Pivot Tables
-
present the information in a number of ways using formatting, charting, and calculation options
Book a workshop
Pre-requisite: Essential Functions
This workshop is ideal for anyone who uses Excel as a tool for interrogating data tables or performing advanced calculations based on logical queries, particularly in numeric disciplines. By the end of this session you will understand how to:
-
use Excel logic and lookup functions to display text, perform calculations, or retrieve information
-
query information held elsewhere in the spreadsheet
Book a workshop
This workshop is a pre-requisite for:
-
Excel: Complex Calculations
Pre-requisite: Lookup Functions
This advanced application of Excel to complete complex tables of information accurately and efficiently provides a solid basis for expanding your use of Excel's many advanced and specialist functions and is valued in any industry that uses Excel.
By the end of this session you will understand how to:
-
use logical and lookup functions
-
create nested formulas
-
avoid circular references
Book a workshop
Pre-requisite: None
This workshop is ideal for anyone writing long academic papers or business reports. By the end of this session you will understand how to:
-
create consistent formatting through your document
-
create Table of Contents and Table of Figures
-
add page numbers
-
add captions to images or tables of information
Book a workshop
Pre-requisite: None
This workshop is ideal for anyone writing long academic papers or business reports containing multiple chapters. By the end of this session you will understand how to:
-
discover and fix formatting inconsistencies
-
troubleshoot footnotes
-
change the page orientation of a section of your document
-
easily compare two versions of a document
Book a workshop
Note: You may also find helpful the Formatting an Academic Paper guide available from our Self-Study section.
Please note: IT Practical workshops run during Michaelmas and Lent terms only.
The workshops are all held in ALD.3.02F (The Amber Miro Room). Please allow 10 minutes travel time if you are walking from the NAB or Library, and 5 minutes from Old Building or SAW.
When attending a session please ensure you have your LSE ID card as you will need it to gain access to Aldwych House.
If you have any additional mobility requirements, please contact us before attending. Alternatively, upon arrival, please speak to a member of the reception team. This will allow us to put in place appropriate arrangements in the event of a fire alarm or building evacuation.
Please indicate any accessibility requirements when prompted during the booking process. All training computers will have tools to assist neurodiverse students, and our training materials have been formatted for readability.
If you have come to a session and are working from your device, click here.