cermus's channel
Loading...
-
cermus
added to a playlist
6 months ago
Microsoft Excel Tutorial for Beginners #23 - Date & Time Pt.4 - Time Calculations & Formatting
Visit MotionTraining at http://www.motiontrainingwe...
Learn how to enter and format times as well as perform common time calculations. More tut...
-
Microsoft Excel Tutorial for Beginners #22 - Date & Time Pt.3 - IF & Conditional Format
Visit MotionTraining at http://www.motiontrainingwe...
Learn how to combine date calculations with IF functions and Conditional Formatting to mak...
-
Microsoft Excel Tutorial for Beginners #21 - Date & Time Pt.2 - Date Calculations
Visit MotionTraining at http://www.motiontrainingwe...
Working with dates is essential for many Excel users. In this video learn how to perform ...
-
Microsoft Excel Tutorial for Beginners #20 - Date & Time Pt.1 - Custom Format
Visit MotionTraining at http://www.motiontrainingwe...
Working with dates is essential for many Excel users. In this video learn how to format y...
-
Microsoft Excel Tutorial for Beginners #19 - COUNTIF and SUMIF Functions
Visit MotionTraining at http://www.motiontrainingwe...
A look at two very useful functions for automating your spreadsheets, COUNTIF and SUMIF.
...
-
Microsoft Excel Tutorial for Beginners #18 - Nested 'IF' Functions Pt.2
Visit MotionTraining at http://www.motiontrainingwe...
Another look at the useful 'Nested IF' function. In this tutorial learn how to order the ...
-
Microsoft Excel Tutorial for Beginners #17 - Using Nested 'IF' Functions
Visit MotionTraining at http://www.motiontrainingwe...
Learn how to extend the IF Function to include more than one question (or logical test) in...
-
Microsoft Excel Tutorial for Beginners #16 - Using The 'IF' Function
Visit MotionTraining at http://www.motiontrainingwe...
Learn how to use the IF Function. This is a very useful Excel function that can make your...
-
-
cermus
added to a playlist
6 months ago
Microsoft Excel Tutorial for Beginners #15 - Percentages - More Examples
Visit MotionTraining at http://www.motiontrainingwe...
This video contains more examples of percentage calculations. Hope these are useful to you.
-
Microsoft Excel Tutorial for Beginners #14 - Percentages and Absolute References
Visit MotionTraining at http://www.motiontrainingwe...
Learn how to calculate percentage values and also how to incorporate absolute cell referen...
-
Microsoft Excel Tutorial for Beginners #13 - Updating Calculations
Visit MotionTraining at http://www.motiontrainingwe...
In this update to the beginners series you will learn how to update calculations linked to...
-
Microsoft Excel Tutorial for Beginners #12 - Printing
Visit MotionTraining at http://www.motiontrainingwe...
A look at the basics of printing in Excel. Learn how to position and resize objects on yo...
-
Microsoft Excel Tutorial for Beginners #11 - Charts Pt.3
Visit MotionTraining at http://www.motiontrainingwe...
Create a Pie Chart using the Excel Chart Wizard and learn how to format the completed char...
-
Microsoft Excel Tutorial for Beginners #10 - Charts Pt.2
Visit MotionTraining at http://www.motiontrainingwe...
Find out how to update your charts when new data is added to the spreadsheet and how to re...
-
Microsoft Excel Tutorial for Beginners #9 - Charts Pt.1
Visit MotionTraining at http://www.motiontrainingwe...
In this tutorial, looking at Excel charts, learn how to create and format a simple column ...
-
Microsoft Excel Tutorial for Beginners #8 - Formatting Pt.3
Visit MotionTraining at http://www.motiontrainingwe...
Learn how to combine conditional formatting with Excel functions.
-
-
cermus
added to a playlist
6 months ago
Microsoft Excel Tutorial for Beginners #7 - Formatting Pt.2
The guide to Excel formatting continues with a look at changing text colour, border styles, print preview and an introduction to Conditional Format...
-
Microsoft Excel Tutorial for Beginners #6 - Formatting Pt.1
This is the first of 2 videos looking at formatting. Effective formatting will add a professional look to your spreadsheets. In this video learn ...
-
Microsoft Excel Tutorial for Beginners #5 - Number Formats
Visit MotionTraining at http://www.motiontrainingwe...
Tutorial #5 shows how to do basic number formatting using the toolbar or menu options. Th...
-
Microsoft Excel Tutorial for Beginners #4 - Functions (Formulas)
Visit MotionTraining at http://www.motiontrainingwe...
Continuing the Microsoft Excel series of tutorials for beginners. In part 4 you will lear...
-
Microsoft Excel Tutorial for Beginners #3 - Calculations (Formulas)
Visit MotionTraining at http://www.motiontrainingwe...
Tutorial #3 introduces calculations and explains the basic mathematical operators in Micro...
-
Microsoft Excel Tutorial for Beginners #2 - Get Started
Visit MotionTraining at http://www.motiontrainingwe...
This video covers a number of basics including entering data, editing data, changing colum...
-
Microsoft Excel Tutorial for Beginners #1 - Overview
Visit MotionTraining at http://www.motiontrainingwe...
A quick look at setting up a simple spreadsheet in Excel complete with a chart. More tuto...
-
