Course curriculum

  • 1

    Course Introduction

  • 2

    100+ Excel Formulas

  • 3

    Excel Tips & Tricks

  • 4

    Excel Basics

    • Create Excel Dashboard with Downloadable File

    • Simple Break Tracker

      FREE PREVIEW

    • List of Keyboard shortcuts

    • How to Protect Excel workbook ?

    • Conditional Formatting

    • List of Excel File extensions
  • 5

    Excel VBA Macro Demo & Downloadable files

    • Excel VBA Dump for practice - Downloadable Excel file

    • What is VBA Macro & Advantages

    • Tips to learn VBA quickly

    • Add developer Tab - F11

    • Record Macro

    • Sub_Comments_Range

    • Rows_Column_Offset_Clear

    • Msgbox & Inputbox

    • Workbook & Worksheet function in VBA

    • Immediate Window usage

    • Excel Macro Variables & Operators

    • Error Handling action

    • IF_Else statement

    • For Loops_Do While_Each

    • How to use Formulas in VBA

    • Reference libraries in VBA

    • Screen updating _ Display alerts

    • Sendkeys
  • 6

    Excel VBA Real time projects

    • MS Access database to Excel automation

    • How to use Excel as Database (SQL query)

    • Internet explorer

    • Outlook automation
  • 7

    Excel Userform

    • Display count_Userform_Status bar

    • Userform overview
  • 8

    HTML Basics

  • 9

    HTML Tags

    • HTML Tags Basics

    • Heading element

    • Paragraph tag

    • Break Tag

    • Comments Tag

    • Horizontal Rule

    • Other character formatting elements

    • HTML text allignment

    • Practice test - Which tag is not closed

    • Tag guidelines

    • Tags overlap example

    • Images in HTML
  • 10

    HTML links

    • HTML links

    • Absolute & Relative URLs

    • HTML list

    • HTML Tables

    • Scrollig text Marquee
  • 11

    HTML Div, Classess & IDs

    • Classes and IDs

    • Div element
  • 12

    HTML Forms & Frames

    • HTML Form

    • HTML Frames
  • 13

    CSS & Javascript overview

    • CSS

    • Javascript