{"id":437,"date":"2019-01-27T14:24:32","date_gmt":"2019-01-27T14:24:32","guid":{"rendered":"http:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/?page_id=437"},"modified":"2021-04-03T10:58:14","modified_gmt":"2021-04-03T10:58:14","slug":"further-excel","status":"publish","type":"page","link":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/microsoft-office-courses\/further-excel\/","title":{"rendered":"Microsoft Excel (Further)"},"content":{"rendered":"<h1>Further Excel<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1415\" 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\" \/><\/p>\n<p>You will increase your confidence in using Microsoft Excel so that you can produce a wide range of spreadsheets, whether for personal or business purposes.<\/p>\n<h2>Course Objectives<\/h2>\n<p>The purpose of this course is to revise and reinforce the knowledge and experience you already have, and to introduce you to additional features of Microsoft Excel. \u00a0By the end of the course you should be able to produce and edit attractive, professional spreadsheets suitable for most occasions and uses.<\/p>\n<ul>\n<li><strong>We will revise:<\/strong>\n<ul>\n<li>Basic formulae<\/li>\n<li>When to use the $ sign in formulae<\/li>\n<li>When to use brackets in formulae<\/li>\n<li>Formatting<\/li>\n<\/ul>\n<\/li>\n<li><strong>You will learn about:<\/strong>\n<ul>\n<li>Sorting data<\/li>\n<li>Using more than one worksheet within a spreadsheet<\/li>\n<li>Validating data<\/li>\n<li>Making one cell conditional on another cell<\/li>\n<li>Conditional formatting<\/li>\n<li>Handling and avoiding errors<\/li>\n<li>Filtering data<\/li>\n<li>Naming cells<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>You will also sample the wide range of uses that spreadsheets can be used to tackle.<\/p>\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>Five weeks x2 hours<\/p>\n<ul>\n<li><strong>Lesson 1: Time and using the $ sign and brackets in formulae<\/strong>\n<ul>\n<li>Time format<\/li>\n<li>Custom format<\/li>\n<li>Rows, columns and Autofit<\/li>\n<li>The $ sign and brackets in formulae<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 2: Sorting and using more than one worksheet<\/strong>\n<ul>\n<li>Sorting<\/li>\n<li>Test direction<\/li>\n<li>Using a new worksheet<\/li>\n<li>Copying a worksheet<\/li>\n<li>Renaming a worksheet<\/li>\n<li>Formulae using data from more than one worksheet<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 3: Data validation and Conditionality<\/strong>\n<ul>\n<li>Controlling what can be entered in a cell<\/li>\n<li>One cell conditional on another<\/li>\n<li>Conditional formatting<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 4: Handling and avoiding mistakes<\/strong>\n<ul>\n<li>Error messages<\/li>\n<li>Tracing precedent cells and dependent cells<\/li>\n<li>Locking cells<\/li>\n<li>Counting rows and columns<\/li>\n<\/ul>\n<\/li>\n<li><strong>Lesson 5: Naming cells and Filtering<\/strong>\n<ul>\n<li>Freeze panes<\/li>\n<li>Filtering text and numbers<\/li>\n<li>Naming cells<\/li>\n<li>Managing named cells<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Course Timetable<\/h2>\nThere are no currently planned dates for this course.\n<h2>Prerequisites<\/h2>\n<p>You should have attended the <a href=\"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/microsoft-office-courses\/microsoft-excel\/\">Excel course<\/a> or have a basic working knowledge of Microsoft Excel (i.e. the topics covered in the <a href=\"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/microsoft-office-courses\/microsoft-excel\/\">Excel course<\/a>).<\/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>Further Excel You will increase your confidence in using Microsoft Excel so that you can <a class=\"more-link\" href=\"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/find-the-right-course\/microsoft-office-courses\/further-excel\/\">More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1894,"menu_order":2,"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-437","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\/437","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=437"}],"version-history":[{"count":10,"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/pages\/437\/revisions"}],"predecessor-version":[{"id":2313,"href":"https:\/\/www.computerfriendlystalbans.org.uk\/computer-friendly\/wp-json\/wp\/v2\/pages\/437\/revisions\/2313"}],"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=437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}