Office tutorials, tips and tricks
In this Excel tutorial, we’ll see why and how to freeze a row in Excel, how to freeze a column in Excel, how to freeze multiple rows and columns, and of course how to unlock frozen rows and columns if we don’t need anymore the locked display of information.
In this Word tutorial, we’ll learn how to change the case in Word: meaning, how to change the case from uppercase to lowercase, from lowercase to uppercase, toggle case, and capitalize each word like for titles.
In this Excel tutorial, we’ll learn how to sort data in Excel using the simple sort command (how to sort text, numbers, or dates), as well as how to sort multiple columns, how to sort by color, and how to sort by rows using the custom sort.
This tutorial about cell format types in Excel is an essential part of your learning of Excel and will definitely do a lot of good to you in your future use of this software, as a lot of tasks in Excel sheets are based on cells format, as well as several errors are due to a bad implementation of it.
This tutorial is an Excel tutorial for beginners covering all the basic features of this software. It will enable you to master Excel basics, quickly and efficiently.
You will learn how to use the Excel interface; how to create and save a workbook; how to manage Excel sheets; how to enter, edit, and format data; how to manage rows, columns, and cells; how to format cells; how to use formulas and functions; how to sort and filter data; how to create and edit charts; how to print a sheet or part of it; how to hide the ribbon, how to convert an Excel sheet to PDF; and how to customize the Quick Access Toolbar.
After this tutorial, you will no longer remain a beginner in Excel.
In this tutorial on how to filter data in Excel, we will see how to apply a filter on an Excel spreadsheet, how to use its different options, how to clear a filter for a specific column or for all columns, and how to remove the filter from all the spreadsheet.
In this tutorial, we will see different methods of how to sum in Excel using the AutoSum tool and the SUM function.
In this tutorial, we will talk about Excel formulas and functions. Precisely, how to create or insert a formula, how to edit it, how to use functions in a formula, how to copy a formula down a column or along a row, and how to show formulas in Excel.
The cover page is the front cover of your Word document, which can contain, among other things, the document title, the author, a brief description, the date, a background or an image.
In this tutorial, we will see how to create cover pages in Word documents, as well as how to insert, modify, and remove them.