Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Count rows that contain specific values in Excel
  • How to use Excel TRANSPOSE Function
  • How to get last row in mixed data with blanks in Excel
  • Vlookup Examples in Excel
  • How to use Excel ROWS Function

Data Analysis Examples

  • How to calculate average last N values in a table in Excel
  • How to sum a total in multiple Excel tables
  • How To Filter Data in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • Create Scatter Chart in Excel

Data Validation Examples

  • Data validation must not exist in list
  • Excel Data validation specific characters only
  • Excel Data validation require unique number
  • Excel Data validation allow weekday only
  • Excel Data validation must contain specific text

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

  • Remove line breaks in a cell in Excel
  • UNICHAR function: Description, Usage, Syntax, Examples and Explanation
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • Remove text by variable position in a cell in Excel
  • Find most frequent text within a range with criteria in Excel
  • Get week number from date in Excel
  • Calculate total hours that fall between two times in Excel
  • WORKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Calculate date overlap in days in Excel
  • How to get number of days, weeks, months or years between two dates in Excel
  • Calculate interest rate for loan in Excel
  • COUPPCD function: Description, Usage, Syntax, Examples and Explanation
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • DB function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles