Microsoft Excel 2019 Basic Advanced Expert (Office Elearning Menu)

Introductie

We extend a warm welcome to you to embark upon a transformative journey with the distinguished Excel 365 Course: Basics, Intermediate, and Advanced E-Learning. We highly value your interest in enhancing your proficiency in Excel, and we are delighted to guide you through this enriching experience.

Omschrijving

t is with great pride that we introduce the Excel 365 Course: Basics, Intermediate, and Advanced E-Learning. This meticulously crafted curriculum empowers you to navigate through the intricacies of Excel, from fundamental functionalities to advanced expertise. By completing this course, you will attain comprehensive mastery, enabling you to harness the full potential of Excel's features. Essential themes encompass data entry, formatting, calculations ranging from simple to intricate, graphing, efficient management of extensive datasets, pivot tables, and various advanced features.

As you advance through the Intermediate and Advanced segments, you will delve deeper into Excel's intricate capabilities. These lessons will not only introduce you to novel functionalities but also empower you to utilize existing ones more effectively, thereby enhancing your proficiency.

Target Audience

This course is tailored for individuals who possess a foundational understanding of Excel and aspire to refine their skills. We extend a cordial invitation to beginners seeking to fortify their grasp of Excel's foundational elements, and to those seeking to ascend the ladder of mastery to become adept intermediates and experts.

Content of the training

This module offers you an interactive training, consisting of 45 teaching videos, 45 assignments and5 files with additional information.

Introduction to Excel, fill in a table

• What you need to know about: Spreadsheets
• Open workbooks
• General working environment
• Move in workbook
• What you need to know about: Input Help
• Enter data
• What you need to know about: Select, copy and move
• Select and clear cells
• Cancel and restore operation
• Column width/row height
• What you need to know about: Saving files
• Save workbooks
• Adjust cell contents
• Create new workbook

Make your first calculations

• Enter formulas
• Sum and other simple calculations
• Calculate percentage
• Copy to adjacent cells

Take care of the formatting of your data

• Simple number formats
• Apply theme
• Character format
• Font and size
• Align Cell Contents
• Cell color
• Cell borders

Print and set page layout your worksheets

• Page layout
• Print preview and printing
• Page break
• Print Range
• What you need to know about: Header and Footer
• Header and Footer

Work more efficiently with Excel

• Using Excel Help
• Spell check
• Find and replace
• Zoom in and out
• Insert or delete rows, columns, and cells
• Move cells
• Copy to non-adjacent cells
• Quick copy cell formatting
• Merge cells
• Cell contents orientation
• Cell Styles
• Sort a table

Manage the worksheets

• Worksheet name and tab color
• Insert, delete worksheets and set background
• Move, copy, and hide worksheets
• Block column/row, split screen
• Print column and row titles repeatedly
• Hide items on worksheet
• Group data in overview

This module offers you an interactive training, consisting of 60 teaching videos, 60 assignments and5 files with additional information.

Evolving into complicated tables

• Show multiple lines in cell
• An absolute reference in formula
• Copy, transpose calculation results and links
• What you need to know about: Entering functions
• System date and date format
• Simple condition
• Custom format
• Apply a conditional format
• Manage conditional formatting
• Cell Range Name
• Validation criterion
• Cell ranges in functions

Present your figures in graph form

• What you need to know about: Charts
• Create and move a chart
• Manage a chart
• Select chart elements
• Add or remove chart elements
• Formatting chart elements
• Change Chart Text Elements
• Legend and Artboard
• Print a chart and page layout

Improve the layout of your charts

• Change data labels
• Data series and chart axes
• Manage sequences
• Chart Type Options
• Manage chart templates
• Create a 2D map chart
• Create a sparkline chart
• Manage Sparklines

Beautify your tables

• Create a graphic object
• Select and delete objects
• Copy and move objects
• Determine graphic object size
• Change a text box
• Edit a shape
• Formatting drawing objects
• Insert an image
• Manage images
• Rotate and align objects
• Overlap and group objects

Take advantage of your data lists

• Calculating Subtotals
• Create and manage a data table
• Displaying and sorting data from a data table
• Add calculation to a data table
• Automatic filtering
• Custom filters
• Empty and duplicate values
• What you need to know about: Criteria ranges
• Filter by criteria range
• Filter and copy rows with criteria range
• Criteria Range Calculations

Create and use pivot tables and charts

• What you need to know about: PivotTables and Charts
• Create pivot table
• Modify a pivot table and add calculations
• Change the source of a pivot table
• Select, copy, move, and delete a pivot table
• PivotTable Structure and Printing
• Layout of a pivot table
• Filtering a pivot table
• Filtering using slicers
• Basing a PivotTable on Multiple Data Tables
• Add fields or calculated elements
• Group data
• Create a pivot chart

This module offers you an interactive training, consisting of 42 teaching videos, 42 assignments and5 files with additional information.

Work even more efficiently

• Convert data
• What you need to know about: Auto-Fast Fill
• Using data series
• Custom Views
• Note to cell
• Error checking
• Evaluate Formulas
• Control window

Use advanced function calculations

• Search table and functions
• Text functions
• Calculate time
• Calculate dates
• Conditions with AND, OR, NOT
• Some conditions
• Conditional Functions
• Array Formula
• Calculations with copies
• To merge
• Financial functions
• Double Entry Table

Discover new functionalities

• Goal Seeking
• Solver
• Scenario management
• Hyperlink
• What you need to know about: Styles and Templates
• Create and customize a theme
• Create and use a template
• What you need to know about: Import, export and interoperability
• Editing and Deleting a Template
• Transfer Excel data: PDF, XPS, email and web page
• Convert Excel files
• Import data
• Update and manage imported data
• Workbook properties

Share workbooks in a safe way

• Security workbook
• Protect cells
• Share a workbook
• Track workbook changes
• Merge workbooks
• Completion of a workbook
• Digital signature
• Create a form
• Securing and using a form

To learn more about it…

• Macro command
• Restore versions and files
• What you need to know about: Customizing the ribbon
• What you need to know about: Good Spreadsheet Habits
• What you need to know about: Collaborate on a workbook

Office 2019: CasesExcel, Word or PowerPoint with an Office 365 subscriptionThis module offers you a video with a length of 20 minutes.

• An e-mail message from Office with or without an Office 365 subscription: what are the differences?
• Create and save Office documents on OneDrive, SharePoint Online or Teams
• Edit a document from OneDrive, SharePoint, or Teams
• Share Office documents with colleagues or with people outside the organization
• Collaborate on a file

Excel 2019: CasesThis module offers you a video with a length of 48 minutes.

• Set up a quality control
• Presentation of the use case
• Creating the Statistical Formulas
• Prepare the chart
• Create control chart
• Customize control chart display
• Conclusion

Analyzing library visits

• Presentation of the use case
• The graph Evolution of visitor numbers
• Create the pivot tables
• Conclusion

Keep track of budget

• Presentation of the use case
• Create the pivot tables
• Creating the charts
• Create the dashboard
• Conclusion

Reduce costs

• Presentation of the use case
• Creating the Formulas
• Solve the problem with the Solver
• Conclusion

Learning Format

Our cutting-edge Excel 365 Course is presented through a dynamic E-Learning platform. Engage in concise video fragments of 2 to 5 minutes, allowing you to navigate the material at your own pace, enhancing both flexibility and comprehension.

Admission Criteria

Participation in this course requires a foundational proficiency in computer skills. Regardless of your existing experience, we welcome your participation in this transformative learning journey. The course content is available in both Dutch and English, allowing you to engage in your preferred language.

We anticipate your participation with great anticipation, as together we embark upon a comprehensive exploration of Excel's capabilities.

Accessibility

We are pleased to offer you unrestricted online access to the course for an entire year, 24/7. This affords you the freedom to learn on your own terms, accommodating your busy schedule.

Contact

With great pleasure, our dedicated educational advisors are ready to answer all your questions. Your curiosity and interest are welcomed with open arms. Whether it's about specific course details, study options, or learning pathways, we are here to assist you.

Our availability spans from Monday to Friday, within a time window that starts at 09:00 AM and concludes at 05:00 PM. During these hours, you have the opportunity to contact us directly and inquire about anything you need. We believe in personal interaction and strive to serve you with the utmost care and attention.

You can reach us by phone at +31 367601019. For those who prefer written communication, we are also available via email at info@officeelearningmenu.nl. Do not hesitate to get in touch, as we are here to nurture your curiosity and guide you on your educational journey.

Warm regards, Graham Hulsebos Educational Advisor at Office Elearning Menu