Excel for Intermediate Users - The Complete Course скачать в хорошем качестве

Excel for Intermediate Users - The Complete Course

Are you ready to go beyond the Excel basics that you already know? This video is for you! You'll 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***:   / 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