Excel Basics Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-basics/ Bestselling Excel and Power BI Courses Wed, 04 Oct 2023 06:53:06 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Excel Basics Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-basics/ 32 32 Excel Formulas and Functions Everyone Needs to Know https://www.xelplus.com/excel-formulas-and-functions/ Thu, 11 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10316 Learn how to use Formulas and Functions in Excel. I'll show you an Excel trick that will make it easier to find Excel functions and use them correctly. You'll learn how to use SUM, COUNT, COUNTA, AVERAGE, MAX, MIN and also more complex functions like AVERAGEIFS.

The post Excel Formulas and Functions Everyone Needs to Know appeared first on Xelplus - Leila Gharani.

]]> Beginner’s Guide to Microsoft Excel to Get You Started Fast https://www.xelplus.com/learn-excel-beginners/ Fri, 05 Feb 2021 17:04:00 +0000 https://www.xelplus.com/?p=8952 Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. This basic tutorial is for all versions of Excel.

The post Beginner’s Guide to Microsoft Excel to Get You Started Fast appeared first on Xelplus - Leila Gharani.

]]> What Are Excel Cell Modes and What you Need to Know https://www.xelplus.com/excel-cell-modes/ Thu, 23 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11364 This Excel topic is not talked about often: Excel Cell Modes. Once you know which mode you're in: Ready, Enter, Point or Edit, it will be easier to decide whether to use the arrow keys or switch your mode first.

The post What Are Excel Cell Modes and What you Need to Know appeared first on Xelplus - Leila Gharani.

]]> How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? https://www.xelplus.com/excel-cell-references/ Sat, 01 Feb 2020 14:35:00 +0000 https://www.xelplus.com/?p=11502 Properly referencing a cell is THE most important rule you need to master in Excel. Should the reference be relative, absolute or mixed? I explain it all in this quick article.

The post How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? appeared first on Xelplus - Leila Gharani.

]]>