{"product_id":"excel-2013-advanced","title":"Excel 2013 Advanced","description":"\u003cdiv class=\"ebsi-team-licence-note\"\u003e\u003cp\u003e\u003cstrong\u003eBuying for a team?\u003c\/strong\u003e\u003cbr\u003eChoose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.\u003c\/p\u003e\u003c\/div\u003e\n\u003c!-- ebsi-sales-wrapper --\u003e\u003cdiv class=\"ebsi-sales-wrapper\"\u003e\n\u003cp\u003e\u003cstrong\u003eDevelop practical knowledge and confidence in Excel 2013 Advanced.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eParticipants will learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. Participants will be shown a practical way of learning with a hands-on approach. They will get a chance to experience some of the features that are offered in Excel 2013.\u003c\/p\u003e\n\u003ch3\u003eWhy this course matters\u003c\/h3\u003e\n\u003cp\u003eThis course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.\u003c\/p\u003e\n\u003ch3\u003eWhat you will gain\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eUse the key features and workflows covered in Excel 2013 Advanced with greater confidence.\u003c\/li\u003e\n\u003cli\u003eApply the tools and techniques to practical business tasks.\u003c\/li\u003e\n\u003cli\u003eRecognise common mistakes and work more efficiently in day-to-day use.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWho is this course for?\u003c\/h3\u003e\n\u003cp\u003eThis course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.\u003c\/p\u003e\n\u003ch3\u003eCourse at a glance\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFormat:\u003c\/strong\u003e self-paced online learning.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProfessional development:\u003c\/strong\u003e CPD course.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cp class=\"ng-scope\"\u003eParticipants will learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. Participants will be shown a practical way of learning with a hands-on approach. They will get a chance to experience some of the features that are offered in Excel 2013.\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003eExcel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision making!\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cmeta charset=\"utf-8\"\u003e\u003cspan\u003eCompleting this course will confer 2 CPD Credits towards internationally recognised \u003c\/span\u003e\u003cstrong\u003eContinuous Professional Development\u003c\/strong\u003e\u003cspan\u003e Requirements within organisations operating this kind of staff development methodology.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e \u003c\/p\u003e\n\u003ch5 class=\"ng-scope\"\u003e\u003cspan style=\"text-decoration: underline;\"\u003e\u003cstrong\u003eCourse Outline\u003c\/strong\u003e\u003c\/span\u003e\u003c\/h5\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule One: Getting Started\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Two: SmartArt and Objects\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eInserting SmartArt\u003c\/li\u003e\n\u003cli\u003eEditing the Diagram\u003c\/li\u003e\n\u003cli\u003eAdding Pictures\u003c\/li\u003e\n\u003cli\u003eAdding Text Boxes\u003c\/li\u003e\n\u003cli\u003eDrawing Shapes\u003c\/li\u003e\n\u003cli\u003eAbout the Contextual Tabs\u003c\/li\u003e\n\u003cli\u003eModule Two: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Three: Auditing\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eTracing Precedent cells\u003c\/li\u003e\n\u003cli\u003eTracing the Dependents of a Cell\u003c\/li\u003e\n\u003cli\u003eDisplaying Formulas Within the Sheet\u003c\/li\u003e\n\u003cli\u003eAdding, Displaying, Editing ,and Removing Comments\u003c\/li\u003e\n\u003cli\u003eModule Three: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Four: Creating Charts\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eUsing Recommended Charts\u003c\/li\u003e\n\u003cli\u003eInserting a Chart\u003c\/li\u003e\n\u003cli\u003eOverview of the Chart Tools Tabs\u003c\/li\u003e\n\u003cli\u003eUnderstanding the Parts of a Chart\u003c\/li\u003e\n\u003cli\u003eResizing and Moving the Chart\u003c\/li\u003e\n\u003cli\u003eModule Four: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Five: Working with Charts\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eUsing Chart Elements\u003c\/li\u003e\n\u003cli\u003eUsing Chart Styles and Colors\u003c\/li\u003e\n\u003cli\u003eChanging the Chart Style\u003c\/li\u003e\n\u003cli\u003eUsing Chart Filters\u003c\/li\u003e\n\u003cli\u003eWorking with Data Labels\u003c\/li\u003e\n\u003cli\u003eModule Five: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Six: Creating Pivot Tables and Pivot Charts\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eInserting a PivotTable using Excel Recommendations\u003c\/li\u003e\n\u003cli\u003eChoosing Fields and Grouping Data\u003c\/li\u003e\n\u003cli\u003eOverview of the Pivot Table Tools Tabs\u003c\/li\u003e\n\u003cli\u003eChanging the Data Displayed and Refreshing the PivotTable\u003c\/li\u003e\n\u003cli\u003eCreating a Pivot Chart from a Pivot Table or Data\u003c\/li\u003e\n\u003cli\u003eSome Real-life Examples\u003c\/li\u003e\n\u003cli\u003eModule Six: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Seven: Macros\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eDisplaying the Developer Tab\u003c\/li\u003e\n\u003cli\u003eRecording and Running Macros\u003c\/li\u003e\n\u003cli\u003eChanging the Security Level\u003c\/li\u003e\n\u003cli\u003eCustomizing and Changing the Quick Access Toolbar\u003c\/li\u003e\n\u003cli\u003eModule Seven: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Eight: Solving Formula Errors\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eUsing Named Ranges\u003c\/li\u003e\n\u003cli\u003eUnderstanding Formula Errors\u003c\/li\u003e\n\u003cli\u003eUsing the Trace Errors Commands\u003c\/li\u003e\n\u003cli\u003eUsing Error Checking\u003c\/li\u003e\n\u003cli\u003eEvaluating Formulas\u003c\/li\u003e\n\u003cli\u003eModule Eight: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Nine: Using What If Analysis\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eUsing Goal Seek\u003c\/li\u003e\n\u003cli\u003eUsing the Scenario manager\u003c\/li\u003e\n\u003cli\u003eUsing a One Input Data Table\u003c\/li\u003e\n\u003cli\u003eUsing a Two Input Data Table\u003c\/li\u003e\n\u003cli\u003eModule Nine: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Ten: Managing Your Data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eTransposing Data from Rows to Columns\u003c\/li\u003e\n\u003cli\u003eUsing the Text to Columns Feature\u003c\/li\u003e\n\u003cli\u003eChecking for Duplicates\u003c\/li\u003e\n\u003cli\u003eCreating Data Validation Rules\u003c\/li\u003e\n\u003cli\u003eConsolidating Data\u003c\/li\u003e\n\u003cli\u003eModule Ten: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Eleven: Grouping and Outlining Data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eGrouping Data\u003c\/li\u003e\n\u003cli\u003eAdding Subtotals\u003c\/li\u003e\n\u003cli\u003eOutlining Data\u003c\/li\u003e\n\u003cli\u003eViewing Grouped and Outlined Data\u003c\/li\u003e\n\u003cli\u003eModule Eleven: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c!-- ebsi-cross-sell --\u003e\u003cdiv class=\"ebsi-cross-sell\"\u003e\n\u003ch3\u003eContinue your learning\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003ePart of this learning pathway:\u003c\/strong\u003e \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eNext course:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2013-expert\"\u003eExcel 2013 Expert\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLearners also take:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2013-essentials\"\u003eExcel 2013 Essentials\u003c\/a\u003e  |  \u003ca href=\"\/products\/excel-365-essentials\"\u003eExcel 365 Essentials\u003c\/a\u003e\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c!-- ebsi-academy-breadcrumb --\u003e\n\u003chr\u003e\u003cdiv class=\"ebsi-course-pathway\"\u003e\n\u003cp\u003e\u003cstrong\u003eCourse pathway:\u003c\/strong\u003e \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e \u0026gt; \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e \u0026gt; Excel 2013 Advanced\u003c\/p\u003e\n\u003cp\u003eExplore more \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e training or return to the \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/div\u003e","brand":"eBSI Export Academy","offers":[{"title":"Individual Licence (EUR 40)","offer_id":14358846111807,"sku":"ITLU011","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260627976540,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260628009308,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU011_Excel_2013_Advanced_1.png?v=1590011813","url":"https:\/\/www.ebsiamericas.com\/products\/excel-2013-advanced","provider":"eBSI Export Academy","version":"1.0","type":"link"}