Description
Learn how to use and work with Excel 365 from Microsoft Office. This is a in-depth beginner class and part one of 3 courses Beginner, Intermediate and Advanced. This course covers new features of Excel 365, Starting up and working with Excel, Creating new workbooks, Organizing your worksheet, Basic formulas, Using templates and themes, and a downloadable Test Quiz is included with enclosed answer key. This Excel 365 class is taught by a Microsoft Certified Professional and Comptia A+ Computer expert. He has been the President and owner of a computer repair, networking and software company for the past 20 years. He has 3 college degrees in computers which include computer science, programming, networking and GIS. He has programmed, designed, and created professional software programs. He has helped and taught over 3,000 clients how to use Microsoft computer software, hardware and peripherals. In this beginner course we will go over the following: Chapter 1: New Features for 365OverviewHow Excel is different from older versionsWhat is new in Excel 365How new features are added365 using Office and Excel365 in the CloudExample of a Excel wookbook/worksheetChapter 2: Starting up ExcelOverviewOpening up a workbook and worksheetThe Excel ScreenDifference between a workbook, worksheet and spreadsheetcells, gridlines, entering data, sheet tabsThe Title bar, Quick access tool bar and nameboxFile tab, backstage minitool barCustomizing and using the Ribbon and KeyTipsFinding and replacing data, undo/redo, copy and paste, selecting cellsscrolling, adjusting columns, rowsinserting and deleting rows and columns, adjusting cellsUsing AutofillUsing CommentsThe file, view tab, workbook window, status barzoom sliderfont styles and effectsChapter 3: Creating new workbooksOverviewEntering text, numbers and datesEditing dataMore on Editing dataDesigning borders and backgroundsopening and saving workbooksexcel file formatsusing conditional formattingChapter 4: Organizing your worksheetOverviewFreeze panesSplit panescreating, renaming hiding, unhiding worksheetsFormat PainterAlignment and wrap textFormatting numbers and datescopying and moving worksheetshiding and unhiding rows and columnscopying and pasting data numbers, using paste specialChapter 5: Basic FormulasOverviewFormulas and functionsCreating basic formulasSum a column of numbers, autosumcopying a formula to other cellssimple formula syntaxinserting functionsauto calculateadd, subtract, multiply and divide cellsediting a range of cellsChapter 6: Using a TemplateOverviewCreating and using templatesApplying styles and themesConclusionDownloadable Test Quiz is included with answer key.
