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

Data Analysis

  • How to do a t-Test in Excel?
  • How To Insert and Customize Sparklines in Excel
  • How to Create Area Chart in Excel
  • Add Outline to Data in Excel
  • Get column index in Excel Table

References

  • How to get address of last cell in range in Excel
  • Extract all partial matches in Excel
  • Two-column Lookup in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to use Excel OFFSET function

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation date in next 30 days
  • Excel Data validation require unique number
  • Excel Data validation unique values only
  • Excel Data validation allow weekday only

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

  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Extract multiple matches into separate rows in Excel
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Get date from day number in Excel
  • Calculate days remaining in Excel
  • Convert Excel time to decimal minutes
  • Add workdays to date custom weekends in Excel
  • Convert text date dd/mm/yy to mm/dd/yy in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to generate random date between two dates in Excel
  • How to calculate percentage of total in Excel
  • How to calculate profit margin percentage in Excel
  • How to get random value from list or table in Excel
  • How to calculate percent of goal in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning