Home Search Profile
TrainingHub TrainingHub

Ultimate Excel Mastery: Essential Workbook Skills 2024

Focused View

1:33:31

  • 1 -Introduction.mp4
    00:43
  • 2 -Exercise Files.mp4
    00:25
  • 1 -Creating Workbooks.mp4
    02:34
  • 2 -Adding a Worksheet to an Existing Workbook.mp4
    02:06
  • 3 -Copying and Moving a Worksheet.mp4
    04:41
  • 3 -Filters.xlsx
  • 4 -Archived Orders.xlsx
  • 4 -Importing Data From a Text Delimited File.mp4
    04:37
  • 4 -Orders.txt
  • 5 -Monthly Profit.txt
  • 5 - Section Review Creating and Managing Workbooks and Worksheets.html
  • 5 - Test Your Skills Creating and Managing Workbooks and Worksheets.html
  • 1 -Searching.xlsx
  • 1 -Searching for Data.mp4
    04:13
  • 2 -Navigating a Named Cell.xlsx
  • 2 -Navigating to a Named Cell, Range, or Element.mp4
    05:08
  • 3 -Hyperlinks.xlsx
  • 3 -Inserting and Removing Hyperlinks.mp4
    07:37
  • 4 -Test Your Skills - Navigation.xlsx
  • 4 - Section Review Navigating in Workbooks and Worksheets.html
  • 4 - Test Your Skills Navigating in Workbooks and Worksheets.html
  • 1 -Changing Worksheet Tab Color.mp4
    01:33
  • 2 -Modifying the Page Setup.mp4
    02:41
  • 2 -Page Setup.xlsx
  • 2 - Renaming Worksheets.html
  • 3 -Inserting Columns and Rows.xlsx
  • 3 -Inserting, and Deleting Columns and Rows.mp4
    04:42
  • 4 -Changing Workbook Themes.mp4
    03:51
  • 4 -Themes.xlsx
  • 5 -Adjusting Row Height, and Column Width.mp4
    04:37
  • 6 -Inserting Headers, and Footers.mp4
    08:15
  • 7 -Test Your Skills - Formatting Workbooks and Worksheets.xlsx
  • 7 - Section Review Formatting Workbooks and Worksheets.html
  • 7 - Test Your Skills Formatting Workbooks and Worksheets.html
  • 1 -Hiding Columns and Rows.xlsx
  • 1 -Hiding or Unhiding Columns and Rows.mp4
    03:01
  • 1 - Hiding or Unhiding Worksheets.html
  • 2 -Customizing the Quick Access Toolbar.mp4
    06:37
  • 3 -Changing Workbook Views.mp4
    01:02
  • 4 -Changing Window Views.mp4
    06:45
  • 4 -Workbook Views.xlsx
  • 5 -Changing Magnification.mp4
    01:27
  • 6 -Modifying Workbook Properties.mp4
    03:26
  • 7 -Test Your Skills - Customizing Options and Views for Workbooks and Worksheets.xlsx
  • 7 - Displaying Formulas.html
  • 7 - Section Review Customizing Options and Views for Workbooks and Worksheets.html
  • 7 - Test Your Skills Customizing Options and Views for Workbooks and Worksheets.html
  • 1 -Print Area.xlsx
  • 1 -Setting Print Areas.mp4
    02:07
  • 2 -Printing All or Part of a Workbook.mp4
    02:24
  • 2 -Workbook Views.xlsx
  • 3 -Setting the Print Scale.mp4
    02:54
  • 3 -Workbook Views.xlsx
  • 4 -Repeating Row Column Headings.xlsx
  • 4 -Repeating Row and Column Headings.mp4
    02:00
  • 5 -Inspecting Workbooks for Hidden Properties, Accessibility, and Compatibility.mp4
    03:43
  • 5 - Saving Workbooks as Other Formats.html
  • 6 -Test Your Skills - Configuring Workbooks for Distribution.xlsx
  • 6 - Section Review Configuring Workbooks for Distribution.html
  • 6 - Test Your Skills Configuring Workbooks for Distribution.html
  • 1 -Test Your Skills - Sections 2 - 6.txt
  • 1 -Test Your Skills - Sections 2 - 6.xlsx
  • 1 - Test Your Skills.html
  • 1 -Thank You & Next Steps.mp4
    00:22
  • 2 - [BONUS LECTURE].html
    •

    More details

    Course Overview

    Master core Excel workbook skills from creation to distribution in this hands-on course designed to boost your productivity and professional formatting abilities.

    What You'll Learn

    • Create, organize, and format professional workbooks
    • Import and manage data from external sources
    • Configure workbooks for optimal printing and distribution

    Who This Is For

    • Excel beginners starting their productivity journey
    • Professionals needing to improve workbook management
    • Students and small business owners handling data

    Key Benefits

    • No prior Excel experience required
    • Practical skills for immediate workplace application
    • Master workbook organization and navigation

    Curriculum Highlights

    1. Workbook creation and worksheet management
    2. Data import and workbook navigation
    3. Professional formatting and distribution