TrustRadius: an HG Insights company

Microsoft Excel

Score8.7 out of 10

1,619 Reviews and Ratings

What is Microsoft Excel?

Microsoft Excel is a spreadsheet application available as part of Microsoft 365 (Office 365), or standalone, in cloud-based and on-premise editions.

Categories & Use Cases

Love Microsoft Excel

Use Cases and Deployment Scope

I use Excel multiple times a week to keep track of sales, subscriptions, records, and more. The spreadsheets also allow me to keep track of our webinars and seminars by allowing multiple pages at the bottom. This way I can use the same templates and just copy it for every webinar or seminar we do. I also use it to create checklists for customers.

Pros

  • Formulas
  • Sorting and Separating
  • Clean Use
  • Visual Aspects like Graphs
  • Sharing Live

Cons

  • Explaining Use of all Different Graphics
  • Charts
  • Templates
  • Better Explanation of all the Forumlas

Return on Investment

  • Lead Sorting
  • Organization
  • Subscription Management
  • Tracking

Usability

Other Software Used

Zoho Bookings, QuickBooks Online, Zoho Analytics

Excel a Great Versatile Program

Use Cases and Deployment Scope

We use Excel for our price books, keeping track of issues with inventory, quick look bank register, tracking information, and list for mail merges, to name just some of the ways we use Microsoft Excel.

Pros

  • Sorting
  • Table Creation
  • Summing and Formulus
  • Linking Excel spreadsheets to other Excel Spreadsheets

Cons

  • Header and Footer - adding graphics and appearing on different locations on odd and even pages
  • Changing page number in the Footer
  • Sorting data
  • Finding the correct formula to use

Return on Investment

  • We have purchased the product to have in house. The upfront cost is higher than Office 365, but in the long run it is cheaper to own.
  • It has helped us to resolve inventory issues, and to see if an inventory item was missed it billing.
  • It has helped to provide a quick glance at different things we are tracking or keeping track of.

Usability

Other Software Used

CAVU

Microsoft Excel

Use Cases and Deployment Scope

Spreadsheets are essential to so many things we do. Organizing product details, department goals, schedules, etc. With tens of thousands of products from various categories at various stages of production, Excel allows us to house all that data and track important information that’s relevant to almost all our teams. The formulas and the sorting functionalities are really where it shines, I can’t imagine work without spreadsheets.

Pros

  • Summing sales data
  • Calculating percentages
  • Working collaboratively

Cons

  • Dragging and dropping
  • Easy automation
  • Aesthetic improvements

Return on Investment

  • Efficient reporting
  • Referencing multiple sheets for comparison data
  • Effective tool for data driven decision making

Usability

Alternatives Considered

Google Sheets

Other Software Used

Microsoft Teams, Adobe PhotoShop, Klaviyo

Hands down best and most powerful spreadsheet

Use Cases and Deployment Scope

I use Microsoft Excel for all accounting functions and financial reporting. It is the primary tool we use to assure accounting procedures are correctly handled. It is also the tool we use to build our annual budgets. We use Microsoft Excel on a daily basis.

Pros

  • Creates complex formulas in a simple manner
  • Makes building macros easy by recording steps
  • Automatically gives details such as totals and averages

Cons

  • More assistance on writing formulas
  • Easier conditional formatting

Return on Investment

  • It helped us make financial decisions about a second location which ultimately saved us $150,000
  • We have saved thousands of dollars by not having to outsource complex bookkeeping

Usability

Other Software Used

Microsoft 365, Araize FastFund Online, Paychex Flex

Microsoft Excel performace

Use Cases and Deployment Scope

I use it for my daily work. Doing reconciliations, VAT returns. The problem I facer with is the amount of data which with Microsoft Excel can work. I use a files which has almost 1 million rows and the saving and working is very slow. It takes a lot of time to get the job done.

Pros

  • PIVOT tables
  • VLOOKUP
  • SUMIF

Cons

  • Faster calculation
  • Better information handling
  • Better linking procedure

Return on Investment

  • Handling big data quantity

Usability

Alternatives Considered

Vertex