MO-200: Microsoft Excel Associate
MO-200: Microsoft Excel Associate
75 hours
275 €
E-learning
Description of the course
Unleash your potential in Excel 2019 with this official Microsoft course and become an expert in data analysis, creating impactful reports, and optimizing your productivity. This official Microsoft course is designed with a practical, results-oriented methodology. We'll provide you with the tools and knowledge necessary to master the advanced features of Excel 2019. This will allow you to become an expert in data management and analysis, optimizing your productivity in your professional or academic fields, and preparing you to obtain the official Microsoft Office Specialist: Excel Associate 2019 certification.
Profile of Access
This course is designed for students who wish to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting, including styles. Students will demonstrate the correct application of Excel 2019's core features by creating and editing two- or three-page documents for a variety of purposes and situations.
Objectives of the Course
✓ Master advanced formulas to perform complex data analysis and gain valuable insights that will help you make strategic decisions in your professional or academic field.
✓ Create dynamic lists to efficiently filter, sort, and analyze large data sets, saving time and effort.
✓ Design impactful graphics and formats to communicate your results in a visually compelling way and capture your audience's attention.
✓ Learn how to use custom styles to optimize the presentation of your spreadsheets and create professional documents that reflect your personal brand.
✓ Automate repetitive tasks with macros and scripts to save time and effort, freeing yourself from tedious tasks and increasing your productivity.
Contents of the Course
MODULE 1. Introducing Excel
- Using the ribbon.
- Enter text.
- Enter numbers.
- Enter dates.
- Save books.
- Create a new book.
- Switch between books.
- Close a book.
- Working with compatibility mode.
- Select cells.
MODULE 2. Building cell data
- Edit cells and undo changes.
- Cut, copy and paste data.
- Use Paste Special.
- Copy and move cells using the mouse.
- Insert and delete cells.
- Adjust columns and rows.
- Hide and show rows and columns.
- Use AutoFill and Flash Fill.
- Rename spreadsheets.
- Move or copy spreadsheets.
- Hide or show spreadsheets.
- Add color to spreadsheet tabs.
MODULE 3. Using formulas
- Mathematical operators.
- Referencing other spreadsheets.
- Use the SUM function.
- Using statistical functions.
- Use the IF function.
- Use text functions.
- Use relative, absolute, and mixed cell references.
- Show formulas.
MODULE 4. Formatting the worksheet
- Format numbers and decimal digits.
- Change cell alignment.
- Changing fonts and sizes.
- Apply cell borders.
- Use colors and patterns.
- Use format paint.
- Clear cell contents and formatting.
- Using cell styles.
- Conditional formatting.
- Remove conditional formatting.
MODULE 5. View and print books
- Create and organize spreadsheet windows.
- Split panels.
- Immobilize panels.
- Change the zoom.
- Change book views.
- Configure page breaks.
- Page setup options.
- Add a Header or Footer.
- Print titles and cell ranges.
- Print selected spreadsheets.
MODULE 6. Working with graphics
- Create a basic chart.
- Move and resize graphics.
- Change chart types.
- Working with pie charts.
- Modify the layout and location of the chart.
- Add new data series.
- Use mini charts.
- Print graphics.
- Use the Quick Scan tool.
MODULE 7. Organize data
- Create named ranges.
- Modify and delete named ranges.
- Go to a named cell or range.
- Create a table.
- Modify the table data.
- Format table data.
- Convert a table to a range of cells.
- Sort data by multiple levels.
- Filter information.
MODULE 8. Using data tools
- Customize the Quick Access Toolbar.
- Replace data.
- Modify and delete hyperlinks.
- Access the properties of a book.
- Import data files from external text files.
- Import data from external CSV files.
- Export data from Excel as CSV.
- Using the Document Inspector.
- Use the Accessibility Checker tool.
CERTIFICATIONS:
Microsoft Excel Assocciate
