- 28
- 90 433
Eric's Office Tips
Canada
เข้าร่วมเมื่อ 7 ต.ค. 2014
This channel shows you short videos about tips in using Excel, Word, PowerPoint and other office productivity software and tools. Enjoy!
The videos are provided as is. The channel does not provide support on the tools discussed in the videos. Thanks!
#Tips #Tutorial #Word #Excel #PowerPoint #Project #MicrosoftOffice #Office #HowTo #Windows
The videos are provided as is. The channel does not provide support on the tools discussed in the videos. Thanks!
#Tips #Tutorial #Word #Excel #PowerPoint #Project #MicrosoftOffice #Office #HowTo #Windows
Using Goal Seek in Excel
This video discusses how to use the What-If analysis tool called Goal Seek in Excel. Goal seek allows you to make adjustments to a value that provides input to a formula by specifying a desired value or result for that formula.
มุมมอง: 112
วีดีโอ
Using the VLOOKUP Function Lesson 2
มุมมอง 753 ปีที่แล้ว
In this video, you will learn how to use the VLOOKUP function with a table array that is found in a separate worksheet.
Using the VLOOKUP function Lesson 1
มุมมอง 1003 ปีที่แล้ว
This video introduces you in using the VLOOKUP function in Excel.
Cell and number formatting
มุมมอง 823 ปีที่แล้ว
This is a quick lesson on how to apply formatting to your cells and numbers in Excel. We'll also take a look at some custom date formats.
Printing an Excel spreadsheet
มุมมอง 773 ปีที่แล้ว
Learn the techniques in adjusting the print settings of your Excel worksheet before printing it.
Using the PMT Function
มุมมอง 1093 ปีที่แล้ว
The video discusses how to use PMT function to calculate for regular / periodic payments made to a loan given the loan amount, interest and the duration or number of periods of payment.
Using Slicers in pivot tables
มุมมอง 843 ปีที่แล้ว
Learn how to use slicers in pivot tables to easily filter your data. Slicers offer a "visual" way to filter your data in pivot tables.
Getting started with Excel charts
มุมมอง 663 ปีที่แล้ว
This video gives some pointers on how to create and edit charts in Excel.
Inserting pivot tables
มุมมอง 1123 ปีที่แล้ว
This video is a simple discussion on how to use pivot tables in Excel to create summaries of your data, and easily change layouts of your summaries.
Using Excel formulas
มุมมอง 1163 ปีที่แล้ว
This video shows you how to use Excel formulas by using mathematical symbols, and also by using functions like SUM and AVERAGE.
Inserting Page Breaks and Section Breaks in Word
มุมมอง 49K4 ปีที่แล้ว
Learn the difference between page breaks and section breaks in Word.
Using Conditional Formatting in Excel
มุมมอง 1535 ปีที่แล้ว
This video discusses how you can use the basic features of conditional formatting in Excel.
Repeat a Table's Header Row Across Pages in Word
มุมมอง 19K5 ปีที่แล้ว
This video shows you how to make the header of a table repeat across pages in Word. This is useful for tables that cover several pages in a document.
Applying Simple Animation in PowerPoint
มุมมอง 1125 ปีที่แล้ว
In this video, we'll learn how to apply some simple animation on slide objects like shapes and text. We'll also learn how to run the slide show to see the animation.
Excel keyboard shortcut to speed up repetitive data entry
มุมมอง 3115 ปีที่แล้ว
Excel keyboard shortcut to speed up repetitive data entry
Using formulas or functions in Word tables
มุมมอง 1.1K5 ปีที่แล้ว
Using formulas or functions in Word tables
Using slide master to apply a custom slide background
มุมมอง 1.2K5 ปีที่แล้ว
Using slide master to apply a custom slide background
Shortcuts to insert the current date and time in Excel and Word
มุมมอง 4026 ปีที่แล้ว
Shortcuts to insert the current date and time in Excel and Word
Quickly change the case of text in Word
มุมมอง 6206 ปีที่แล้ว
Quickly change the case of text in Word
Using the F11 key to create a chart in Excel
มุมมอง 1.3K6 ปีที่แล้ว
Using the F11 key to create a chart in Excel
Thank you, Thank you! It was fantastic.
Glad it was helpful!
Thank you for posting. Very helpful.
It's brilliant. If I saw this in time, I wouldn't fail the class and wouldn't have to watch it now for second attempt :DDD
very nice video. thanks a lot.
You're awesome! Thanks!
Very good video. I watched the other videos for the same topic and I cannot understand. This video makes it clear for me. Thank you.
Best video to clarify this issue, thanks alot.