In this video I will show you how to use the functions SUMIF and SUMIFS.
These two functions will help you to add up numbers only if a specific criterion is met.
All tutorials
In this video I will show you how to improve your productivity and impress your coworkers with one trick. CTRL + E, to activate Smart filling.
This will allow you to automatically fill data on your rows when Excel senses a pattern.
In this video I will show you how to use the Data validation tools.
These group of tools will help you to reduce errors during the capturing of information.
They will also help you to limit data entries to specific pre-define values.
In this video we will explore the select special tools These tools will allow you to select specific cells when they meet a criterion and combine some of them with other tools like the shortcut CTRL + enter to create a special filling.
In this video we will explore the shapes menu from the ribbon tab, shapes can be use as text boxes, or to illustrate your presentation flow, and can be used also to remark specific areas of the slide.
In this video I will show you how to add, edit and remove transitions to the slides of your presentation.
Transitions provide a dynamic way to move from one slide to the next one during a slide show
In this video we will explore the Ribbon tab design, here we will find different predefine themes and variants, we will be able to adjust the slide size, orientation and apply background format.
we will also find a special tool, the designer wizard, where PowerPoint will offer diverse options to make our slides standout.
In this video I will show you how to use the slide transition: Morph.
This transition is the only one in PowerPoint that creates some level of animation to slide elements that are common from one slide to another.
In this video I will show you how you can use excel to calculate basis descriptive statistics measures like
Number of data points, mean, median, mode, Standard Deviation, Minimum, Maximum and Range
In this video i will give you a quick introduction to Microsoft OneNote
what is it, what can do for you and what are the working elements of the application.
In this video we will explore the slide transitions from the exciting group.
This group includes curtain, crush, wind and others.
In this video I will show you 9 quick and easy to remember keyboard shortcuts for general actions with workbooks in excel that will help you save time while you work on your spreadsheet makes you look like a pro.