MS Excel Power Ninja

Excel Power Ninja

Automate Your Repeatative Work

  • Investment

    9000 6500

  • Course Duration

    10 Days

What you'll learn

    <
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Understand coding, and the thought process behind it
  • Fully automate Excel using Visual Basic for Applications and complete routine tasks thousands of times faster!
  • Fully automate report generation
  • Develop complex full blown applications from scratch
  • Control other Microsoft applications like Outlook, Word, PowerPoint and even Windows itself!
  • Create emails and send them automatically!
  • Create Word documents using VBA code right from Excel!
  • Create PowerPoint presentations in seconds automatically
  • Create entire folder directories in Windows automatically!
  • Understanding Excel Macros
  • Activating the Developer Tab in Excel
  • Creating a Macro with the Macro Recorder
  • Editing a Macro with VBA
  • Creating Buttons to Run Macros
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Welcome to the Course
  • Understanding the Why and How Behind Excel Macros
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Inserting and Formatting Text
  • Start Recording!
  • Running a Macro with a Button
  • Opps! I Need to Edit My Macro
  • Practical Uses of Excel Macros
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Excel VBA Concepts
  • The Visual Basic Editor (VBE)
  • Excel VBA Modules
  • Creating an Excel VBA Procedure
  • Adding Code to a VBA Procedure
  • Understanding Excel VBA Variables
  • Building Logic with an IF Statement
  • Working with Excel VBA Loops to Repeat Blocks of Code
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Interacting with the User
  • Breaking Down the VBA Code
  • Prompting the User for Information
  • Continue Excel VBA Input Box
  • Building Logic into Your Macros
  • Alerting the User of Errors
  • Other Practical Uses of Message and Input Boxes
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Cleaning Up and Formatting Data
  • Preparing to the Use the Macro Recorder
  • Inserting the Headers
  • Formatting the Headers
  • Putting it all Together with a Little VBA
  • Running the Loop
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Automate Excel Formulas
  • Automate the SUM() Function through Code
  • Continue Automate SUM Function
  • Test the SUM Function
  • Loop the SUM() Function Over Multiple Worksheets
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Creating the Final Report
  • Creating the Final Report Loop
  • Copying and Pasting Data with VBA
  • Running the Final Report Procedure
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Working with Excel VBA User Forms
  • Creating an Excel User Form
  • Adding Controls to the Form
  • Adding VBA Code to the Initialize Event
  • Adding VBA Code to the ComboBox Change Event
  • Adding VBA Code to the Add Worksheet Button
  • Change Worksheet Name
  • Adding VBA Code to the Create Report Button
  • Showing the Form
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Opening a Text File for Import
  • Opening a Text File for Import
  • Get Data from Text File
  • Importing Multiple Text Files with the GetOpenFilename Method
  • Creating a Loop to Read Each File
  • Adding a New Sheet for Imported Data
  • Clear the Clipboard
  • Working with the ScreenUpdating Property
  • Creating Reusable Code with a VBA Function
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
Bonus
  • Resume Building Free (Originally Rs.2500)
  • Community of Life Long Learners Free (Originally Rs. 25,000)
  • Interview Skills Free (Originally Rs.2500)
  • Life Long access to Community of Life Coaches, Motivational Speakers, Digital Influencers who keep inspiring you to lead happy and fulfilling life Free (Originally Priceless)
  • Exclusive FB Group Free (Originally Priceless)

Congratulations! You Became an absolute Excel Power Ninja