MS Excel Essentials

Excel Essentials

For Beginners

  • Investment

    75004500

  • Course Duration

    7 Days

What you'll learn

  • Learn to program in VBA from scratch
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Complete routine tasks thousands of times faster!
  • Confidently tackle any programming project
  • Understand coding, and the thought process behind it
  • Fully automate Excel using Visual Basic for Applications
  • Fully automate report generation
  • Program simple "helper" solutions
  • 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!
  • Launching Excel
  • Microsoft Excel Startup Screen
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Customizing the Excel Quick Access Toolbar
  • More on the Excel Interface
  • Understanding the Structure of an Excel Workbook
  • Saving an Excel Document
  • Opening an Existing Excel Document
  • Common Excel Shortcut Keys
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Entering Text to Create Spreadsheet Titles
  • Working with Numeric Data in Excel
  • Entering Date Values in Excel
  • Working with Cell References
  • Creating Basic Formulas in Excel
  • Relative Versus Absolute Cell References in Formulas
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • The structure of an Excel Function
  • Working with the SUM() Function
  • Working with the MIN() and MAX() Functions
  • Working with the AVERAGE() Function
  • Working with the COUNT() Function
  • Adjacent Cells Error in Excel Calculations
  • Using the AutoSum Command
  • Excel's AutoSum Shortcut Key
  • Using the AutoFill Command to Copy Formulas
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • The structure of an Excel Function
  • Working with the SUM() Function
  • Working with the MIN() and MAX() Functions
  • Working with the AVERAGE() Function
  • Working with the COUNT() Function
  • Adjacent Cells Error in Excel Calculations
  • Using the AutoSum Command
  • Excel's AutoSum Shortcut Key
  • Using the AutoFill Command to Copy Formulas
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • The structure of an Excel Function
  • Working with the SUM() 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've Built a Solid Microsoft Excel Foundation