Introduction to Microsoft Excel

Course Syllabus: Getting Started - Spreadsheet terminology - Exploring the Excel window - Getting help - Opening and navigating workbooks - Closing workbooks Entering and Editing data - Creating workbooks - Entering and editing labels and values - Entering and editing formulas - Saving and updating workbooks Modifying a Worksheet - Moving and copying data - Moving and copying formulas - Using absolute references - Inserting and deleting ranges Using Functions - Entering functions - Using AutoSum - Using AVERAGE, MIN and MAX Formatting Worksheets - Formatting text - Formatting rows and columns - Number formatting - Using Format Painter and AutoFormat Printing - Preparing to print - Page Setup options - Printing Worksheets Creating Charts - Chart basics - Modifying charts - Printing charts All one-day IT courses are bespoke and not qualification-based. Training formats available: - 1 day instructor-led at the College - On-site at your company office UK wide - Bespoke one-to-one basis - Tailored training courses to your requirement At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel, and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Spreadsheets that you create will be easier to use and look more presentable.Training formats available - 1 day instructor-led at the College - On-site at your company office UK wide - Bespoke one-to-one basis - Tailored training courses to your requirement