Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel for Winning Managers - Coggle Diagram
Excel for Winning Managers
Chapter 1: Introduction to Excel for Winning Managers
Overview of Excel Interface
Excel Basic Features
Common usecases
Importance of Excel in workplace
Chapter 4: Visualizing Data with Excel Charts
Chart Elements
Basic Charts - Bar, Column, Funnel, Pie, Doughnut, Line, Area, Radar, Surface
Advanced Chart - Histogram, Box and Wisker, Waterfall, Treemap, Sunburst
Designs & Formats
Interactive Charts
Chapter 3: Advance Excel Fuinctions
Basic Lookup Functions
Advance Lookup functions
Logical Functions
Formula Auditing
Practical Use Cases
Chapter 2: Essential Excel Formulas
Basic Formulas
Insert Function Dialog Box
Basic Text Functions
Basic Date Functions
Basic NUmber Function
Chapter 5: Organizing and Analyzing Data
Creating and Customizing PivotTables
Summarizing Data
Value Field Settings
Report Layouts
Group Fields & Calculated Fields
Filters, Slicers & Time Lines
Pivot Charts
Chapter 8 Advanced Time-Saving Tools in Excel
Flash Fill
Conditional Formatting
Grouping & Ungrouping Data
Quick Analysis Tools
Data Validation
Named Range
Goal Seek
Excel Tables
Quick Access Toolbar
Keyboard Shortcut keys
Chapter 10: Advanced Tools for Data Handling
Power Query
Power Pivot
Chapter 9 Overcoming Excel Fears and Building Confidence
Addressing Common Fears and Misconceptions About Excel
Building Confidence in Using Excel Independently
Understanding Why People Fear Excel
Practical Steps to Overcome Excel Anxiety
The Right Mindset for Learning Excel
Developing an Independent Approach to Excel
Busting the Myths About Excel
Automating Repetitive Tasks with Macros
Understanding Macros
Enabling the Developer Tab
Recording Your First Macro
Editing and Customizing Macros in VBA (Basics Only)
Debugging and Fixing Macro Errors