In this video I will show you different methods to identify and delete duplicated records from a spreadsheet.
We will use conditional formatting, the concat function, and the remove duplicates tool.
All tutorials
In this video i will show you different ways to compare individual cells or a list of values using the functions IF, CONCAT and XLOOKUP
In this video I will show you some of the most common errors when working with the excel function XLOOKUP and will show you how to fix them.
In this video I will give a quick introduction to Microsoft Word, what is it, what can do for you and some of the most basic elements of the application.
If you are new to Word, this is a great place to start.
In this video we will explore the Microsoft Word Ribbon tab, I consider this to be the most important working element in Word because it contains most of the controls and commands to create and edit your document.
In this video I will show you how to create your first document in MS Word, and how to apply basic format to your document, like setting the font type, size, color, and style, and how to create bullet points.
If you are new to word this is a great place to start.
In this video we will explore the Ribbon tab INSERT from the Word application, in this tab we will find the groups of commands for all the different elements that we can use in a document like tables, pictures, shapes, files and more.
In this video I will show you how create a basic table of contents in ms word, using the paragraph styles such as Normal, and headings.
In this video I will show you how to create a basic procedure from scratch in ms word, assign numbering headings, and creating indented numbering for individual sections.
In this video I will show you how you can create a document template in Ms Word. With templates you will reduce setup time, and you can concentrate on creating the content.
In this video I will show you how to customize your Pivot Tables with the value fields settings, this offers additional calculations you can do with values, and if that is not enough you can create your own calculated fields and calculated items
In this video I will show you an example on how you can summarize your PivotTables only using Calculated items, this will give full control of customization for your pivot table . If you are not familiar with this type of items, I recommend you watching my video how to create calculated fields and items.