Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Excel for Intermediate Users - The Complete Course. and this video is uploaded by Technology for Teachers and Students at 2023-09-18T06:45:08-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [BkvVvbqe2q4]
| Name | Excel for Intermediate Users - The Complete Course |
| Video Uploader | Video From Technology for Teachers and Students |
| Upload Date | This Video Uploaded At 18-09-2023 13:45:08 |
| Video Discription | Are you ready to go beyond the Excel basics that you already know? This video is for you! You learn how to manage a large spreadsheet, how to work with multiple worksheets, how to work with data (including grouping and importing data, and more), advanced chart skills, how to work with data lists, how to document and audit a spreadsheet, and advanced printing options. This sequel to the best, most comprehensive Excel for Beginners course will help you take your Excel learning to the next level! ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelforintermediate #excel #exceltutorials #microsoft365 #microsoftexcel Table of Contents: 00:00 - Intro 00:33 - MANAGING A LARGE SPREADSHEET 01:06 - Zoom Options 04:07 - Using Split 08:57 - Freeze Panes 11:50 - Adding, Reordering, and Naming Worksheet 14:36 - Naming Cells, Formulas, and Constants 19:31 - How to Quickly Enter Date and Time 20:40 - WORKING WITH MULTIPLE WORKSHEETS 21:23 - Editing the Same Cell in Multiple Sheets 23:26 - Opening Multiple Excel Windows 25:29 - Moving or Copying a Worksheet 27:54 - Linking Two Workbooks 30:59 - Creating a Summary Worksheet 33:22 - WORKING WITH DATA 33:38 - Grouping Data 37:24 - Importing Data into Excel 39:48 - Hyperlinking to Another File 41:44 - ADVANCED CHART SKILLS 41:59 - Creating a New Chart 45:32 - Customizing a Chart 47:36 - Adding or Editing Chart Titles 50:49 - Adding Graphics and Textboxes to Charts 54:16 - Adding WordArt to a Sheet 54:47 - Adding SmartArt Objects 56:33 - WORKING WITH DATA LISTS 57:20 - Using Data Forms to Add and Edit Records 01:03:47 - Sorting Data 01:07:30 - Filtering Data 01:10:24 - Creating a Custom Filter 01:12:29 - DOCUMENTING AND AUDITING A WORKSHEET 01:13:07 - Adding Comments and Notes 01:16:44 - Setting Up a Watch Window 01:20:27 - Other Auditing Features 01:22:21 - Error Checking 01:23:35 - ADDITIONAL PRINTING OPTIONS 01:24:13 - Changing Margins and Orientation 01:26:12 - Page Breaks and Page Break Preview 01:27:25 - Print Formulas [BkvVvbqe2q4] |
| Category | Howto & Style |
| Tags | excel intermediate | excel tips and tricks | excel formulas | excel tutorial | excel 365 | excel 2021 | microsoft excel | office 365 | excel zoom options | excel zoom | split excel | excel split | excel split panes | split panes | freeze panes | excel freeze panes | naming cells | linking excel workbooks | grouping excel data | excel filtering | excel sorting | exel tutorial | excel printing | excel for intermediate | middle excel | excel mid level | excel middle level |
