{"id":436,"date":"2019-01-27T14:24:16","date_gmt":"2019-01-27T14:24:16","guid":{"rendered":"http:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/?page_id=436"},"modified":"2025-04-26T06:47:05","modified_gmt":"2025-04-26T06:47:05","slug":"microsoft-excel","status":"publish","type":"page","link":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/microsoft-office-courses\/microsoft-excel\/","title":{"rendered":"Microsoft Excel"},"content":{"rendered":"<h1>Microsoft Excel<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1415 size-full\" src=\"http:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-content\/uploads\/2020\/09\/69px-Microsoft_Office_Excel_2018\u2013present.svg.png\" alt=\"\" width=\"69\" height=\"64\" \/><br \/>\nYou will learn how to create and amend Excel spreadsheets to store and manipulate data which can be used for both personal and business purposes.<\/p>\n<h2 style=\"clear: both;\">Course Objectives<\/h2>\n<p>The purpose of this course is to introduce you to the most important features of Microsoft Excel, to reinforce what you already know about how to use a computer and to build your confidence. \u00a0By the end of the course you should be able to produce and edit spread-<wbr \/>sheets for home and office use.<\/p>\n<ul>\n<li><strong>On this course you will learn:<\/strong>\n<ul>\n<li>How to build spreadsheets &#8211; about the most frequently used features in Excel<\/li>\n<li>Cells &#8211; Simple formulae<\/li>\n<li>Addition, subtraction, multiply and divide &#8211; Drag and repeat<\/li>\n<li>Copying formula &#8211; Dates<\/li>\n<li>Monetary calculations &#8211; Formatting to improve the appearance of a spreadsheet<\/li>\n<li>Templates &#8211; Charts and graphs<\/li>\n<li>Saving files, opening existing files, printing<\/li>\n<li>You will also learn about the wide range of uses that spreadsheets can be used for.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>A workbook is provided containing exercises to give hands-<wbr \/>on experience and general information. This is yours to keep.<\/p>\n<h2>Course Structure<\/h2>\n<p>Six weeks x2 hours<\/p>\n<ul>\n<li><strong>Lesson 1: Introduction to Excel<\/strong>\n<ul>\n<li>Moving around in Excel<\/li>\n<li>Entering and changing data<\/li>\n<li>Addition, subtraction, multiplication and division<\/li>\n<li>Files \u2013 saving file, sheets<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 2: Short cuts, styles and formatting<\/strong>\n<ul>\n<li>Addition using Autosum<\/li>\n<li>Copying a formula<\/li>\n<li>Undo and redo<\/li>\n<li>Styles<\/li>\n<li>Bold, italics and Underline<\/li>\n<li>Printing<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 3: Formatting numbers and using templates<\/strong>\n<ul>\n<li>Number formats<\/li>\n<li>Numerical sequencing<\/li>\n<li>Wrapping text<\/li>\n<li>Deleting and clearing<\/li>\n<li>Range of templates<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 4: More about formulae and the look of the spreadsheet<\/strong>\n<ul>\n<li>Using the $ sign when copying a formula<\/li>\n<li>Using brackets in a formula<\/li>\n<li>Aligning and merging cells<\/li>\n<li>Fonts and colouring<\/li>\n<li>Borders<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 5: Dates and Percentages<\/strong>\n<ul>\n<li>Dates<\/li>\n<li>Converting to percentages<\/li>\n<li>Inserting and deleting rows and columns<\/li>\n<li>Lines<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 6: Charts<\/strong>\n<ul>\n<li>Creating a chart (graph)<\/li>\n<li>Moving charts<\/li>\n<li>Adding information to charts<\/li>\n<li>Revision<\/li>\n<p>You should have attended the Starting off with windows course or Getting more with windows course, or have a basic knowledge of computers, including the mouse and keyboard.<\/p>\n<h2>When and Where?<\/h2>If you are unsure of the suitability of one of our courses or simply wish to find out more you can visit one of our <a href='https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/venues\/#drop_in_centers'>drop in centres<\/a> to discuss a course or visit our <a href='http:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/timetables\/''>courses timetable page<\/a> or our <a href='http:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/course-planner\/'> course planner page<\/a> to see where and when the courses are being held.<br>Completing a <a href='https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/starter-courses\/'>Starting Off With<\/a> course in 2025 means you can do a <a href='https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/further-courses\/'>Getting More From<\/a> course for only \u00a310.<br><br><a class=\"maxbutton-1 maxbutton maxbutton-book-course cfbooking\" href=\"http:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/contact\/#booking\"><span class='mb-text'>Book a course now<\/span><\/a>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel You will learn how to create and amend Excel spreadsheets to store and <a class=\"more-link\" href=\"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/microsoft-office-courses\/microsoft-excel\/\">More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1894,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"give_campaign_id":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-436","page","type-page","status-publish","hentry"],"campaignId":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/pages\/436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/comments?post=436"}],"version-history":[{"count":10,"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/pages\/436\/revisions"}],"predecessor-version":[{"id":5135,"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/pages\/436\/revisions\/5135"}],"up":[{"embeddable":true,"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/pages\/1894"}],"wp:attachment":[{"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/media?parent=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}