CONSUMERFED

Consumerfed Accounts Section

Consumerfed accounts section is headed by accounts manager, Thanks for her support in all my works.

Attendance consolidation in consumerfed in spreadsheet


Microsoft Office Utilities is an essential part of an organisation. Deep knowledge in MS office will help your works go on smoothly. 




How to create office hierarchy in Micro Soft Office Word

Open MS Office >> Insert tab>> SmartArt >> Hierarchy

Office Hierarchy in Ms office word
Office Hierarchy


MS WORD TEMPLATE
MS OFFICE WORD TEMPLATES



Thanks for your supports
Author : +belazy

How to search whether a given a given value for the key exist in key value paired table?

you can use Vlookup for this case. syntax : vlookup(searchvalue,array,position,true/false)
Ultimately the Vlookup help you to search(find out/lookup) for a key/list of key from the table (nxn array ) given in the formulae.

searching for a list of data from excel table
Search for a list of data from a excel table


The image shows how to use vlookup

thanks for your supports

Author : +Vipin Cp


Then what is difference between vlookup and match function in excel?

VLOOKUP function search for a specific value in a table array and you can return any value column value in that row (you just need to specify the position of column value to be returned in vlookup function)
whereas
MATCH return the position of key from the table array.

Take a look at some basic function that helps you in excel.

How to find the largest number in excel?
How to find the smallest number in excel?
How to find the fourth largest or fourth smallest number in excel?
How to find the maximum or minimum value of an array in excel?
How to find the most frequently occurring number from an array?
How to find the middle value of the array?
How to find the medium value in the array?
How to find average value of an array based on specific condition?

Basic Formulas in Excel
Excel Basic Formulas 
Thank you all for your valuable supports in office

Author : +Shimjith 

How to find the sum of values in a table based on certain criteria specified by user.

=SUMIF(A:A,">10") will sum up all the values which is greater than 10 in Ath column of excel sheet.

Syntax

SUMIF(tablerange, criteria, summationcolumn)

SumIF in Excel
Sum of values based on certain criteria 

Thanking you for your supports



How to sum values in excel table based on a given criteria

use =sumif(table_array,criteria,sum_column)

excel summation
Summation of similar data in excel
Application

budget year wise calculation
Budget preparation 






Thanking you for your support




How to create year wise sales graph in microsoft office excel?


Step 1: In insert tab choose the graph you need to draw.
Step 2: Select the graph, and go to design tab and select " select data "
Step 3: A window will be open, where you can see " chart data range " , now choose the data table for graph
Step 4 :Select format / Design tab to change the chart design and settings.

M S Office Excel Graph
Sales Graph in MS Office Excel




Description : The example shows how to draw sales graph in excel (bar graph)

Read Full Tutorial 

Task assigning template in excel

 
TASK ASSIGN EXCEL SPREAD SHEET TEMPLATE
TASK ASSIGN EXCEL TEMPLATES

Download link for excel file 
filename :javabelazy100200
password : sachintendulkar
Excel Template direct download here
100+ Downloads in a week.

Data bars in excel

DATA BARS IN MS OFFICE
DATA BARS IN MS OFFICE
Browse to conditional formatting tab in excel tools, then choose data bar in it, change the type to percentage (if you didnt want to show the value in data bar , check show bar only )
author : +belazy 


Drop down list in Excel

DROP DOWN IN EXCEL
Drop Down List in Excel

How to help multiple user to work on same excel sheet simultaneously?


How to consolidate multiple sheets into one single sheet in  MS Office Excel?





How to create a Pivot table in   MS Office Excel?

PIVOT TABLE CREATION IN EXCEL
WORKING WITH PIVOT TABLE


Read Full Tutorial



How to create a column wise report using pivot table in excel sheet?

TAKING REPORT USING PIVOT TABLE

click here


How to validate data date validation in each cell in excel sheet?


Data validation tab in data will restrict end user typing errors. we could eliminate possible type error through this feature, Just set the validation criteria here, you can validate string, date, int , decimal etc here. Input Message : will shows a title message with heading and description. Error alert: will alert end user when the validation failed. Thanks to +msoffice2003 +belazy 


For Excel free templates visit this page  page2

link3


How to crack MS Office Excel Password in protected sheet

Press Alt + fll then paste the code open the active password protected sheet then run the macros

Sub CrackExcelPassword()
  'Author +bithesh soubhagya

  Dim i As Integer, j As Integer, k As Integer
  Dim l As Integer, m As Integer, n As Integer
  Dim i1 As Integer, i2 As Integer, i3 As Integer
  Dim i4 As Integer, i5 As Integer, i6 As Integer
  On Error Resume Next
  For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
  For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
  For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
  For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
   
  ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
      Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
      Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
  If ActiveSheet.ProtectContents = False Then
      MsgBox "One usable password is " & Chr(i) & Chr(j) & _
          Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
          Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
   ActiveWorkbook.Sheets(1).Select
   Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
          Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
          Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
       Exit Sub
  End If
  Next: Next: Next: Next: Next: Next
  Next: Next: Next: Next: Next: Next

End Sub

Download MS office 2013 cracked

download link

Message Me Here

Never give up. watch this video


Attendance Tracking System developed for I T Section kozhikode



Thanks to +Vipin Cp  +Shimjith It  +deepajayaprakash payyanakkal  for their supports

Facebook Page

Facebook comments