Buying for a team?Choose 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. Develop practical knowledge and confidence in Excel 2016 Master. Excel 2016 Master : In this mastery course you will be taken to the highest level of proficiency in MS Excel 2016. Before attempting this course you should have completed the Essentials , Advanced and Expert courses. Why this course matters This 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. What you will gain Use the key features and workflows covered in Excel 2016 Master with greater confidence. Apply the tools and techniques to practical business tasks. Recognise common mistakes and work more efficiently in day-to-day use. Who is this course for? This course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools. Course at a glance Format: self-paced online learning. Professional development: CPD course. ITLU055 : Excel 2016 Master Excel 2016 Master : In this mastery course you will be taken to the highest level of proficiency in MS Excel 2016. Before attempting this course you should have completed the Essentials, Advanced and Expert courses. Objectives: This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts. Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology. Unit Contents: 1. Getting StartedIn this topic you will cover a basic introduction to the course unit and its objectives.2. Working with ListsIn this topic you will cover:Working with ListsCreating a ListMaintaining a ListEditing Records Using the Data FormFiltering a ListUsing Subtotals in a List Self-test Quiz3. Macros and User Defined FunctionsIn this topic you will cover:Macros and User Defined FunctionsRecording and Using MacrosAssigning MacrosUsing User-Defined FunctionsSelf-test Quiz4. Basic Analysis ToolsIn this topic you will cover:Basic Analysis ToolsPerforming “What If” AnalysesWorking with ScenariosSelf-test Quiz5. Advance Analysis Tools and External DataIn this topic you will cover:Advance Analysis Tools and External DataQuerying a DatabaseImporting and Exporting FilesProtecting DataUsing Data ValidationUsing Worksheet ProtectionPassword Protecting a WorkbookSelf-test Quiz6. Pivot Tables & Advanced Business Analysis ToolsIn this topic you will cover:Pivot Tables & Advanced Business Analysis ToolsWorking with Pivot Tables and Pivot ChartsIdentifying the Parts of a Basic Pivot TablePivot Table ReportsCreate a PivotTable from worksheet dataCreate a PivotTable from an external data sourceCreate a PivotChart report from an existing PivotTable reportDelete a PivotTable or PivotChart reportSlicersUsing slicersFormatting slicers for a consistent lookSharing slicers between PivotTablesSparklinesTypes of SparklinesCreate a sparklineCustomize sparklinesControl which value points are shownChange the style of or format sparklinesOnline Analytical Processing (OLAP)Business intelligenceWhat is Online Analytical Processing (OLAP)?OLAP features in Excel 2016Self-test Quiz7. Wrapping Up / Assessment ResultIn this topic you will cover:Course ConclusionWrapping upTest Results Summary Continue your learning Part of this learning pathway: Microsoft Office & Windows Learners also take: Excel 2016 Advanced | Excel 2016 Macros and VBA Related training bundle: Excel 2016 Mastery Program Course pathway: eBSI SME Academy > Microsoft Office & Windows > Excel 2016 Master Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.
