Complete Guide to Excel 365: Getting Started

Excel    |    Beginner
  • 10 videos | 1h 13m 47s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 1438 users Rating 4.6 of 1438 users (1438)
Microsoft Excel has many potential applications, offering extensive, customizable features to suit virtually all tasks and workflows. At first, Excel can be intimidating, but the benefits of knowing how to eke out every bit of this tool's productivity far outweigh the slight learning curve. In this course, you'll learn how to set up Excel, identify and choose an Excel template, locate and recognize the purpose of each primary menu item group in the Quick Access Toolbar, and apply customization to this toolbar. Next, you'll execute basic cell operations, such as copy-pasting data and inserting and deleting rows and columns. You'll and apply a range of cell formatting options, such as alignment, font, and currency formats. Finally, you'll import delimited and fixed-width data and work with Excel's Flash Fill functionality.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Launch microsoft excel, explore available templates, and customize the quick access toolbar
    Explore different menu sections within the toolbar ribbon such as page layout, formulas, data, review and view, and create a new ribbon tab
    Copy-paste data and use the format cells right-click menu option to customize number formatting, alignment, font, border, fill, and protection
    Insert and delete rows and columns, alter cell fill color and line borders, and merge cells via the home menu
  • Apply different currency formats, alter displayed number precision via the decimal point, copy-paste non-contiguous ranges, and rename sheets in an excel workbook
    Use the text import wizard to open text files with delimited columns, and open comma-separated and tab-delimited text files using the data import menu item
    Use the text import wizard to open fixed-width files containing columns of fixed character numbers, create, delete, and move column breaks, and fix data that was incorrectly imported as fixed-width when it was delimited
    Recognize flash fill as a way to fill in missing data intelligently, import a file as an excel data table, export workbooks to formats such as pdf/xps, and identify the potential for data loss when a workbook is saved as a csv file
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 59s
  • 9m 58s
    In this video, you will learn how to launch Microsoft Excel, explore available templates, and customize the Quick Access Toolbar. FREE ACCESS
  • Locked
    3.  Exploring Excel Menu Items
    7m 26s
    To explore the different menu sections within the toolbar ribbon, such as Page Layout, Formulas, Data, Review and View, and create a new ribbon tab, follow the steps below. FREE ACCESS
  • Locked
    4.  Copy-pasting Data and Formatting Cells
    8m 5s
    During this video, you will learn how to copy and paste data and use the Format Cells right-click menu option to customize number formatting, alignment, font, border, fill, and protection. FREE ACCESS
  • Locked
    5.  Inserting, Deleting, and Merging Cells
    8m 27s
    Learn how to insert and delete rows and columns, change cell fill color and line borders, and merge cells via the Home menu. FREE ACCESS
  • Locked
    6.  Applying Cell Formatting
    9m 17s
    Find out how to apply different currency formats, alter displayed number precision via the decimal point, copy and paste non-contiguous ranges, and rename sheets in an Excel workbook. FREE ACCESS
  • Locked
    7.  Importing Delimited Data
    10m 44s
    In this video, you will learn how to use the Text Import Wizard to open text files with delimited columns, and open comma-separated and tab-delimited text files using the Data import menu item. FREE ACCESS
  • Locked
    8.  Importing Fixed-width Data
    6m 51s
    During this video, you will learn how to use the Text Import Wizard to open fixed-width files containing columns of fixed character numbers, create, delete, and move column breaks, and fix data that was incorrectly imported as fixed-width when it was delimited. FREE ACCESS
  • Locked
    9.  Exporting Excel Workbooks
    9m 33s
    Upon completion of this video, you will be able to recognize Flash Fill as a way to fill in missing data intelligently, import a file as an Excel data table, export workbooks to formats such as PDF/XPS, and identify the potential for data loss when a workbook is saved as a CSV file. FREE ACCESS
  • Locked
    10.  Course Summary
    1m 27s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Referencing data in Excel 365
Rating 4.6 of 414 users Rating 4.6 of 414 users (414)
Course Formatting cells and ranges in Excel 365
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
Book Microsoft Excel In Easy Steps: Illustrated Using Excel in Office 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using conditional formulas in Excel 365
Rating 4.4 of 362 users Rating 4.4 of 362 users (362)
Course Complete Guide to Excel 365: Working With Charts & Sparklines
Rating 4.7 of 573 users Rating 4.7 of 573 users (573)
Course Collaborating effectively in Excel 365
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)