In this video I will show you how to use the Basic date-time functions like:
Today, Now, Year, Month, Day, Hour, Minute and Date.
All tutorials
In this video we will explore the information functions, like:
ISBLANK, ISFORMULA, ISNUMBER, ISTEXT, ISERROR.
These functions let you check the status of a cell and its content, they are normally used in combination with the logical functions, especially with the function IF creating a nested function.
In this video I will show you how to use the freeze pane tool and the split window tool.
These are very important to the able to maintain a reference point of the data we are analyzing.
In this video we will talk about Pivot Tables, we will go over what PivotTables are, how they look like and then I will show you how to create PivotTables using the Excel’s automated tool and what you can do with them.
In this video I will show you how to create a PivotTable manually by placing the fields on the PivotTable framework, this will give you total control over the creation of your PivotTable.
In this video I will show you how to create a more elaborated PivotTable with different levels of information, make changes to the value settings, and others useful techniques to analyze your data.
If you are not familiar with PivotTables, I recommend you watch my video “What is a PivotTable, and how to create one with the automated tool” before watching this video.
In this video we will explore the Lookup family functions. Lookup, VLookup, HLookup and XLookup
These group of functions are very popular in Excel because they will help you retrieve information from a reference table or range.
I will show you how do they work and how to use the functions.
In this video I will give you a quick introduction to Microsoft Power Point, what is It, what can do for you, and what are the working elements of the application.
In this video we will explore the PowerPoint ribbon, I consider this to be the most important working element in PowerPoint as it contains most of the controls and commands for the presentation.
In this video I will show you how to insert and edit some of the most basic visual elements to a single slide: text boxes, pictures, shapes;
And how to add, edit and remove slides.
In this video we will explore the Text Boxes, they are the most basic elements in PowerPoint but at the same time the most used, I will say 95% of PowerPoint presentations have at minimum 1 text box, to either introduce the Topic of the presentation or to describe another visual element.
In this video we will explore the copy-paste special tools.
You may think there nothing special about copy and paste!
Well, I can assure You, you are probably missing out some good tricks.