Microsoft Excel is the most powerful tool for managing and analyzing various types of data. This free online Excel course is aimed at beginners as it covers detailed lessons to learn Excel quickly and easily. In the course you will learn how to use Excel formulas, tables and charts to manage business processes from small to large scale.
Do I need to have knowledge of Excel? The answer is a resounding no. This Free Online Excel Course / Tutorial for Beginners will help you learn all the basics of Excel. Once you have finished the course, you will have all the knowledge you need to make the most of this powerful spreadsheet tool.
Free online Excel course content
INTRODUCTION
- Introduction to Microsoft Excel and its spreadsheets
- Benefits of Excel in the cloud and Office 365 Cloud
- How to add a title line in an Excel spreadsheet?
TABLES
- How to add or delete columns and rows in a table in Excel
- How to name a table in Microsoft Excel
- How to create a dunamic table in Microsoft Excel
- Calculate percentage changes with Excel dynamic tables
- How to create slicers in Microsoft Excel
- How to delete a dynamic table in Microsoft Excel
MOST USED FUNCTIONS IN EXCEL
- The difference between functions and formulas in Excel
- Basic Excel functions you should know
- What are Excel functions and which one should you know by heart?
- Everything you should know about logical functions in Excel
- How to use the MODE function in Microsoft Excel?
- How to use the YEAR function in Excel
- How to insert today’s date in Microsoft Excel
- How to use the ISODD function in Microsoft Excel?
- How to use the IMSUB function in Microsoft Excel
- How to use the COUNT function in Microsoft Excel
- How to use the COUNTIF or COUNT.IF formula in Microsoft Excel
- How to count the number of unique and distinct values in Excel?
- How to calculate standard deviation and error of the mean in Excel
- Microsoft Excel can hide values and measures. Here we tell you how
- Everything you should know about logical functions in Excel
- Excel VLOOKUP function: how to use it
- How to calculate standard deviation and error of the mean in Excel
- Microsoft Excel can hide values and measures. Here we tell you how
- How to Use the STDEV (Standard Deviation) Function in Excel
COLUMNS
IMPORTS AND CONVERSIONS IN EXCEL
- How to convert DBF to Excel (XLSX or XLS) on Windows 10?
- Learn how to import PDF data to Excel with PDF Data Connector
- How to import CSV (text) data to Excel?
- How to import data from MS Access to Excel?
- Import XML, Access or SQL database data to Excel
- How to export an HTML table to Excel with JavaScript?
- Learn how to link an Excel spreadsheet in PowerPoint
- How to save Excel files to OneDrive automatically?
- How to Find Links to Other Workbooks in Microsoft Excel
GRAPHICS IN EXCEL
- Tutorial to insert sparklines in Excel
- How to create graphs in Excel step by step?
- Make a chart in Excel in the easiest way
- Advanced Tables and Graphs in Excel with Simple Steps
- How to Overlay Charts in Microsoft Excel
- How to make a scatter plot in Excel?
- How to make a Gantt chart in Excel?
TROUBLESHOOTING MICROSOFT EXCEL
- 5 common problems in Excel, and how to solve them
- How to repair a damaged or corrupt Excel file
- How to open a Numbers file in Excel
- How to fix arrow keys not working in Excel?
- How to use error checking in Excel and Google Sheets
- Fix: Error with external references in Excel. Can’t unlink
- How to fix runtime error 1004 in Excel?
- Fix when Microsoft Excel consumes a lot of CPU in Windows 10
- Solutions to Excel flickering issue
- Fix: Save button greyed out in Word, Excel and PowerPoint
PROTECTIONS AND SECURITY IN MICROSOFT EXCEL
CELLS
- Learn how to apply text and number formatting to cells in Excel
- Split cells in Excel with the “Text to Columns” function
- Excel: How to cross reference cells?
- How to lock cells in Microsoft Excel
- How to merge and unmerge cells in Excel?
- How to copy and paste visible cells in Microsoft Excel
- How to start a new line in a cell in Microsoft Excel
- How to Strikethrough Text in Microsoft Excel
- How to rotate text in Excel easily?
- Tutorial to skew and rotate text in Excel
- How to manage conditional formatting rules in Excel
- How to Darken Grid Lines in Microsoft Excel
- How to count cells with text in Excel
- How to Truncate Text in Excel
FORMULAS IN EXCEL
- Get started with formulas in Microsoft Excel
- How to add, subtract, multiply and divide in Excel
- How to divide numbers in Microsoft Excel
- Learn to use exponents or powers in Excel in a simple way
- How to Calculate Average in Microsoft Excel
- How to Evaluate Formulas in Microsoft Excel
DATA IN EXCEL
- How to Combine Spreadsheet Data in Excel
- Data validation in Excel, filters and grouping
- How to use the automatic data type function in Excel
- How to fill sequential data in Excel?
- How to rename a data series in Excel?
- This will prevent Excel from rounding numbers in spreadsheets
- Learn to highlight higher or lower values in Excel
- How can you remove smart tags in Excel?
WORK FASTER IN EXCEL
- Excel: how to save time with your themes
- All the best Microsoft Excel keyboard shortcuts
- Excel sheets for free accounting
- Learn how to use Excel split screen mode!
PRACTICAL EXAMPLES IN MICROSOFT EXCEL
- How to create income and expense spreadsheet with Excel
- Excel sheets for free accounting
- Set a print area in an Excel spreadsheet
- How to align printed pages in Excel?
- Know how to remove the background of an image in Excel
- How to Add Line Breaks in Microsoft Excel
- The 80 Best Free Excel Templates for Freelancers and Freelancers
- How to calculate the payment, interest or term of a loan in Excel
- How to Get Currency Exchange Rates in Microsoft Excel