Posted on

Ad by City

Online  Excel Classes Across the India

Excel Macro Classes in Agra
Excel Macro Classes in Ahmedabad
Excel Macro Classes in Ajmer
Excel Macro Classes in Aligarh
Excel Macro Classes in Allahabad
Excel Macro Classes in Ambattur
Excel Macro Classes in Amravati
Excel Macro Classes in Amritsar
Excel Macro Classes in Asansol
Excel Macro Classes in Aurangabad
Excel Macro Classes in Bangalore
Excel Macro Classes in Bareilly
Excel Macro Classes in Belgaum
Excel Macro Classes in Bhavnagar
Excel Macro Classes in Bhilai Nagar
Excel Macro Classes in Bhiwandi
Excel Macro Classes in Bhopal
Excel Macro Classes in Bhubaneswar
Excel Macro Classes in Bikaner
Excel Macro Classes in Chandigarh
Excel Macro Classes in Chennai
Excel Macro Classes in Coimbatore
Excel Macro Classes in Cuttack
Excel Macro Classes in Dehradun
Excel Macro Classes in Delhi
Excel Macro Classes in Dhanbad
Excel Macro Classes in Durgapur
Excel Macro Classes in Faridabad
Excel Macro Classes in Firozabad
Excel Macro Classes in Gaya
Excel Macro Classes in Ghaziabad
Excel Macro Classes in Gorakhpur
Excel Macro Classes in Gulbarga
Excel Macro Classes in Guntur
Excel Macro Classes in Gurgaon
Excel Macro Classes in Guwahati
Excel Macro Classes in Gwalior
Excel Macro Classes in Haora
Excel Macro Classes in Hubli and Dharwad
Excel Macro Classes in Hyderabad
Excel Macro Classes in Indore
Excel Macro Classes in Jabalpur
Excel Macro Classes in Jaipur
Excel Macro Classes in Jalandhar
Excel Macro Classes in Jalgaon
Excel Macro Classes in Jammu
Excel Macro Classes in Jamnagar
Excel Macro Classes in Jamshedpur
Excel Macro Classes in Jhansi
Excel Macro Classes in Jodhpur
Excel Macro Classes in Kalyan & Dombivali
Excel Macro Classes in Kanpur
Excel Macro Classes in Kochi
Excel Macro Classes in Kolapur
Excel Macro Classes in Kolkata
Excel Macro Classes in Kota
Excel Macro Classes in Loni
Excel Macro Classes in Lucknow
Excel Macro Classes in Ludhiana
Excel Macro Classes in Madurai
Excel Macro Classes in Maheshtala
Excel Macro Classes in Malegoan
Excel Macro Classes in Mangalore
Excel Macro Classes in Meerut
Excel Macro Classes in Mira and Bhayander
Excel Macro Classes in Moradabad
Excel Macro Classes in Mumbai
Excel Macro Classes in Mysore
Excel Macro Classes in Nagpur
Excel Macro Classes in Nanded Waghala
Excel Macro Classes in Nashik
Excel Macro Classes in Navi Mumbai
Excel Macro Classes in Nellore
Excel Macro Classes in Noida
Excel Macro Classes in Patna
Excel Macro Classes in Pimpri & Chinchwad
Excel Macro Classes in Pune
Excel Macro Classes in Raipur
Excel Macro Classes in Rajkot
Excel Macro Classes in Ranchi
Excel Macro Classes in Saharanpur
Excel Macro Classes in Salem
Excel Macro Classes in Sangli Miraj Kupwad
Excel Macro Classes in Siliguri
Excel Macro Classes in Solapur
Excel Macro Classes in Srinagar
Excel Macro Classes in Surat
Excel Macro Classes in Thane
Excel Macro Classes in Thiruvananthapuram
Excel Macro Classes in Tiruchirappalli
Excel Macro Classes in Tirunelveli
Excel Macro Classes in Udaipur
Excel Macro Classes in Ujjain
Excel Macro Classes in Ulhasnagar
Excel Macro Classes in Vadodara
Excel Macro Classes in Varanasi
Excel Macro Classes in Vasai Virar
Excel Macro Classes in Vijayawada
Excel Macro Classes in Visakhapatnam
Excel Macro Classes in Warangal

Posted on

Course Content

Course Content

Course 1:        Basic Excel

Basic Excel

  • Create New, Save, Delete Sheet, Workbook File
  • Sorting and filtering data
  • Cell, Column, Row, Worksheet and Workbook.
  • Sum , Sumif & Sumifs
  • Average Max and Min
  • Basic Operator (+ – / *^)
  • Greater then equal to or less then (< = >)
  • Round , Roundup and Round down
  • If and Else
  • Conditional Formatting
  • V-lookup
  • True & False
  • Data Validation
  • Grouping, Ungrouping and Subtotals
  • Filters, Custom Filters, Advanced Filters & List Type
  • Pivot Tables & Merge pivots from multiple locations
  • Goal Seek
  • Consolidate data From multiple files
  • Split Data using Text to Columns
  • Remove Duplicates
  • Data Recovery
  • Importing Data from another location or file.
  • Sorting Data on single and multiple criteria.
  • Protection of Excel Files, Workbook, Worksheet and Cells
  • Find Replace Blank Cells & Format Painter
  • Hyperlinks
  • Naming a Range, Cell etc.

 

  

Course 2:        Basic Excel + Advance Excel

Functions

  • Left, Right, Mid & Trim
  • Proper, Upper, Lower and Clean…..etc.
  • Find & Replace
  • Exact 

Date and Time Functions

  • Day
  • Days360
  • Now
  • Today
  • Time…etc.

Look Up & Reference functions

  • Lookup& Hlookup
  • Address
  • Choose
  • Index
  • Match
  • Rows
  • Transpose…etc.

Mathematical Functions

  • SumIFS
  • Even
  • Combine
  • Odd
  • Product
  • Rand
  • Randbetween

Statistical Functions

  • Len
  • Count
  • Count A
  • CountIF,CountIFS
  • Count Blank
  • Rank
  • Average,AverageIF &AverageIFS
  • Subtotal Sign.

 Information Functions

  • Cell
  • ISERROR
  • ISNA
  • ..etc.

Formula editing mode.

  • Show Formula
  • Error Checking
  • Calculations Options.
  • And & OR
  • IF & Nested IF
  • IF Error , Is Error & Isna
  • Multiple IF Conditions
  • IF….Vlookup….Match
  • IF…Hlookup….Match
  • Concatenate & “&”

Basic Macros

  • VBA Editor-Info
  • MsgBox
  • Adding Workbook
  • Adding Sheet
  • Range…etc. 

Introduction to Excel and Macros

  • Excel and Visual Basic Editor
  • Cell, Column, Row, Worksheet and Workbook.
  • Basic formula SUM, Max and Min, If & Else, Vlookup, Sum, Mid, Is error Etc.
  • Combining multiple Formulas in one
  • Recording and running macro
  • Storing macro in different books
  • Creating buttons and assigning macro on it
  • Sorting and filtering data
  • Creating custom menus and toolbars
  • Assignment
  • Identify where we can record macros
  • Find VBA codes using record macros

 

Course 3:        Complete Excel Advance Automation with VBA Macros (VBE)

Introduction to VBE (Visual Basic Editor)

  • Introduction and Understanding the VBE
  • Edit Macro Using VBE
  • How to start write code
  • Create Conditions (If…. Elseif …… Else or Select Case)
  • Loop constructs (For….. Next, Do….. Loop, While… Wend)
  • Logical Operators ( + – x ÷)
  • Offset
  • R1C1 Concept
  • Variable Declaration
  • Working with Cell, Column, Row, Range, Worksheet and Workbook.
  • Copying and pasting
  • Array
  • Reading Text File Using File Picker(File Dialogue)
  • File System Object
  • Using Immediate Window.
  • ActiveCell & Selection
  • ThisWorkbook & ActiveWorkbook
  • Selected Sheets & Active Sheet.

Introduction to User forms and its Toolbox

  • Variables, data types and constants
  • Creating Data Entry forms and other Use of User forms.
  • Working with VBA Toolbox and forms
  • Creating Add-ins

Excel Re-Engineering

  • Creating functions
  • Error Handling
  • Call Macros
  • Pivot Table
  • Free VBA Source Code
  • Assignment

 

Posted on

Change Site Content and Sidebar Width in WordPress

To Change width of Website Content (Post)  and Sidebar (Login bar , Meta)

WordPress is very great tool to develop your own website and start your business, But after all service we still need some modification in our site. So let see how to change post width and Sidebar width in wordpress.

 

For this you need to go into your WordPress Site

Dashboard

Appearance

Customize

Additional  CSS

And Put this code there

Change the Original Value of .site-content and .Wrap Max-Width and Then Change % (Percentage) of Primary (Post) and Secondary (Sidebar) sidebar.

 

Posted on

Folder Access Provider

This code will help you to provide and Remove folder access, For this you should have Admin Access to that Folder.
Declaration:-

Add this code to the Userform

Add this code to the Module

 

 

 

 

 

 

 

 

Posted on

Zip and Unzip

This code will help you to ZIP and UNZIP  folder from Excel VBA

 

Posted on

Windows Login validation

This code will help user to identify if Input Credentials (User ID and Password) are correct or Not for windows and even on Network also without login, using  VBA

 

Posted on

Window Hang / Freeze

This code will help user to freeze\Lock Windows ( No Mouse and Keyboard will work) for specific time.

Put below code in Module and Run TimeLockTest

 

Posted on

Visible Excel instance if hidden

This code will help user to to unhide Excel Running instance if that is hidden.

 

Posted on

VBS CODE TO SPEAK COMPUTER

This code help user to force Speak by computer, just write your statement and see the magic.

 

Posted on

VBS CODE TO REPLACE FILE

This code will help to copy any file from one location to another Location. You need to put this code in Notepad and save as .vbs (extension)  Example.vbs

 

If you need to Edit  just open this file with Notepad and change the path.