Make a career in data analysis with Excel, VBA, Access, SQL Server and more...
Like our page for more updates
Click Here for Online Training
Customizing common options in Excel
Absolute and relative cells
Protecting and un-protecting worksheets...
Writing conditional expressions (using IF)
Using logical functions (AND, OR, NOT)
Using lookup and reference functions...
VlookUP with Exact Match, Approximate Match
Nested VlookUP with Exact Match
Using VLookUP to consolidate Data from...
Advanced Formulas: sum
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations based on...
Visual Basic (VB)
Overview of Visual Basic
Building controls on user forms
Overview of Modules (standard and...
Writing the Code
Working with Controls
List Box and Combo Box
Dealing with Data
Working with Variables and Constants
Working with Arrays
Performing Arithmetic Operations
Working with Strings
Dealing with Multiple Choices using Select...
Looping for Repetitive Jobs
VBA (Excel VBA)
Overview of VBA
Objects in VBA
Ranges, cells, Rows, Columns (Deleting...
Copying and Pasting Data in VBA
Working with condition, Strings, looping
Opening, creating, Saving Deleting...
Combining sheets and workbooks
Using different active x controls on Worksheets
Using File Open Dialog to Read files
Workbook and Worksheet events
Creating Pivot tables in VBA
Creating Charts in VBA
Auto Filters using VBA
Dealing with Files and Folders
Introduction to Access (database, tables...
Acccess Menu, toolbar, quick access...
Tables, Data type, records and fields
Implementing database normalization
Setting composite primary keys
Building a Relational Database with Access
Importing & Exporting Data
Linking to External Data
Working with Linked Tables
Choosing fields in the Design View
Access Queries (creating, selecting, criterias)
Using Aggregate queries (Group by, sum...
Select, Action and Parameter queries
Using access editor
Modules, procedures and function
Variables, Looping and If Conditions
Working with Objects and Collections
Working with Access Forms using VBA
Creating event procedures
Form event procedures
Control event procedures
Opening Form with event procedure
Running and event procedure when closing...
Understanding ADO Object
ADO Connection object
ADO Recordset Object
Creating connection with Current Database
Microsoft SQL Server
Introduction to SQL Server
Constraints in SQL Server
Select, From, Where,Group by, Having, Order...
Using Like Operators
Inner Join, Self Join, Right outer Join, Left...
Self Containd Query
Common Table Expressions
© copyright 2016 MrAnalyst.in. All rights reserved.