Tag: How to

Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: http://ift.tt/2yLoyFx
Download Full Written Notes: http://ift.tt/2y3kPPW
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (01:46) Keyboard for PivotTable
3. (04:00) Why a PivotTable is called a PivotTable
4. (04:25) Cross Tabulated Report (Adding with 2 Criteria)
5. (05:15) Calculations with Conditions or Criteria
6. (07:40) Change Calculation in Values area
7. (09:18) Drop Number or Text fields in Values area
8. (11:43) PivotTables on Large Data Set is Easy!!
9. (12:00) Keyboard to jump to bottom of column
10. (13:00) Keyboard for PivotTable on New Sheet
11. (15:30) Format PivotTable with Style
12. (16:05) Slicer to Filter who PivotTable
13. (19:24) Summary – Conclusion

PivotTable Basics, Pivot Table Basics, Learn PivotTables, Learn Pivot Tables, Lesson in Pivot Tables, How to create a PivotTable, PivotTables Are Easy! Pivot Tables Are Easy! How to Create a PivotTable Report, Pivot Table Reports

View on YouTube

Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: http://ift.tt/2yCGQtg
Download Full Written Notes: http://ift.tt/2gAVevo
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (01:22) What Excel can do: 1) Calculations, Data Analysis
3. (01:58 and 03:22) What is Data Analysis?
4. (04:00) What is a Proper Data Set?
5. (06:26) SUMIFS for Regional Sales Report, Daily Sales Report and Sales Rep Report
6. (18:32) PivotTable for Regional Sales Report, Daily Sales Report and Sales Rep Report
7. (21:31) Format PivotTable with Tabular Layout
8. (22:18) Add Number Formatting to Values area
9. (30:00) Compare SUMIFS and PivotTable
10. (32:40) Summary – Conclusion
PivotTable Basics, PivotTables 101, PivotTable Lessons, Free PivotTable Lessons, Learn PivotTables Quickly, Efficient PivotTables, PivotTables Are Easy!

View on YouTube

Mr Excel & excelisfun Trick 186: Does Text Contain Number Digits? Flash Fill, Formula or VBA?

Posted on by Annie D

Download workbook: : http://ift.tt/2xTElyv
Bill Mr Excel Jelen and Mike excelisfun Girvin show how to use Flash Fill, Formula or VBA to detect when Text cell value contains number digits. Meni Porat also has a great formula that uses COUNT, SEARCH and IF.
Topics:
2) (00:01) Dueling Song
3) (00:28) Introduction to Topic
4) (00:55) Flash Fill example (Mr Excel)
5) (02:17) Formula example using SUBSTITUTE, AND and IF Functions with an Array Constant (excelisfun)
6) (06:39) Meni Porat also has a great formula that uses COUNT, SEARCH and IF (Meni Porat)
7) (10:52) VBA Code to create UDF function (Mr Excel)
8) (11:40) Wrap up and conclusion
Excel Duel, Dueling Excel, Excel Duel 186

View on YouTube

Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: Download File: http://ift.tt/2zj989b
Download Excel Finished File: Download File: http://ift.tt/2zzfp18
Download Full Written Notes: http://ift.tt/2zlAQSq
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (00:41) Different kinds of counting and adding
3. (02:28) Function Drop-down and screen tips to learn which function to use
4. (04:05) COUNT Function
5. (05:04) COUNTA Function
6. (06:16) SUM Function
7. (06:55) COUNTIFS Function
8. (10:14) Screen Click Trick to highlight an entire argument in a function.
9. (11:04) Be Careful of Spaces!!!!!
10. (11:48) SUMIFS Functions
11. (15:05) Use Ctrl Key to check your answers
12. (15:53) More Examples
13. (19:14) Homework you can do to practice
14. (20:06) Summary – Conclusion

View on YouTube

Excel Basics 2: Introduction to Excel 2: Excel’s Golden Rule for Formulas, Formula Inputs, & Charts

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Finished File: Download File: http://ift.tt/2yvldZw
Download Full Written Notes: http://ift.tt/2x4QWzr
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (00:25) Goal of video
3. (03:07) Type labels for Net Income Projection Table and Assumption Table
4. (07:18) Add Stylistic Formatting
5. (09:00) Enter Formula Inputs
6. (09:35) Format Cells Dialog Box using Ctrl + 1
7. (13:43) Start Revenue Formula (we are not copying this formula anywhere)
8. (14:12) Revenue Increase Formula (uses Relative and Absolute Cell References):
9. (15:50) Why Percentage Revenue Increase Formula is TRUE
10. (19:26) The Beauty of Excel
11. (20:23) Expense Formula (uses Relative and Absolute Cell References)
12. (22:15) Why Expense Formula is TRUE
13. (22:30) Net Income Formula (uses two Relative Cell References)
14. (24:05) Insert Chart: Column Chart
15. (25:03) Move and Resize Chart
16. (26:12) Format Chart with Green Plus
17. (27:00) Discuss Chart Junk
18. (27:44) Delete Chart Elements
19. (28:22) Open Chart Formatting Task Pane with Ctrl + 1
20. (30:36) Link Chart Title to Cell
21. (32:56) Use Alt Key to Snap Chart to Grid
22. (32:26) Excel’s Golden Rule
23. (32:26) Use Assumption Table (Formula Input Table) to change Formula inputs and watch everything update
24. (34:26) Page Setup
25. (36:56) Summary

View on YouTube

Excel Basics 1: Introduction To Excel: Formatting, Formulas, Cell References, Page Setup

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Finished File: Download File: http://ift.tt/2kPLWg5
Download Full Written Notes: http://ift.tt/2xFJdfr
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (01:30) Excel file = “Workbook”, not “Document”
3. (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers)
4. (02:29) Cells = Intersection of Column and Row = Name or Address like B5 or A1
5. (03:46) Worksheet = Sheet = All the Cells
6. (03:55) Sheet Tab = Name of worksheet and Insert New Sheets
7. (04:18) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
8. (04:18) You can add new sheets with Plus button to the right of the sheets:
9. (05:00) Workbook = All the sheets = File = File Name
10. (05:20) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
11. (05:20) Move Cursor
12. (05:20) Fill Handle = after you select a cell the little black square in the lower right corner.
13. (05:20) Cross Hair or “Angry Rabbit” Cursor
14. (06:45) Entering data or formulas
15. (07:42) Cross Hair or “Angry Rabbit” Cursor Magic
16. (13:22) Default Alignment In Excel:
17. (14:20) Stylistic Formatting examples:
18. (17:22) Select whole table:
19. (18:35) Entering data into a large range of cells
20. (22:05) Formulas
21. (22:05) First Formula using SUM
22. (24:37) Cell References
23. (26:15) AVERAGE Function
24. (34:40) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
25. (42:30) Number Formatting
26. (47:52) Page Setup
27. (58:32) Move Sheet and Copying Sheet:
28. (01:01:47) Summary

View on YouTube

Office 2016 Video #12: Create PowerPoint Presentation With Pictures, Links and Videos

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2wAbeAk
Class web page link: http://ift.tt/2wAbeAk
Topics in this video:
1. (00:01) Introduction and Download Video, Picture and Excel Files
2. (01:25) Add PowerPoint icon to Task bar and Open PowerPoint
3. (02:30) Title Slide
4. (03:10) New Slide
5. (03:33) Slide Pane to create slides and type text
6. (05:00) Outline View to create slides and type text
7. (07:54) Different Layouts
8. (08:36) Insert Photo
9. (09:44) Insert Videos
10. (13:50) Insert Paste Special Link
11. (17:43) Themes and Variants on Design Ribbon
12. (18:21) Transitions Ribbon tab
13. (21:00) Animation Ribbon tab
14. (21:30) Slide Master
15. (27:31) Run Slide Show
16. (29:08) Different Views, including Notes View
17. (30:05) Printing and Page Setup
18. 31:35) Handout Slide Master to Adjust printing for page numbers
19. (32:46) ) Summary

View on YouTube

Office 2016 Video #11: Create Folders To Organize Your Files

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Class web page link: http://ift.tt/2wAbeAk
This video review file management using Windows Explorer. We see how to use Ctrl + Shift + N to create new folders and how to use our Ctrl & Shift selection tricks to highlight files and then we use our Mouse to click and drag to move files from one folder on a drive to a different folder on the same drive.

View on YouTube

Office 2016 Video #10: Word Styles, Table of Contents & Send to PowerPoint (Intro To PowerPoint)

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download files and notes at class web page: http://ift.tt/2wAbeAk
Topics in this video:
1. (00:01) Introduction
2. (00:27) Create a New Style so it is available in other documents
3. (06:50) Create Table of Contents using Header 1 Style
4. (11:26) Send Word Document to PowerPoint using Header 1 Style
5. (16:54) Create a Blank PowerPoint and add a Title Slide Layout, Design Theme to all slides, a Transition to all slides and start and stop the PowerPoint Presentation using keyboards
6. (21:50) Summary

View on YouTube

Office 2016 Video #08: Create Research Paper in Word

Posted on by Annie D

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2wAbeAk
Class web page link: http://ift.tt/2wAbeAk
Topics in this video:
1. (00:01) Introduction
2. (01:00) Rules for MLA Documentation Style
3. (04:19) Set MLA Style
4. (05:10) Set Margins
5. (05:50) Insert Header
6. (09:05) Insert Footer to show Page Numbers
7. (12:28) Add First Line Indent
8. (16:00) Numbered List
9. (17:00) Insert Citation for first time in document
10. (17:43) Manage Sources
11. (24:05) Insert Footnote
12. (25:15) Edit Style
13. (29:45) Insert Bibliography
14. (32:35) Find & Replace
15. (35:51) Auto Correct to create a shorthand
16. (37:53) Summary

View on YouTube

Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)

Posted on by Annie D

Download Excel File #1: http://ift.tt/2fRzTtj Download Excel File #2: http://ift.tt/2y6qjgT
Download Zipped Folder: http://ift.tt/2fQnypv
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how
Topics:
1. (00:16) Introduction
2. (00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016
3. (03:51) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report!
4. (17:06) Example #2: Transform Cross Tabulated Table into Proper Data Set
5. (21:50) Example #3: Import 1.2 Million Rows of Data from Text Files into Power Pivot and create a Data Model PivotTable, then add new data and refresh our report.
6. (22:34) Diagram to understand Data Model and Power Pivot
7. (46:46) Unhanded Exception Error.
8. (48:02) Summary

Reference Video:
Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model
https://www.youtube.com/watch?v=Jzt-I4mt8sQ

View on YouTube