Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Column Chart in Excel
  • Chart Axes in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to sum a total in multiple Excel tables
  • Number and Text Filters Examples in Excel

References

  • How to get first column number in range in Excel
  • How to get address of last cell in range in Excel
  • To count total rows in a range in Excel
  • How to get first row number in range in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation must contain specific text
  • Excel Data validation exists in list
  • Excel Data validation date in next 30 days
  • Excel Data validation number multiple 100

Excel Tutorials at a Glance

Nowadays, many jobs require basic Excel skills

Based on millions of  job listings ranging from  Administrative Assistant, Financial Analyst, Cost Estimator, Information Clerk, Sales Manager, Accountants, Auditors and more on various recruitment sites, there has been a marked increase in the demand for baseline computer skills especially basic Excel. Excel is a massive application with  thousands of features and hundreds of  commands. It is very easy to get lost once you open Excel. So one of the basic survival skills is to understand how to navigate Excel and access the features you are looking for. xlsoffice.com got you covered starting from Basic Excel skills to Advanced.

Introduction to Microsoft Office Excel tutorials for users with zero knowledge.

Get familiar with Excel ribbons and the User Interface (UI).

Ribbon is the name given to the row of tabs and buttons you see at the top of a Excel workbook. The Ribbon is segmented into groups that holds multiple commands  in specific categories.

Range: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

Formulas and Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. Learn to calculate simple arithmetic operators in Excel such as Sum, Average, Minimum, Maximum, Count and more.

Sort & Filter: Learn to arrange data in ascending or descending order in Excel using sort. Then filter your Excel data if you only want to display records that meet certain criteria.

Workbook: A workbook is another word for your Excel file which comprises of one or more worksheet. When you start Excel, click Blank workbook to create an Excel workbook from scratch.

Worksheets: A worksheet is a collection of cells where you keep and manipulate the data.

Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.

Format Number: simply refers to how numbers are entered in Excel (that is data pattern or data type).  e.g percentage, currency and more.

Find & Select: Learn how to use Excel’s Find, Replace and Go To Special feature.

Templates: Templates are predefined structure/ format that can be reused by users over again. Excel comes with many free templates available, waiting to be used.

Charts: A simple chart helps to understand voluminous data in Excel than a sheet full of numbers. Learn all about how to create Column Chart | Line Chart | Pie Chart | Bar Chart

Print: This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.

Share: Learn how to share Excel data with Word documents and other files.

Protect: Learn to encrypt an Excel file with a password so that it requires a password to open it.

Keyboard Shortcuts: Excel shortcut keys allow you to do things with your keyboard instead of your mouse to increase your speed.

Data Validation: Use data validation in Excel to prevent invalid data from being entered into a cell.

USE EXCEL PRODUCTIVELY: It is not enough to know various features of Excel.  As a beginner, it helps to know how to use Excel productively. This includes knowing important keyboard shortcuts, mouse shortcuts, work-around, Function Keys f1 – f12 , Excel customizations & how to make everything looks slick.

Excel Functions

Discover how Formulas and Functions in Excel help you save time. Learn all about Excel Functions such as;

  • Cube Functions
  • Database Functions
  • Date and Time Functions
  • Engineering Functions
  • Financial Functions
  • Information Functions
  • Logical Functions
  • Lookup and Reference Functions
  • Math and Trig Functions
  • Statistical Functions
  • Text Functions
  • Web Functions

  • Charts
  • Data Analysis
  • Data Validation
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • AND function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • Excel If, Nested If, And/Or Criteria Examples
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel

Date Time

  • How to get year from date in Excel
  • Get month from date in Excel
  • Check If Two Dates are same month in Excel
  • Convert decimal minutes to Excel time
  • How to get Weekdays, Working days between Two Dates in Excel

Grouping

  • Map inputs to arbitrary values in Excel
  • Calculate conditional mode with criteria in Excel
  • Running count group by n size in Excel
  • If cell contains one of many things in Excel
  • Group numbers at uneven intervals in Excel

General

  • How to get amount with percentage in Excel
  • Convert column number to letter in Excel
  • How to Create Calendar in Excel
  • Find Most Frequently Occurring Word in Excel Worksheet
  • How to generate random number weighted probability in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning