Duration: 6h 25m | .MP4 1280×720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.57 GB Genre: eLearning | Language: English
Learn Excel VBA, Excel Formulas, Excel Tips & Tricks and HTML, CSS, JSS from scratch
What you’ll learn
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
Requirements
No previous experience required
Description
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
Who this course is for:
Whoever likes to Learn Excel VBA, Formulas, HTML, CSS & JS from scratch
DOWNLOAD
