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
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
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
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
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
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
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
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 – 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 – 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 – 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 – 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
Free Excel Help – SQRT Function

Basic Description of the SQRT Function in Microsoft Excel The SQRT function in Microsoft Excel computes the positive square root of a given numeric value. The formula of the SQRTR function is: =SQRT (number) In this formula, the number argument is the number in which you want to calculate the square root of. This argument […]

Read More
Free Excel Help – PI Function

Pi is a constant used in mathematics whose value is the ratio of the circumference of a circle to its diameter. This mathematical constant is approximately equivalent to 3.14159 in the normal decimal positional notation. There are lots of formulas in engineering, science and mathematics which involve Pi. Because of this, Pi is one of […]

Read More
Free Excel Help – POWER Function

The Basics of the POWER Function in Microsoft Excel The POWER functions in Microsoft Excel computes a given numerical value raise to a supplied exponent or power. The formula of the POWER function is: POWER (number, power) In this formula, the power and number arguments are number values. These arguments can be entered in the […]

Read More
Free Excel Help – AutoFilter

Have you ever used a Microsoft Excel AutoFilter? If not have you at least heard of it? No, well let me give you a quick overview of the Excel AutoFilter. The Excel AutoFilter allows you to filter and sort records based on one or more criteria. You do so using a simple interface, a drop-down […]

Read More