Excel Tutorials at a Glance

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;