The Dynamics of Microsoft Excel Workbook, Charts, PivotTable - Druckversion +- Forum Rockoldies (https://rockoldies.net/forum) +-- Forum: Fotobearbeitung - Photoshop (https://rockoldies.net/forum/forumdisplay.php?fid=16) +--- Forum: E-Learning, Tutorials (https://rockoldies.net/forum/forumdisplay.php?fid=18) +--- Thema: The Dynamics of Microsoft Excel Workbook, Charts, PivotTable (/showthread.php?tid=70121) |
The Dynamics of Microsoft Excel Workbook, Charts, PivotTable - Panter - 16.05.2023 The Dynamics of Microsoft Excel Workbook, Charts, PivotTable Last Updated 08/2022 MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English + srt | Duration: 161 lectures (22h 18m) | Size: 10.1 GB The Practical Guide to EXCEL (2021, 2016, 2013) - Conditional Formatting, PivotTable, Analyze Data, 2D/3D Charts. Maps What you'll learn Learn Excel from scratch to a comfortable professional Harness the power of Macros to automate your tasks You'll learn how to create a Funnel Chart, Combo Chart, Pareto chart, Histogram, Treemap, Box and Whisker Charts, Sunburst charts and more Explore the dynamics of Pivot Table and Pivot Chart Maximize the customization of 3D and 2D charts How to Protect your Excel files and worksheets properly. Automate data entry with Auto-Fill and Flash-fill. Organize and structure data for easy analysis (Find through wildcard, Sort, Filter, Search & Replace, etc) Requirements Excel 2013, Excel 2016, Excel 2019, Office Excel 365 software A computer and the zeal to learn at your pace Description You are welcome to this Excel course. You will be guided step by step on how to be confident Microsoft Excel. In this course you will Learn how to work with Excel Workbook from scratch (absolute beginner) to a comfortable user Learn how to create Excel Macro - Absolute referencing vs Relative referencing Be able to create a Macro button Automating Charts with Macros Create Header and Footer within your Excel Worksheet Learn how to use printing setup and page setup in Excel Be able to use the conditional formatting tool to present data Maximize the customization of 2D and 3D charts Organize and structure data for easy analysis (Find through wildcard, Sort, Filter, Search & Replace, etc) Formatting 3D Bar Chart, 3D pie Chart elements Use slicer tools to makes charts operate in a dynamic way Use the Analyze Data Tool in Office 365 Converting table to range and removing duplicates Learn how to use printing setup and page setup in Excel Be able to Freeze and unfreeze panes Explore the dynamics of Pivot Table and Pivot Chart Explore the dynamics of Excel Table and applying sorting and filtering tools Understand how to use the slicer tools and timeline filter tools Understand the dynamics of Sparklines - columns, win/loss, Line Be able to create a Map Chart with multiple levels of geographic details Create 3D Map with Time Line Learn how to create a Funnel Chart, Combo Chart, Pareto chart, Histogram, Treemap, Box and Whisker Charts, Sunburst charts and more Automate data entry with Auto-Fill and Flash-fill. Be able to work with smart art, take screenshots and manipulate shapes and edit images Learn how to transpose data - that is switching the columns and rows in Excel Who this course is for This course is for absolute beginners. Intermediate Excel users are not exempted. Understanding the dynamics of Excel Charts, Pivot Table, Maps can land you a Data Analyst job. So if you want to go that route, this Excel course is for you |