The History of Microsoft Access

The Story of Microsoft Access   According to Wikipedia, “Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold […]

Read More
Electrosonic

A New Microsoft Excel Client and Their Unique Need   We had a company call us with a request to document their Excel files. The person that wrote them, formulas and macros, left.   We documented two file consisting of over 20 sheets and 1,000 lines of VBA code by producing a 10 page PDF. […]

Read More
Next to Staples PepsiCo is our most active repeat client

Next to Staples, PepsiCo is our most active repeat client   We have had the opportunity and pleasure to have worked/work with PepsiCo on multiple simultaneously projects with several divisions (R&D, Beverages), only having more work with Staples. For Staples we have completed over 650 projects and counting. Sure, many of those are smaller projects, […]

Read More
How to Use Microsoft Access 2019 to Improve Efficiency

How to Use Microsoft Access 2019 to Improve Efficiency   Find out more about Microsoft Access and learn how the Excel Consultant team can use its functions to develop databases that enhance efficiency   Read Gregg’s complete post here: With Office 2019 Currently Pending release, is this perhaps the perfect time to update your version […]

Read More
How Small Businesses Use Microsoft Excel

How Small Businesses Use Microsoft Excel   For those that are familiar with business, the number one desktop productivity tool of choice is Microsoft Excel, it’s hard to imagine life without it. Microsoft Excel is a spreadsheet tool that is used in millions of large businesses across the world and provides tremendous value to small […]

Read More
What Makes Excel Consultant Different from Discount Contractors on Freelancer Websites

What Makes Excel Consultant’s Dedicated Staff Different from Discount Contractors on Freelancer Websites   Discount Freelancer Website contractors’ are most often simply the lowest bidders, the low end of the consulting services market, unqualified, unreliable, not guaranteed. Find out what sets Excel Consultant’s Microsoft masters apart; “The Smarter Microsoft Solutions Provider”.   Discount low quality […]

Read More
Solutions: Custom Commercial Microsoft Solutions

We Build Custom Commercial Microsoft Solutions For Our Clients   Excel Consultant explains the growing field of custom commercial applications, their numerous advantages, and our successes with their custom Microsoft development       Excel Consultant’s team of Microsoft custom solution experts is committing to helping our clients maximize their potential with this essential suite […]

Read More
400th Microsoft Programming Project for Staples Completed

Excel Consultant Completes 400th project with Staples!   Most business owners have heard of the business supplies store, Staples. Staples is one of a handful of very similar stores. Office this, Office that, etc. Staples is the leading company in this space, an their success can be attributed to their ability to know what the […]

Read More
Measuring Your Success with Microsoft Power BI (Power Pivot)

Practical Problem Solving with Microsoft Power BI: Measuring Your Success   How well is your business doing? You can probably provide a general answer (“excellent,” “could be better,” “needs some help,” “growing quickly,” etc.) but how do you know? How do you measure success? Do the business tools you are using providing the answers in […]

Read More
Should You Hire A Local or Remote Microsoft Consultant?

Should You Hire A Local or Remote Microsoft Excel, Access & Power BI Consultant?   Excel Consultant describes the differences between local and remote Microsoft Excel, Access and Power BI consulting, highlighting the many benefits our team of specialists offers.   Remote, or local: that is the question. It may not be the original Shakespearean […]

Read More
Don’t Let This Happen To You

Don’t Let This Happen To You       Don’t Do It – Don’t Be The Upset Client On The Phone To Where? Make Sure You Know How To Hire The Right Corporation To Assist You   #1 – What you read below comes from an ongoing conversation with a new client. It is one […]

Read More
Optimizing Your Business Performance with Our Microsoft MVPs

Optimizing Your Business Performance with Our Team of Microsoft MVPs   Microsoft is just one of our clients to benefit from the Microsoft Most Valued Professional program and the Excel and Access MVPs on our staff over the past few decades.   What exactly is a Microsoft MVP and how can the accomplished Microsoft solution […]

Read More
Practical Problem Solving with Microsoft Power BI: Presentation Preparation

Practical Problem Solving with Microsoft Power BI: Presentation Preparation   Excel Consultant’s expert team explains how Microsoft Power BI (Business Intelligence) software can help you give more accurate, attractive presentations.   Imagine you’ve been selected to give a pivotal presentation to your shareholders, prospective partners, the press, or another important audience. Under all this pressure, […]

Read More
Excel Consultant’s Microsoft Experts Manhattan Office

  Excel Consultant’s Microsoft Experts Manhattan Office   Socially, culturally, and economically, Manhattan is one of the major metropolitan areas on planet Earth. Famous author, E.B. White, even called it the “Capital of the World.” According to United States History, the region “is now worth more than $60 billion.” It should come as no surprise […]

Read More
Practical Problem-Solving with Microsoft Power BI: Making Data Accessible

Practical Problem-Solving with Microsoft Power BI: Making Data Accessible   As most executives and managers know, information fuels an enterprise. Without client data, product specifications, inventory sheets, account ledgers, sales projections, and other crucial data sets, your business simply couldn’t function. These are, in many respects, your most valuable assets, since they allow you to […]

Read More
What We Do For the Local Southern California Community

What We Do For the Local Southern California Community   For the past 25 years Excel and Access, LLC has been committed to assisting local non-profit organizations, educational institutions, and governments in our SoCal community   We Are Committed To Serving Our Local Community At Excel and Access, LLC our team of Microsoft masters is […]

Read More
Introduction to Practical Problem-Solving with Microsoft Power BI

Introduction to Practical Problem-Solving with Microsoft Power BI   In this twenty-first century of business, we’ve come to expect that computerized technology will be the panacea for our problems. Well, the good news is that, in virtually every case, it is! Disorganized? There’s an Excel spreadsheet for that! Need information at your fingertips? There’s a […]

Read More
Microsoft Excel 2016 for Mac Versus Excel 2011 for Mac

Excel 2016 for Mac Versus Excel 2011 for Mac: The Inside Scoop from Excel Experts   It’s a common computerized conundrum: the latest software is out, but is it what you want? Is it something IT will approve and support? Should you switch from your reliable, existing program to the flashy, new, exciting, and supposedly […]

Read More
How Businesses Become More Productive Using Microsoft Excel

How Businesses Become More Productive Using Microsoft Excel   Said another way, How Do Businesses “Excel Efficiently“   Fact: Did you know that 60% of the Excel 2013 templates that come within Microsoft Excel were done by our company. Yes, several of our Microsoft Excel MVP’s worked on our organization’s project for Microsoft. Some project! […]

Read More
Constructing Custom CRMs with Microsoft VBA

Constructing Custom CRMs with Microsoft VBA   ♦ We recently published a handful of blog posts centered around Microsoft VBA (Visual Basic for Applications, aka macros) and how the various Microsoft desktop productivity applications that make up Microsoft Office can use this code to get the maximum power and ease of use out of the […]

Read More
Integration and Automation with Microsoft’s VBA

Integration and Automation with Microsoft’s VBA   If you want to get the most out of your Microsoft desktop productivity tools, such as Excel, Access, and Microsoft’s Power BI you will need to maximize both integration and automation with Microsoft’s VBA. VBA is the glue that binds the various Microsoft Office applications, in addition to […]

Read More
Making Microsoft’s Vision a Reality

Making Microsoft’s Vision a Reality We’ve revealed Microsoft’s vision of integration and automation for its suite of software in our earlier post (Making Microsoft’s Vision a Reality). Find out how Excel Consultant fulfills this imagined future.   In our previous post, we revealed Microsoft’s true vision for its products: a seamless, unified system of software […]

Read More
What You Might Not Know About Microsoft’s Vision

What You Might Not Know About Microsoft’s Vision It’s absolutely undeniable: Microsoft is a company of mammoth proportions. What You Might Not Know About Microsoft’s Vision is what Microsoft the powerhouse it is today. It’s a household name throughout the United States and even in the global marketplace. It is also how we at Excel […]

Read More
Excel University Graduate Certification

Excel University Graduate Certification       Do you work in Microsoft Excel? Do you want to be better at it? CPA or not, learning Excel allows you to do more, in less time and effort, with Microsoft Excel. And good for you, our business associate knows Excel like a seasoned Excel programmer, he is […]

Read More
Why Our Two Decades Of Microsoft Certification Matter

Why Having Over Two Decades Of Microsoft Certification Matter So Much In This Industry   In an industry where we making our living assisting clients with their Microsoft applications, such as Excel, Access, Office, SQL Server and Power BI, having that Microsoft Certification for an amazing 23 consecutive years is that much more meaningful than […]

Read More
Yes, We Work With Educational Institutions (Colleges)

Yes, we work with dozens of Educational Institutions (Colleges) across the country   Last week we received a phone call from a university that was looking for a professional Microsoft Excel consulting services firm to help them with their Microsoft Excel applications. They were specifically looking to hire an Excel consultancy that had experience working […]

Read More
Our Microsoft MVPs

A Look Back at Our Microsoft MVP’s Work Over the years our clients have had the opportunity to work with the numerous Microsoft MVPs that have been a major component of our team of Microsoft Excel and Access experts. Their contributions have lead to our raising the bar in our niche and have been nothing […]

Read More
The Story of Microsoft Excel

The Story of Excel Today, only talk of an electronic spreadsheet and Microsoft Excel quickly comes to mind. You wonder whatever happened to Lotus 123 and other products that once seemed to rival Microsoft Excel. In its current format, Microsoft Excel 2016 (Both Windows & the Mac), delivers a game changing relational database via Microsoft’s […]

Read More
Microsoft Excel 2016 Pivot Tables

What is a Microsoft Excel Pivot Table? According to the Microsoft website: “A PivotTable report is useful to summarize, analyze, explore, and present summary data. Pivot Tables enable you to make informed decisions about critical data in your enterprise.”   Who uses Pivot Tables? Literally anyone who has been exposed to them, because once you have […]

Read More
Meet Our Team: Jacob

Name: Jacob Hildebrand. Position: Premier Developer – Senior Excel, Access, SQL Server, Word, Outlook, VB.Net Developer     Bio: Jacob is one of our most prolific, powerful programmers at Excel Consultant. He is one of the core members of our outstanding team, and for good reason. After attending Mesa Verde High School in Citrus Heights, […]

Read More
Microsoft Office 2019 Training

Microsoft Office 2019 is out, learn how to use it like a pro. Microsoft Office 2019 Training   ♦  Let the Microsoft Certified Excel and Access experts at the Excel & Access, LLC group of companies be be your single go-to resource for all of your Microsoft Office Training needs as well as your Microsoft database […]

Read More
Our Team: Meet Stan B.

Name: Stan B. Position: Senior Access Consultant, Project Manager, Senior Access Trainer Bio: Excel Consultant is delighted to have Stan B. as a member of our team. While he is a multitalented Microsoft master, his prowess lies particularly in Access, the relational database management system. Those with the proper skills can use this powerful tool to […]

Read More
Our Team: Meet Paul Delke

Name: Paul Delke Position: Senior Project Manager and Programmer (Irvine Office) Bio: Paul Delke has been a spreadsheet specialist for the past three decades. Since 1989, he has served as President of Automated PC Systems, Incorporated. As an independent consultant, he provides software solutions to major corporate clients using spreadsheets from Lotus and Excel. He joined […]

Read More
Expand Your Excel Knowledge with VBA Express

Microsoft Experts At Excel Consultant, our team of expert instructors, programmers, and advisers is passionate about helping individuals and businesses harness the power of Microsoft technology. Many people merely skim the surface of what programs like Excel can accomplish, never realizing how useful they could truly be. Our cutting-edge consultants have devoted themselves to learning everything […]

Read More
Our Team: Meet Dennis Taylor

Name: Dennis Taylor Position: Senior Excel Trainer (PC and Mac Cross-Platform Expertise) Bio: Simply put, Dennis Taylor is an Excel expert. He has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990s. He’s traveled the United States and Canada giving seminars to help his students unlock the full potential of Excel (so far, […]

Read More
Our Team: Meet Helen Feddema

Name: Helen Feddema Position: Senior Access, Word, Outlook, and Excel Developer Bio: Helen is a New York City native who has been dedicated to digital software for nearly as long as it’s existed. While she waited for computer technology to catch up with her coding skills, Helen passed her time as an Ivy League student. She […]

Read More
Office 2016 is Here! How Excel Consultant Can Help

Today is an exciting day for the Microsoft community! Office 2016 is making its big debut. This release is the first major update Word, Excel, PowerPoint, and other applications since Microsoft launched Office 2013 over two years ago. At Excel Consultant, we understand that figuring out how to implement new programs can be both exciting […]

Read More
Joseph Carrier, CTO and Project Manager, Promotion

Excel Consultant’s business is booming. Our team currently helps companies, organizations, and institutions throughout the United States, Canada, Europe, and Australia leverage Microsoft tools to their advantage. Our experienced programmers, instructors, and consultants use their expertise to design customized, sophisticated solutions that help businesses succeed in the digital age. As our company expands, we rely […]

Read More
What is a Microsoft Certified Partner?

At Excel Consultant, we are committed to helping your business, organization, or institution leverage the power of Microsoft products to your advantage. Our experts maintain an in-depth knowledge of these tools and use their expertise to design customized solutions to suit your needs. To keep up with the latest software developments and establish our credentials […]

Read More
What is a Microsoft MVP?

When you bring specialists onto your project or into your office, you want to know you’re working with the best. In a technical field like Microsoft programming, it can be difficult for executives and project managers to tell which consultants really know their stuff. When you work with a Microsoft MVP (Most Valuable Professional), you […]

Read More
Free Excel Help – Chart Titles

There are many features available in Microsoft Excel that could help you in making your presentations come to life. One of the features is that you can make use of are Microsoft Excel charts and graphs, which help you when it comes to presenting large amounts of numerical data. There are a lot of choices […]

Read More
Free Excel Help – Data Types

What you enter in a Microsoft Excel spreadsheets is read by the program as general data, text, or numeric data. But there are limitations to each, and you obviously have to suit your own needs and preferences while using Microsoft Excel. The cell data type can be interpreted by Microsoft in different ways: numeric, general […]

Read More
Free Excel Help – Named Ranges Vlookups

For those new to Microsoft Excel the Excel VLOOKUP can initially be difficult to understand, yet it is so useful that it is a requirement for anyone that wants to be an Excel consultant or financial analyst must master it. As you probably already know, Microsoft Excel is a powerful spreadsheet application that contains numerous […]

Read More
Free Excel Help – Slicers

Dealing with massive amounts of data on your Microsoft Excel 2010 worksheets can be really messy. Particularly when you want to select some values for financial analysis and skip other entries, the job can be really frustrating. In a long spreadsheet, one with hundreds of thousands of rows, where the entries to be skipped from […]

Read More
Free Excel Help – Power Pivot Tables

Through Microsoft Excel’s 2010 PowerPivot (Power Pivot) service application you give meaning to your data recorded in your Microsoft Excel worksheets. With Excel’s PowerPivot you can stay connected as a group and get help in running your business smoothly and keep an eye on the progress throughout, no matter how much data you have.  Creating […]

Read More
Free Excel Help – Macros

Tired of repeating the same manual operations while managing data? It is very understandable. Repeating the very same action again and again, day in and day out, can be very frustrating not to mention expensive.  Excel spreadsheets can be managed effectively, repeating tasks and getting frustrated can be successfully prevented in Microsoft Excel using Macros. […]

Read More
Free Excel Help – If Statements

Microsoft Excel If functions are very useful in the flexibility and decision making aspects of your spreadsheets. It helps in generating and in testing if the data or the state of your spreadsheet is true or false. The function will carry out an action if the condition or state of your spreadsheet is true or […]

Read More
Free Excel Help – Named Ranges

Dynamic named ranges are one of the strongest aspects of Excel. It is commonly used in listing the controls, PivotTables, and charts. First thing is to formulate a list in column of A of your worksheet. Before anything else, there are still problems that could surface such as the updating or redefining of the named […]

Read More
Free Excel Help – Arrays

A variable which has is a similar type but holds a different value is what an array means. It is used in almost every programming language which can also be mixed or paired to different variables for a simple or more complicated structure of data. Due to the property of an array that it holds […]

Read More
Free Excel Help – Updating Pivot Tables

A Pivot Table is very useful in visually deriving meaning from data. It is also very helpful in analyzing the relationships between the data’s columns and the rows. Manipulation of data, viewing of data in different perspectives, and other data related actions can be done in the Pivot Table, dynamically. After creating the Pivot Table […]

Read More
Microsoft Excel Pivot Tables

Microsoft Excel Pivot Tables are used in the user’s spreadsheet to present quantitative data in an easy and user-friendly manner to allow the user to quickly analyze large amounts of data. To manipulate data in an Excel PivotTable it must have data that is capable of being able to be categorized or grouped. To create […]

Read More
Free Excel Help – DGET Function (Part 2)

This free Excel help article on the Microsoft Excel DGET function is a part 2, or continuation of the article, Excel DGET function. Please read the first article so that you may understand the DGET function better and then follow up with this one. In the previous free Excel help article you learned how to […]

Read More
Free Excel Help – Pivot Tables Data

In Microsoft Excel, Pivot Tables are interactive tables allowing the user to summarize and group numbers of data in a tabular concise format for easy analysis and reporting. Excel Pivot Tables aim is to count, total and sort the data, thus, this table is also available in Microsoft Access. It was originally called Pivot Tables […]

Read More
Free Excel Help – Keyboard Shortcuts

Free Excel help article on Microsoft Excel keyboard shortcuts. Navigating within a worksheet Keyboard shortcut                                          Action Tab, ->                                                             Skips to the next cell on the right Shft+Tab, <-                                                    Skips to the cell on the left ?                                                                     Move one cell up. ?                                                                     Move one cell down. Ctrl+->                                                             Move to the last occupied cell of a row of data Ctrl+<-                                                             Move to the […]

Read More
Free Excel Help – Keyboard Shortcuts For Business

For most people, when it is your first time to work with Microsoft Excel, you will concentrate on just completing your task rather than learning how to work efficiently for a faster completion of your task. That can usually be said for any software application. However, when you are ready to learn about the keyboard […]

Read More
Free Excel Help – XNPV Function

Microsoft Excel is one of the leading analytical software tools available in the international market and is widely used by Excel consultants, financial and analytical firms as well as small business for calculating and analyzing data. Microsoft Excel is known for its ease of use and sheer power. Most importantly, it possesses a wide array […]

Read More
Free Excel Help – XIRR Function

The Microsoft Excel XIRR function is a modified version of the IRR function, wherein one can also calculate internal rate of return even if the cash flow does not happen regularly. The Excel IRR function is only for calculating internal rate of return when there is a periodic flow of cash, and thus the XIRR […]

Read More
Free Excel Help – SumProduct Function

The Microsoft Excel application is one of the global leaders when it comes to financial computing and analyzing data, from an Excel consultant and financial analyst point of view at least. This iconic piece of software, ever since it was released by Microsoft, has been a the first choice among all the major business organizations […]

Read More
Free Excel Help – SumIf Function

The Microsoft Excel application is one of the greatest programs that Microsoft has ever been able to create and without a doubt a software without which you just can’t do without if you are an Excel consultant. Because of its easy to use and learn implementation, Excel has become hugely popular all over the world […]

Read More
Free Excel Help – RoundDown Function

For all the analysis that is being done by the Excel consultants at the major as well as small-scale business firms all around, Microsoft Excel is the primary tool used by almost all of them. It is known for its very easy to use features. Without a doubt, the best feature in Microsoft Excel is […]

Read More
Free Excel Help – PV Function

The Microsoft Excel Present Value (PV) Function is used to determine the current status of an investment. This is calculated keeping in mind a constant interest rate within a constant payment schedule. his is an evaluation mechanism that is put to use keeping in mind a future payment that is due. The current value here […]

Read More
Free Excel Help – PPMT Function

The Microsoft Excel PPMT function is a tool that calculates the payment on a basic amount during a defined period of time. The amount may be upon a loan or just an investment in some business that is supposed to return a value at a pre-settled interest rate. The payment that is to be made […]

Read More
Free Excel Help – Date Function

In this free Excel help article we will look at some more of the Microsoft Excel date functions. To this list we will also add some of the Microsoft Excel time functions too as they both go hand-in-hand. EOMONTH  – The function stands for End Of the Month. It is a very useful Excel function […]

Read More
Free Excel Help – Dates Functions

In this free Excel help article we’ll look at some of the Microsoft Excel’s Date functions. The format of the date used in our article is mm/dd/yyy but this of course can be changed in Microsoft Excel. TODAY – This is a function that does not take in any arguments.  Used in a cell as […]

Read More
Free Excel Help – DVAR Function

The DVAR function is one of several database functions available in MS Excel. If you are not an Excel consultant, but rather a business users, you might be wondering how a Microsoft function in Excel is being called a database function when Microsoft Excel is only a worksheet and not an actual database, such as […]

Read More
Free Excel Help – DSTDEV Function

The DSTDEV function is one of the database functions in Microsoft Excel. You might be asking yourself how a function in Excel is being called a database function when Excel is only a spreadsheet and not a database, such as Microsoft Access. We’ll see that in a moment. As the name suggests DSTDEV or Database […]

Read More
Free Excel Help – DPRODUCT Function

The DPRODUCT function is one of several database functions in Microsoft Excel. You might be wondering how a function in Excel is being called a database function when Excel is only a spreadsheet. We’ll see that in a moment. As the name suggests DPRODUCT or Database Product multiplies numeric field values in a column. This […]

Read More
Free Excel Help – DGET Function (Part 1)

You might recall in an earlier free Excel help article we wrote where we discussed about the Microsoft Excel VLOOKUP function how we explained fetching data from one worksheet into another.  In this article we’ll look at another function that fetches data, the DGET function. The DGET function is one of the several database functions […]

Read More
Free Excel Help – Median Function

Microsoft Excel has been one of Microsoft’s iconic releases and even many years have passed since it first came into being but its popularity has only increased. Excel provides us with the power of tabulating and evaluating data of all sorts and types with main focus given to the operation asked for by the business […]

Read More
Free Excel Help – Max Function

Microsoft Excel is the most preferred data analysis tool in the market today. All the major analytical firms and business organizations have long back started using Excel as their major financial tool and it is no surprise that such a thing has happened. If you are an Excel consultant you live in Excel. If you […]

Read More
Free Excel Help – IRR Function

The Microsoft Office Suite has a wide range of software that is essential for any business to run properly and one such application in the suite is Microsoft Excel. Excel is the dominant spreadsheet application and business tool that almost every firm uses nowadays. Because of its easy to use features and host of functions […]

Read More
Free Excel Help – NPV Function

Microsoft Excel has been one of the most used applications in the Microsoft Office Suite and over the years has developed not just as a vital tool for Excel consultants and office workers but also for all data-related activity that is possible both at home, and business. So, with Excel there lies the power of […]

Read More
Free Excel Help – COUNTIF Function

The Microsoft Office Suite has a wide range of efficient and relevant software that is essential for any business to run properly and one such application in the Suite is Microsoft Excel. Excel is the widely preferred data business analysis and reporting tool that almost every firm uses nowadays. Because of its easy to use […]

Read More
Free Excel Help – CountBlank Function

Microsoft Excel is one of the global leaders when it comes to financial computing and analyzing data. This iconic piece of software, ever since it got released from Microsoft, has been a firm favorite among all the major business organizations in the world for their day to day computing purposes. Excel has got a massive […]

Read More
Free Excel Help – COUNTA Function

COUNTA is a function available in Microsoft Excel that is used during counting of the numbers in a series of cells. This function is implemented to calculate the number of cells that are not empty within a selected range. When you supply a set of values within cells that block is taken to be occupied. […]

Read More
Free Excel Help – AVERAGE Function

Microsoft Excel is one of the leading analytical tools available in the market, and is the most used spreadsheet application in the world, being widely used by financial and analytical firms as well as students for calculating and analyzing data. Excel is known for its simple nature and high affectivity. Because of its easy to […]

Read More
Free Excel Help ISERROR Function

  If you are an experienced Excel consultant you know what this free Excel help article covers. If you are a small business owner looking for help on this topic, it means that you might have not come across this before. So exactly what is the problem and what does this article cover? A cell […]

Read More
Free Excel Help – Subtotal Function

Among the functions that are featured in Microsoft Excel, the SUBTOTAL function is probably the most versatile. This function can be used for different purposes unlike the other Excel functions which can only do one thing. The SUBTOTAL function in Microsoft Excel is employed to get the subtotal of a given array of cells. The […]

Read More
Free Excel Help – SUMSQ Function

Microsoft Excel features built-in functions that have the ability to perform calculations. These mathematical functions are useful especially to Excel consultants. You can perform different mathematical operations with the use of these Excel’s functions. While there lots of functions in Excel, this free Excel help article will provide a detailed discussion of the SUMSQ function. […]

Read More
Free Excel Help – TAN Function

Microsoft Excel is a spreadsheet that is used by business to manage data. By default, when you create a new Excel workbook the workbook will contain three worksheets. Sheet is a shortened name for a worksheet or spreadsheet in Excel. A worksheet is comprised of a grid or table composed of columns and rows making […]

Read More
Free Excel Help – TANH Function

  Microsoft Excel is a software program used to develop, create and organize data using the spreadsheet or worksheet interface. Excel users and businesses often use it to deal with calculating, organizing, graphing and formatting data. Microsoft Excel has basic features, which are used for organizing data and for data management. Excel is also used […]

Read More
Free Excel Help – TRUNC Function

If you work in business you should know what Microsoft Excel is. Microsoft Excel is a spreadsheet application produced by the Microsoft Corporation. It allows businesses and its users to calculate, format and organize data using formulas and functions. Excel is part of the Office Suite, thus, it is compatible with other software applications in […]

Read More
Free Excel Help – Data Consolidation

For our example let us consider several Microsoft Excel worksheets say for the various months from January till December containing sales data spread across an array of cells ranging from B5 to E16. Now suppose we wish to do a sum function just on only the data for the months of January and February, i.e. […]

Read More
Free Excel Help – Advanced Functions

The Microsoft Excel function we’ll learn in this Excel help article is the RANDBETWEEN function. So what does the RANDBETWEEN function do? RANDBETWEEN generates random numbers between a range of numbers. This Excel function is very useful if you want to generate numeric data in a spreadsheet for testing purposes.  The syntax of the function […]

Read More