Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!
Learning modes and locations may be different depending on the course start date. Please check the location of your chosen course and read our guide to learning modes and locations to help you choose the right course for you.
Start Date:02 Aug 2026
End Date:02 Aug 2026
Sun (Daytime):10:00 - 17:00
Choose either online or in-person
Location: Hybrid (choose either online or in-person)
Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Centre for more information on a range of topics including fees, online learning and FAQs.
This course covers various ways of manipulating Microsoft Excel so that it is easier to work with, and will also cover various aspects of the program to give you knowledge of the different ways you can view, amend and present your data.
What will we cover?
• Features of the program such as basic formatting, subtotalling and conditional formatting. • Basic formulas and how to use them efficiently • Tips on how to quickly sort, fill and view data. • How to protect your spreadsheets • Inserting pivot tables and charts.
What will I achieve? By the end of this course you should be able to...
• Use Excel more efficiently in your work • Distinguish more about Excel's features • Improve your decision making to know which feature to use and when.
What level is the course and do I need any particular skills?
This course is aimed at people who have some familiarity with Excel, perhaps but not necessarily using it regularly, but who would like to gain more knowledge. You should be relatively comfortable working with the basics of spreadsheet software such as entering data.
How will I be taught, and will there be any work outside the class?
There will be demonstrations from the tutor and practical tasks to complete which will help you to understand the material being presented. There will be no work outside of the class.
Are there any other costs? Is there anything I need to bring?
No other costs.You may choose to bring your own laptop if you prefer.
When I've finished, what course can I do next?
City Lit offers a variety of progression courses in this subject area. Please click here to view our Microsoft 365 courses.
Disclaimer: Use of Third-Party Software This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.
Aurica Jalba has been lecturing in Microsoft 365, from beginner to advanced level, for over 12 years at City Lit. She lectures in Business Statistics and Economics at the University of East London and delivers Bloomberg training to undergraduate and MBA students. Aurica developed her passion for teaching during her university studies and believes education should be accessible to all, fostering an inclusive learning environment that supports students inside and outside the classroom. Aurica is known for her patience, dedication and clear teaching style. She has designed several courses at City Lit, delivered bespoke and corporate training, and has been Coordinator for the Business and Technology Department since September 2019. Aurica holds a Diploma in Ecology, a BSc in Economics, and an MSc in Finance and Risk. She is an Associate of the Chartered Banker Institute (CBI) and has completed the Bloomberg Market Concepts (BMC) certification, among others. In 2016, she achieved 3rd place while leading a team in the UK University Trading Challenge. In 2015, she contributed to a research project assessing the feasibility of a £1 million investment in Ghana.
Please note: We reserve the right to change our tutors from those advertised. This happens rarely, but if it does, we are unable to refund fees due to this. Our tutors may have different teaching styles; however we guarantee a consistent quality of teaching in all our courses.
product
https://www.citylit.ac.uk/excel-tricks-and-tips-for-productivity177730Excel: tricks and tips for productivityhttps://www.citylit.ac.uk/media/catalog/product/e/x/excel-tricks-and-tips-for-productivity-cex04.jpg139139GBPInStock/Courses/Courses/Business, marketing & technology/Courses/Business, marketing & technology/Digital & general computer skills/Courses/vm/Courses to boost your CV/Courses/Business, marketing & technology/Digital & general computer skills/Microsoft 365/Courses/vm/Summer offers/Courses/vm/Summer courses/Summer courses in business & technology2285121115991913175913614135751228512111653159913457<p>Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!</p> <div data-content-type="html" data-appearance="default" data-element="main">This course covers various ways of manipulating Microsoft Excel so that it is easier to work with, and will also cover various aspects of the program to give you knowledge of the different ways you can view, amend and present your data.</div>252950730Excel: tricks and tips for productivity139139https://www.citylit.ac.uk/media/catalog/product/e/x/excel-tricks-and-tips-for-productivity-cex04_28.jpgInStockDaytimeSunHybrid (choose either online or in-person)Available coursesOne-off onlyWeekend2026-08-02T00:00:00+00:00Beginners, Some experienceAug 2026Business, marketing & technologyCEX04139139Excel: tricks and tips for productivity11190139Aurica Jalbaexcel-tricks-and-tips-for-productivity/cex04-2526<p>Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!</p>0000-Available|2026-08-02 00:00:00This course covers various ways of manipulating Microsoft Excel so that it is easier to work with, and will also cover various aspects of the program to give you knowledge of the different ways you can view, amend and present your data.<p>Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!</p>• Features of the program such as basic formatting, subtotalling and conditional formatting.<br>• Basic formulas and how to use them efficiently<br>• Tips on how to quickly sort, fill and view data.<br>• How to protect your spreadsheets<br>• Inserting pivot tables and charts.• Use Excel more efficiently in your work<br>• Distinguish more about Excel's features<br>• Improve your decision making to know which feature to use and when.This course is aimed at people who have some familiarity with Excel, perhaps but not necessarily using it regularly, but who would like to gain more knowledge. You should be relatively comfortable working with the basics of spreadsheet software such as entering data.There will be demonstrations from the tutor and practical tasks to complete which will help you to understand the material being presented.<br>There will be no work outside of the class.<p>No other costs.You may choose to bring your own laptop if you prefer.</p><p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_Microsoft_365_Excel_Courses.pdf" target="_blank" rel="noopener noreferrer"> here </a> to view our Microsoft 365 courses.<br><br>Disclaimer: Use of Third-Party Software<br>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Digital & general computer skillsMicrosoft 365virtual3055789Excel: tricks and tips for productivity139139https://www.citylit.ac.uk/media/catalog/product/e/x/excel-tricks-and-tips-for-productivity-cex04_29.jpgInStockDaytimeSunHybrid (choose either online or in-person)Available coursesOne-off onlyWeekend2027-02-07T00:00:00+00:00Beginners, Some experienceFeb 2027Business, marketing & technologyCEX42139139Excel: tricks and tips for productivity11190139Aurica Jalbaexcel-tricks-and-tips-for-productivity/cex42-2627<p>Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!</p>0000-Available|2027-02-07 00:00:00This course covers various ways of manipulating Microsoft Excel so that it is easier to work with, and will also cover various aspects of the program to give you knowledge of the different ways you can view, amend and present your data.<p>Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!</p>• Features of the program such as basic formatting, subtotalling and conditional formatting.<br>• Basic formulas and how to use them efficiently<br>• Tips on how to quickly sort, fill and view data.<br>• How to protect your spreadsheets<br>• Inserting pivot tables and charts.• Use Excel more efficiently in your work<br>• Distinguish more about Excel's features<br>• Improve your decision making to know which feature to use and when.This course is aimed at people who have some familiarity with Excel, perhaps but not necessarily using it regularly, but who would like to gain more knowledge. You should be relatively comfortable working with the basics of spreadsheet software such as entering data.There will be demonstrations from the tutor and practical tasks to complete which will help you to understand the material being presented.<br>There will be no work outside of the class.<p>No other costs.You may choose to bring your own laptop if you prefer.</p><p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_Microsoft_365_Excel_Courses.pdf" target="_blank" rel="noopener noreferrer"> here </a> to view our Microsoft 365 courses.<br><br>Disclaimer: Use of Third-Party Software<br>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Digital & general computer skillsMicrosoft 365virtual11113990CEX04,CEX42NONESun02/08/2610:00 - 17:0010:0017:001 session1One-off onlyWeekendHybridHybrid (choose either online or in-person)Aurica JalbaBeginners, Some experienceAvailable courses2026-08-02T00:00:00+00:00,2027-02-07T00:00:00+00:00DaytimeAug 2026,Feb 2027Business, marketing & technology139139Excel: tricks and tips for productivityexcel-tricks-and-tips-for-productivity/cex04-2526,excel-tricks-and-tips-for-productivity/cex42-2627<p>Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!</p>0000-Available|2026-08-02 00:00:00This course covers various ways of manipulating Microsoft Excel so that it is easier to work with, and will also cover various aspects of the program to give you knowledge of the different ways you can view, amend and present your data.<p>Already familiar with Excel? Learn smart shortcuts, settings tweaks, and hidden features to make your work faster and more efficient in this practical one-day course. Enrol now and streamline your workflow!</p>• Features of the program such as basic formatting, subtotalling and conditional formatting.<br>• Basic formulas and how to use them efficiently<br>• Tips on how to quickly sort, fill and view data.<br>• How to protect your spreadsheets<br>• Inserting pivot tables and charts.• Use Excel more efficiently in your work<br>• Distinguish more about Excel's features<br>• Improve your decision making to know which feature to use and when.This course is aimed at people who have some familiarity with Excel, perhaps but not necessarily using it regularly, but who would like to gain more knowledge. You should be relatively comfortable working with the basics of spreadsheet software such as entering data.There will be demonstrations from the tutor and practical tasks to complete which will help you to understand the material being presented.<br>There will be no work outside of the class.<p>No other costs.You may choose to bring your own laptop if you prefer.</p><p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_Microsoft_365_Excel_Courses.pdf" target="_blank" rel="noopener noreferrer"> here </a> to view our Microsoft 365 courses.<br><br>Disclaimer: Use of Third-Party Software<br>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Digital & general computer skillsMicrosoft 365configurable
17591599Microsoft 365https://www.citylit.ac.uk/courses/technology-science-and-business/digital-and-computer-skills/excel-and-office-3651/2/285/1211/1599/17591/Courses/Business, marketing & technology/Digital & general computer skills/Microsoft 365
