CREATIVEMOVES WIN |
UNLEASH
THE POWER OF EXCEL
UNLEASH THE POWER OF MS EXCEL FOR HR, PRODUCTION, OPERATIONS, ACCOUNTING, AUDIT, PLANNING AND OTHERS! |
A COURSE FOR YOU AND YOUR EMPLOYEES who want to discover and leverage the hidden powers of MS Excel to create meaningful analysis from everyday Excel files by creating stunning charts, Pivot Tables, Power Query Functions, and real-time dashboards. Your outputs from this live webinar will surely impress your boss! You will be tagged as EXCEL HERO in your department and your company as a whole.
Here are the things that you will learn: MODULE 1 1.1 The Hidden Powers of Excel 1.2. How Excel can Make Your Job AI-Proof MODULE 2 2.1 Absolute & Relative Ref 2.2 Mixed Ref MODULE 3 3.1 Chart Basics 3.2 Chart Series and Column Charts 3.3 Bar Charts 3.4 Pie Charts 3.5 Composite Charts MODULE 4 4.1 Autosum Function 4.2 Vlookup Function 4.3 Hlookup Function MODULE 5 5.1 Choose Function 5.2 Transpose Function 5.3 Rank Function MODULE 6 6.1 Countblank Function 6.2 Index & Match Functions 6.3 Conditional Formatting 6.4 Convert from Numbers to Words 6.5 Create Data Entry Form in Excel MODULE 7 7.1 Power Query Consolidation 7.2 Pivot Tables 7.3 Setting up a Pivot Table 7.4 Pivot Table Field Settings 7.5 Pivot Table Calculated Fields 7.6 Pivot Table Groupings 7.7 Pivot Table Slicers and Timelines MODULE 8 8.1 Using Excel’s Macro Recording Tool 8.2. Introduction to VBA 8.3 Preparing and Cleaning Up Data with VBA 8.4. Using VBA to Automate Excel Formulas |
Platform Choices:
Methodology:
|