.Equals and == Demo

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RefValDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            int val1 = 5;
            int val2 = 5;
            Console.WriteLine(val1==val2);
            Console.WriteLine(val1.Equals(val2));
            object str1 = new string(new char[] { 's', 'h', 'i', 'p', 'r', 'a' });
            object str2 = new string(new char[] { 's', 'h', 'i', 'p', 'r', 'a' }); 
            Console.WriteLine(str1==str2);
            Console.WriteLine(str1.Equals(str2));

            StringBuilder sb1 = new StringBuilder();
            sb1.Append("hello");
            StringBuilder sb2 = new StringBuilder();
            sb2.Append("hello");
            Console.WriteLine(sb1==sb2);
            Console.WriteLine(sb1.Equals(sb2));

            Customer c1 = new Customer()
            { FirstName = "Croma", LastName = "Campus" };
            Customer c2 = new Customer()
            { FirstName = "Croma", LastName = "Campus" };
            Console.WriteLine(c1==c2);
            Console.WriteLine(c1.Equals(c2));
            //Console.WriteLine(c1.GetHashCode());
            //Console.WriteLine(c2.GetHashCode());
            Console.ReadLine();
        }
    }
    class Customer
    {
        object obj = new object();
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public override bool Equals(object obj)
        {
            Customer obj1 = obj as Customer;
            return this.FirstName.Equals(obj1.FirstName) 
                && this.LastName.Equals(obj1.LastName);
        }
        public override int GetHashCode()
        {
            return FirstName.GetHashCode() ^ LastName.GetHashCode();
        }
    }
}


Async Await Demo

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;

namespace AsyncAwaitDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            Method();
            Console.ReadLine();
        }

        private async static void Method()
        {
            await Task.Run(new Action(LongTask));
            Console.WriteLine("New thread..");

        }
        public static void LongTask()
        {
            Thread.Sleep(20000);
            Console.WriteLine("LongMethod completed.");
        }
    }
}

Threading Demo

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;

namespace ThreadingDemo
{
    class Program
    {
        static public void HelloThreading()
        {
            Console.WriteLine("This is child thread started..");
            Thread.Sleep(5000);
        }
        static void Main(string[] args)
        {
            Console.WriteLine("This is main thread");
            ThreadStart th = new ThreadStart(HelloThreading);
            Thread childThread = new Thread(th);
            childThread.Start();
            Console.WriteLine("This is end of main thread");
            for (int i = 0; i < 10; i++)
            {
                Thread.Sleep(500);
                Console.WriteLine("Waiting for child thread to complete{0}..",i);
            }
            if(childThread.IsAlive)
            {
                try
                {
                    childThread.Abort();
                }
                catch (Exception)
                {
                    throw;
                }
                finally
                {
                    Console.WriteLine("Child thread aborted...");
                }
            }
            else
            {
                Console.WriteLine("Child thread completed...");
            }
            Console.ReadLine();
        }
    }
}

Free Tutorials

Android

Angular

Apple watch

ASP.Net

C#

C++

C

CSS

Data structure

HTML

Ionic

Java

Javascript

Jquery

Microsoft SQL

MongoDB

MySQL

NodeJs

Objective-C

Oracle SQL

PHP

python

R

React

Ruby

scala

Selenium

SQL Server

SQL

Swift / ios

Unit Testing

Xamarin

WordPress


Course Curriculum For Excel VBA Training

Introduction
  • Welcome to the Course – Introduction 
Overview of VBA and of the tool
  • The power of Excel with VBA, The VBA code, Recording, Saving and Running Macros 
  • Overview of the Excel Application as a Tool (Version 2016) 
  • Macro Security
  • Protect your work 
  • VBE – The VBA editor, VBA toolbar (Part I) 
  • VBE – The VBA editor, VBA toolbar (Part II) 
  • VBE – The VBA editor, VBA toolbar – Version 2016 
  • The Developer Ribbon 
  •  
The VBA language
  • Understanding the code, Remove the concept “VBA is HARD!”, The Debugging tool
  • VBE to analyze recorded macros, Objects, Methods, Properties, Code cleaning and 
Functions, subroutines, constants and variables
  • Private and Public functions and subroutines, variables by val and optional vari 
  • Functions, subroutines, constants and variables 
  • Recap on Functions and Subroutines 
  • Variables, Private and Public variables
  • Recap on Variable and Constants 
Declare functions 
  • Options: Explicit, Implicit 
  • Declare variables, declare functions in libraries, Types 
  • Dimension variables (Dim, Redim, Redim Preserve) 
  • Dimension variables 
Objects
  • Objects, Excel Objects (Worksheets as objects, Workbooks as objects) 
  • Worksheet properties and events 
  • Workbook properties and events 
  • Cells and Ranges as objects, VBA object in Excel sheets 
  • Assign events to objects in Excel sheets 
  • Objects in VBA and Excel 
Ranges and cells
  • The Range Object 
  • Range properties and selection tips, Refer to Ranges in other sheets 
  • The Offset property, Columns and Rows to refer to Ranges 
  • Retrieve the address in ranges, Size and resize ranges 
  • Columns and Rows to refer to Ranges, Join multiple ranges 
  • Merge ranges, select ranges 
  • Intersect ranges 
  • IsEmpy function 
  • CurrentRegion property 
  • Areas Collection properties 
  • Evaluate positions in Excel sheets with the range properties (End, Row, Column) 
  • identify ranges and cells in the object hierarchy, the value property 
  • Format ranges – create an automatic routine
  • Special cells 
  • Cells and Ranges
VBA Dialogs
  • The Msgbox object, Msgbox properties, Predefined Dialogs 
  • Standard Excel Dialogs, Customize a dialog box 
  • VBA constants, VBA constants for dialogs 
  • Combine VBA constants for complex statements in dialogs 
  • The InputBox 
  • How to find VBA constants and their references 
  • Dialog Boxes in VBA 
Special functions
  • User-defined functions, Excel functions in VBA functions 
  • Custom Excel functions, complex functions
Loops
  • For..Next Loops 
  • Do Loops, While..Wend loops, Do While Loops, Do Until Loops 
  • For Each – The VBA loop: loop in objects 
  • Loops in VBA
Operations and logical instructions
  • Operators, The MOD instruction, The logical instructions 
  • The IF instruction, IF, ELSE, ELSEIF… 
  • With instruction 
  • Instruction to interrupt the execution of the code 
  • Select case instruction 
  • Conditional Instructions
Formulas in ranges and Excel objects
  • Formulas, R1C1 style formulas, Display R1C1 style formulas in Excel, 
  • Retrieve ranges in Excel objects 
  • Conditional formatting of R1C1 formulas 
  • Range properties to be used to retrieve information, The R1C1 reference style 
  • Excel Formulas 
Object events and properties
  • Events and properties in worksheets, workbooks and charts 
  • The Workbook object 
  • The Chart object 
  • The Worksheet object, Default events (used and not used) 
  • Custom events and properties within Excel objects 
  • The Application object 
  • Excel Objects events and properties 
Forms
  • User Forms, Create a Userform 
  • The objects, the code, the controls 
  • Form events, User Interaction Methods 
  • Referring to controls within a form, Design a form 
  • Create interactions between controls 
  • Example of a complex Form 
  • Example of Form with overview of the controls and their properties and methods 
  • Tabs in Forms, Execute a Form from an Excel sheet 
  • Manage multiple forms and access the information of commands in a form 
  • Add references to other object in a form: the example with the calendar and the 
  • Example with tabs and formatted commands 
  • Richtext box in forms, show and hide forms 
  • Add images and reference to websites in a form 
  • Add commands at run time 
  • Scrollbars and textboxes 
  • Add help information to commands, change cursor icon 
  • Form properties: tabindex and management of the focus of the commands 
  • Change the layout of Forms using APIs 
  • Some examples 
  • Summary of the User Form 
Charts in VBA
  • Charts, Embedded Charts and ChartSheets, How to create a chart using VBA 
  • Locate Charts, Customize Charts, Label Charts, Identify the Chart Points 
  • Retrieve Data from a Chart, The Chart Types, Format the Series Collections 
  • Interactive Charts 
  • Sources and Axes, Format Charts 
  • Summary of Charts and Chart Objects

Wrap up

For any inquiry, please contact Atal @9818569825 or write to me at atal.upadhyay@gmail.com. Best yet cheapest training guaranteed.

 

Curriculum for Data Analysis with Excel Pivot Tables

Course outline and structure

PivotTable Getting Started

  • Why PivotTables?
  • Structuring Your Source Data
  • Inserting Your First PivotTable
  • Navigating the Field List
  • Manipulating PivotTable Views
  • PivotTable Options: “Analyze” & “Design”
  • Selecting, Clearing, Moving & Copying Pivots
  • Refreshing & Updating Pivots
  • Dealing with Growing Source Data
  • How PivotTables ACTUALLY Work

PivotTable Formatting

  • Number Formatting
  • Automatically Formatting Empty Cells ]
  • Table Layouts & Styles
  • Using Tabular Tables to Create New Source Data
  • Customizing Headers & Labels
  • Conditional Formatting
  • Data Bars with Invisible Text

Sorting, Filtering & Grouping

  • Sorting Options
  • Why is my Alphabetical Sorting Wrong?
  • Label Filters & Manual Selections
  • Using Label Filters with Wildcards
  • Value Filters
  • Enabling Multiple Filters
  • Grouping Data
  • Automatic Date Grouping
  • Using Slicers & Timelines to Filter Data
  • Breaking Out Report Filter Pages

Calculated Values, Fields & Items

  • “Summarize Values By” Options
  • Avoiding the “Count Of” Trap
  • “Show Values As” Calculations
  • Show Values As: % of Column/Row
  • Show Values As: % of Parent
  • Show Values As: Difference From
  • Show Values As: Running Total
  • Show Values As: Rank
  • Show Values As: Index
  • Show Values As ..More

Inserting Calculated Fields

  • Calculations in Pivots vs. Raw Data
  • Calculating Using Counts
  • Inserting a Calculated Item
  • The Solve Order & List Formulas Tools

PivotCharts

  • Intro to PivotCharts
  • PivotChart Demo: Column Chart
  • PivotChart Demo: Pie/Donut Chart
  • PivotChart Demo: Clustered Bar Chart
  • Prevent Charts from Resizing with Cells
  • Changing Chart Types on the Fly
  • PivotChart Demo: Stacked Area Chart
  • PivotChart Layouts & Styles
  • Moving PivotCharts to New Sheets
  • Applying Slicers & Timelines to Multiple Charts
  • Building a Dynamic Dashboard

PivotTable Case Studies

Wrapping Up

For any inquiry and demo, please contact Atal @9818569825 or write at atal.upadhyay@gmail.com

 

Curriculum – Microsoft Excel – Advanced Excel Formulas & Functions

Course Structure & Outline

Excel Formulas 101

  • Introduction
  • The Formula Library & Auditing Tools
  • DEMO: Evaluate Formula
  • Basic Formula Syntax
  • Fixed, Relative, & Mixed References
  • Common Errors & the IFERROR statement
  • Function, CTRL & ALT Shortcuts
  • Creating Custom Data Validation Rules
  • Fixed vs. Volatile Functions
  • Formulas 101

Conditional Statements & Logical Operators

  • Introduction
  • Anatomy of the IF Statement
  • Nested IF Statements
  • AND/OR Operators
  • NOT vs. “<>”
  • Fixing Errors with IFERROR
  • Common IS Statements
  • Logical Operators

Statistical Functions

  • Introduction
  • Basic Statistical Functions
  • SMALL/LARGE & RANK/PERCENTRANK
  • RAND() & RANDBETWEEN
  • The SUMPRODUCT Function
  • COUNTIFS/SUMIFS/AVERAGEIFS
  • PROJECT SHOWCASE: Building a Basic Dashboard with COUNTIFS & SUMIFS
  • Statistical Functions

Lookup/Reference Functions

  • Introduction
  • Working with Named Arrays
  • ROW/ROWS & COLUMN/COLUMNS
  • VLOOKUP/HLOOKUP
  • Joining Data with VLOOKUP
  • Fixing Errors with IFERROR & VLOOKUP
  • VLOOKUP Reference Array Options
  • The INDEX Function
  • The MATCH Function
  • Using INDEX & MATCH together
  • Combining MATCH with VLOOKUP
  • UPDATE: VLOOKUP Correction
  • The OFFSET Function
  • Combining OFFSET with COUNTA to return a variable list
  • PROJECT SHOWCASE: Using OFFSET to create a dynamic scrolling chart
  • Lookup/Reference Functions

Text Functions

  • Introduction
  • UPPER/LOWER/PROPER & TRIM
  • The CONCATENATE Function (&)
  • LEFT/MID/RIGHT & LEN
  • TEXT/VALUE
  • SEARCH/FIND
  • Categorizing Data with IF(ISNUMBER(SEARCH))
  • Combining RIGHT, LEN, and SEARCH
  • The SUBSTITUTE Function
  • Text Functions

Date & Time Functions

  • Introduction
  • DATEVALUE: Your New BFF
  • Date Formatting & Fill Series
  • TODAY()/NOW()
  • YEAR/MONTH/DAY & HOUR/MINUTE/SECOND
  • The EOMONTH Function
  • The YEARFRAC Function
  • WEEKDAY, WORKDAY & NETWORKDAYS
  • The DATEDIF Function
  • PROJECT SHOWCASE: Designing a Sample Budget Pacing Tool
  • Date/Time Functions

Formula-Based Formatting

  • Introduction
  • Creating, Editing & Managing Formula-Based Rules
  • Highlighting Every Other Row Using the MOD function
  • Formatting Cells Based on the Value of Another Cell
  • Formatting Cells Using Statistical Functions
  • Formatting Cells Using Text Functions & Logical Operators
  • Formula-Based Formatting

Array Formulas

  • Introduction
  • Rules of Array Functions
  • Pros & Cons of Array Functions
  • Vertical, Horizontal, and 2-Dimensional Array Constants
  • Using Array Constants in Formulas
  • Named Array Constants
  • The Transpose Function
  • Linking Data Between Sheets: Array vs. Non-Array Comparison
  • Returning the “X” Largest Values in a Range
  • Counting Characters Across Cells
  • Creating a “MAX IF” Array Formula
  • “MAX IF” with Multiple Criteria
  • Using the Double Unary Operator (“–“)
  • Array Formulas

Bonus Functions

  • Introduction
  • The INDIRECT Function
  • HYPERLINK: as Awesome as it Sounds
  • Tapping into Real-Time Data with WEBSERVICE & FILTERXML

Wrapping Up
Conclusion & Next Steps

For inquiry and demo, please contact Atal @9818569825