Tags: Courseware , Microsoft , Microsoft Office
Microsoft Office Specialist Excel 2019 Courseware
- Brand: Ascend Education
- Availability: In Stock
$49.00
This courseware covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs. Candidates are expected to demonstrate the correct application of the principal features...
This courseware covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
Candidates are expected to demonstrate the correct application of the principal features of Microsoft Excel. A basic understanding of Microsoft Excel or a spreadsheet program along with basic computers skills is a must. The ideal candidates will be those who work in an environment where MS Excel is used on a regular basis to perform office functions.
Chapter 1 Manage worksheets and workbooks
Import data into workbooks
- Import data from .txt files
- Import data from .csv files
Navigate within workbooks
- Search for data within a workbook
- Navigate to named cells, ranges, or workbook elements
- Insert and remove hyperlinks
Format worksheets and workbooks
- Modify page setup
- Adjust row height and column width
- Customize headers and footers
Chapter 2 Formulas, collaboration, and printing
Customize options and views
- Customize the Quick Access toolbar
- Display and modify workbook content in different views
- Freeze worksheet rows and columns
- Change window views
- Modify basic workbook properties
- Display formulas
- Formula practice
Configure content for collaboration
- Set a print area
- Save workbooks in alternative file formats
- Configure print settings
- Inspect workbooks for issues
Chapter 3 Manage data cells
Manipulate data in worksheets
- Paste data by using special paste options
- Fill cells by using Auto Fill
- Insert and delete multiple columns or rows
- Insert and delete cells
Format cells and ranges
- Merge and unmerge cells
- Modify cell alignment, orientation, and indentation
- Format cells by using Format Painter
- Wrap text within cells
- Apply number formats
- Apply cell formats from the Format Cells dialog box
- Apply cell styles
- Clear cell formatting
Chapter 4 Manage data ranges
Define and reference named ranges
- Define a named range
- Name a table
- Use the Excel Name Manager
- Define and use name in formulas
Summarize data visually
- Insert Sparklines
- Apply built-in conditional formatting
- Remove conditional formatting
Chapter 5 Manage tables
Create and format tables
- Create Excel tables from cell ranges
- Apply table styles
- Convert tables to cell ranges
- Format an Excel table
- Excel table compatibility issues
Chapter 6 Manage table data
Modify tables
- Add or remove table rows and columns
- Configure table style options
- Apply, create, or remove cell style
- Insert and configure total rows
Filter and sort table data
- Filter records
- Sort data by multiple columns
- Sort data in a range or table
Chapter 7 Perform operations by using formulas
Insert references
- Insert relative, absolute, and mixed references
- Reference named ranges and named tables in formulas
Calculate and transform datas
- Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
- Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
- Perform conditional operations by using the IF() function
Chapter 8 Perform operations by using functions
Format and modify text
- Format text by using RIGHT(), LEFT(), and MID() functions
- Format text by using UPPER(), LOWER(), and LEN() functions
- Format text by using the CONCAT() and TEXTJOIN() functions
- Create custom functions
- Use functions to find data in a table or range
Chapter 9 Manage charts
Create charts
- Create charts
- Create chart sheets
Modify charts
- Add data series to charts
- Switch between rows and columns in source data
- Add and modify chart elements
Format charts
- Apply chart layouts
- Apply chart styles
- Add alternative text to charts for accessibility
