To group like data together you want to sort your information first. This is going to be key. Using the Subtotal feature of Microsoft Excel you will be able to group the like data eg; State then perform a mathematical instruction like sum, Average or count. Watch the video on my YouTube Analir Pisani if you need further clarification. AZ Solutions Pty Ltd also offers Virtual Classroom training and Face to Face in Sydney Australia.
Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist
To group like data together you want to sort your information first. This is going to be key. Using the Subtotal feature of Microsoft Excel you will be able to group the like data eg; State then perform a mathematical instruction like sum, Average or count. Watch the video on my YouTube Analir Pisani if you need further clarification. AZ Solutions Pty Ltd also offers Virtual Classroom training and Face to Face in Sydney Australia.
Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist