Clear Choice Technical Services of San Francisco

Contact Us Now
(415) 423-0663 Live Chat Software

Office Hacks: Accounting Excel Tips For Quarterly Reports

November 26, 2013 By Admin

We all know there is a right way and a wrong way to complete a task. We’ll be talking about doing something the right way—but faster. (If you wanted to learn about doing something wrong slowly, stay tuned for our new blog series, Office Sacks, due to come out April 1, 2014.)

Balancing your organization’s budget or analyzing revenue is no joke, which is why accountants and bookkeepers put in extra hours during month’s end to compile the reports. These reports are very useful in researching and discovering large variances. Here are some useful Excel tips that will help you summarize your findings.

PivotTable

PivotTables are interactive tables that can help you summarize a large amount of data with various aspects (an expense report containing dates, vendors, expenses, etc.). This allows you to analyze the data to make comparisons or detect patterns and relationships in various aspects of the data.

Yes. Our expense report is mostly caffeine.

To create the PivotTable:

  1. Click the Insert tab
  2. Select PivotTable to bring up the Create PivotTable dialogue box. You can select the data on the existing worksheet, or even use data from another workbook, or Excel file.

After creating the PivotTable, you can decide which information to show to analyze the data:

With a PivotTable on the coffee expense, we can answer:

  • How much was spent
    • Overall.
    • Per month.
    • Per day (useful if I expensed multiple coffee runs).
    • Per vendor.
  • Which vendor
    • Was visited most often overall.
    • Was the most popular by month.
    • We spent the most on.

You can make a lot of conclusions and summaries from your data with just a few clicks!

Group

You can also package your data and findings into easily digestible amounts rather than overloading others with a workbook packed with worksheets loaded with cells upon cells of numbers. You do this by grouping rows (or columns) together, which can then be collapsed to hide extraneous data.

Preparing for April Fools took a toll on us in March.

While our coffee expense report isn’t too cluttered, imagine if we were a warehouse that had to keep track of the movement of each product unit. The report would be huge. But executives don’t want huge reports—they want an overview.

To group information,

  1. Highlight consecutive rows (or columns) of similar level data.
  2. Click the Data tab.
  3. Click the Group button.

This is how the final result will look for our coffee data:

The CEO wants to see a high-level Q1 total:

But the CFO wants to see the monthly breakdown:

And finally, your manager wants to see how many coffee runs were needed in March to pull off the best April Fools prank in company history.

These two tips will go a long way in making your reports easier to analyze so that you can come to conclusions that are easier to understand.

Filed Under: Uncategorized

Want Us to Contact You with a Quote

FAST - EASY - FREE "1min Fill in Below"

Don’t Miss Our Latest Promos. Subscribe Our Newsletter Now!





Name:

Email:

Phone:

San Francisco, CA 94104

(415) 423-0663


Affordable Copiers – Service Area we Cover

Los Angeles, San Diego, San Jose, East San Gabriel Valley, San Francisco, Fresno, Sacramento, Long Beach, Oakland, Bakersfield , Anaheim, Santa Ana, Riverside, Stockton, Chula Vista, Irvine, Fremont, San Bernardino, Modesto, Oxnard, Fontana, Moreno Valley, Huntington Beach, Glendale, Santa Clarita, Garden Grove, Oceanside, Rancho Cucamonga, Santa Rosa, Ontario, Elk Grove, Corona, Lancaster, Palmdale, Coachella Valley, Salinas, Hayward, Pomona, Escondido, Sunnyvale, Torrance, Pasadena, Orange, Fullerton, South Bay Cities, Thousand Oaks, Visalia, Roseville, Concord, Simi Valley, Santa Clara, Victorville, Vallejo, Berkeley, El Monte, Downey, Costa Mesa, Carlsbad, Inglewood, Fairfield, Ventura, Temecula, Antioch, Richmond, West Covina, Murrieta, Norwalk, Daly City, Burbank, Santa Maria, El Cajon, San Mateo, Rialto, Clovis, Compton, Vista, Mission Viejo, South Gate, Vacaville, Carson, Santa Monica, San Marcos, Hesperia, Arden-Arcade, Westminster, Redding, Palos Verdes, Santa Barbara, San Leandro, Chico, Loomis Basin-Folsom Lake, Hawthorne, Whittier, Newport Beach, Livermore, Citrus Heights, Tracy, Indio, Alhambra, Chino, Buena Park, Hemet, Redwood City, Merced, Lakewood, Tustin, Lake Forest, Napa, Mountain View, Bellflower, Pleasanton, Alameda, Baldwin Park, Chino Hills, Upland, Folsom, San Ramon, Perris, Milpitas, Union City, Manteca, Apple Valley, Turlock, Redlands, San Gorgonio Pass, Rancho Cordova, Redondo Beach, Pittsburg, Yorba Linda, Walnut Creek, Palo Alto, Camarillo, Davis, Yuba City, Laguna Niguel, San Clemente, Pico Rivera, Lodi, Montebello, Madera, Florence-Graham, Santa Cruz, Encinitas, La Habra, Tulare, Carmichael, Monterey Park, Castro Valley, Cupertino, Gardena, Rocklin, National City, Lake Elsinore, Petaluma, Huntington Park, San Rafael, La Mesa, Arcadia, Woodland, Santee, Brentwood, Fountain Valley, Diamond Bar, Porterville, Hanford, Novato, Rosemead, Dublin, Highland, Colton, Cathedral City, Watsonville, Yucaipa, Delano, Gilroy, Placentia, West Sacramento, Glendora, Palm Desert, Aliso Viejo, Cerritos

Zip codes: 94102, 94103, 94104, 94105, 94107, 94108, 94109, 94110, 94111, 94112, 94114, 94115, 94116, 94117, 94118, 94121, 94122, 94123, 94124, 94127, 94131, 94132, 94133, 94134, 94158.

Get Free VOIP Phone System Quotes! Yes Click Here

We Work On Most Models

Copier Lease San Francisco Supported Brands

Copy Machine Service Location


555 California Street San Francisco, California 94104
Phone Number: (415) 423-0663
 

Business Hours

Mon-Fri: 8:00AM - 5:00PM
Sat-Sun: Closed

Clear Choice Technical Services of San Francisco

  • Copy Machine Maintenance
  • Copier Rentals and Leasing
  • Copier Sales
  • Copier Repair
  • Copier Lease San Francisco
  • Copy Machine Rentals
  • Blog

Copier Lease San Francisco

  • Canon Copiers
  • Copier Lease San Francisco CA
  • CopyStar Copiers
  • Gestetner Copiers
  • Konica Minolta Copiers
  • Kyocera Copiers
  • Kyocera Copiers
  • Lanier Copiers
  • NEC Copiers
  • Océ Copiers
  • Panasonic Copiers
  • Photocopier Machine
  • Canon Photocopiers
  • Copier Machine
  • Copier Machines
  • Multifunction Printers
Copyright © 2021. Copier Lease Specialist. All Rights Reserved.