5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

IT Professional Curricula     Enterprise Database Systems Solution Area     Data Visualization     A Complete and Comprehensive Guide to Excel

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.



Objectives

Complete Guide to Excel 365: Getting Started

  • 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