0   reviews on Udemy

Excel VBA | 100+ Excel Formulas | Tips &Trick| HTML, CSS, JS

Learn Excel VBA, Excel Formulas, Excel Tips & Tricks and HTML, CSS, JS from scratch
Course from Udemy
 1 students enrolled
 en
Learn Excel VBA from scratch
100+ Excel Formulas with downloadable file
30+ Excel Tips & Tricks
Learn HTML, CSS & JS from scratch
Excel data analytics
Learn Excel VBA formulas & perform complex calculations
Internet explorer & MS Outlook automation
MS Access database automation
Use Excel as a database logic
How to create interactive Excel dashboard, Conditional formatting
Create simple break tracker
  • Excel VBA

  • Excel Formulas

  • Excel Tips & Tricks

  • HTML

  • CSS

  • JSS

Note : Attached 30+ training materials/ downloadable files in each Lectures for your reference. Please download and use it.

In this course you will learn:

  • Learn Excel VBA from beginner to advanced skill

  • Excel Formulas explained and attached file with all the formulas

  • Excel Tips and tricks explained

  • Learn Excel VBA formulas & perform complex calculations

  • How to Create interactive Excel Dashboard with Downloadable File

  • Create Simple Break Tracker

  • List of Keyboard shortcuts explanation

  • How to Protect Excel workbook

  • How to use Conditional Formatting

  • Excel Tab explanation

  • List of Excel File extensions

  • Simple way to Extract data from web

  • What is VBA & Macro ?

  • Tips to learn VBA quickly

  • How to Add developer Tab in Excel

  • How to use Record Macro

  • Learn Excel VBA from scratch

  • For Loops_Do While_Each

  • How to use Formulas in VBA

  • Reference libraries in VBA

  • How to use Sendkeys

  • MS Access database to Excel automation

  • How to use Excel as Database (SQL query)

  • Display count_Userform_Status bar

  • Difference between HTML CSS Javascript

  • HTML Document structure _ Sample document

  • HTML editor download & Overview

  • How to view HTML source code

  • HTML Tags Basics

  • HTML links

  • HTML Div, Classess & IDs

  • HTML Forms & Frames

  • CSS & Javascript overview

What Is VBA?

VBA stands for Visual Basic for Applications. VBA is a programming language which was developed by Microsoft and is included in most Microsoft Office programs, like Excel, Word, Outlook and PowerPoint. The Office suite programs all share a common programming language.


Advantages of Excel Macro?

•Automates repetitive and routine tasks

•Reduces the turnaround time

•Reduces the formulas burden used in Excel reports

•Excel always executes the task in exactly the same way

•If you’re a good macro programmer, Excel always performs the task without errors

Excel VBA | 100+ Excel Formulas | Tips &Trick| HTML, CSS, JS
$ 19.99
per course
Also check at

FAQs About "Excel VBA | 100+ Excel Formulas | Tips &Trick| HTML, CSS, JS"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.

SOCIAL NETWORK