Microsoft Excel 2021 & 365: Level 1 covers key introductory Excel
skills. Among others, topics in Level 1 include entering, editing, and
formatting entries; selecting cells and ranges; creating and modifying
basic formulas; inserting charts and tables; creating a template; and
sorting and filtering data. Textbook included. Pre-requisites: Basic
computer skills. Course Objectives By the end of this course, you will
be able to: ? Describe similarities and differences between Office
2019 for the desktop, Office 365, and Office Online ? Identify parts
of the Office user interface ? Use the spelling checker and other
review features ? Use the Office Clipboard ? Format text in Office
applications ? Search for Help within Office applications ? Enter data
into a worksheet ? Format a worksheet ? Apply number and date formats
? Enter a series of related data ? Adjust the view with Zoom tools ?
Use formulas to perform calculations ? Rearrange data on a worksheet ?
Manage multiple worksheets ? Create formulas with functions ? Use
relative and absolute cell references in formulas ? Define names for
cells and ranges ? Use names in formulas ? Insert charts ? Move and
size charts ? Edit chart data ? Add images to a worksheet ? Apply
conditional formatting ? Create a template ? Start a workbook from a
template ? Sort and filter data ? Create IF functions ? Use the Scale
to Fit printing options ? Create and modify tables ? Much, much more!
courses
775
Views
13/10/2023 Last update