Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.
Working with the Excel interface
Creating formulas and functions
Formatting rows, columns, cells, and data
Working with alignment and text wrap
Adjusting rows and columns
Finding and replacing data
Printing and sharing worksheets
Creating charts and PivotTables
Inserting and deleting sheets
Using power functions such as IF and VLOOKUP
Password-protecting worksheets and workbooks
Analyzing data with Goal Seek and Solver
Creating and running macros
Microsoft Office Specialist
The Microsoft Office Specialist (MOS) Qualification demonstrates that you have specialist skills in using Microsoft applications.
As a member of Lancaster University current staff and students have the opportunity to self-study one or more MOS qualifications. Microsoft estimate each qualification is around 40 learning hours and each are a qualification in their own right.
Microsoft publish a range of resources on their Office help and training page. They provide various quick-start guides for the main Office applications, as well as a searchable knowledge base of guides.
Ask a Digital Advisor
Struggling with something digital? Need some IT help? Digital Advisors are available to help you with individual queries. For staff, we are happy to come to your office, and for students we can meet you at the Learning Zone or other public location. Book an appointment now
Try searching Lancaster Answers - our online information base which includes step by step instructions and videos on various topics.
ISS Help and Support
If you have exhausted the above options, please contact the ISS Service Desk for additional help & support.