Microsoft Excel 2019 Custom (Office Elearning Menu)

Introductie

We extend a warm welcome to you to explore the comprehensive Excel 365 Course + Pre-Assessment + Online Book. Your consideration of this opportunity is greatly valued, and we are excited to provide you with an exceptional learning experience.

Omschrijving

Discover the world of Excel 365 in a transformative learning journey. This course, hosted within a virtual Office 365 cloud environment, is meticulously designed to empower beginners with foundational knowledge seeking to master Excel's core functionalities. What sets this course apart is its innovative approach – it begins with a practical pre-test, tailored to your current understanding. This test result guides the customization of your learning path, ensuring a truly personalized training experience. As you progress through the course, interactive videos with voiceovers and subtitles enhance your comprehension. Our unique progress reporting mechanism highlights areas for improvement, allowing you to focus solely on what's needed to conquer Excel 365.

Target Audience

This course is thoughtfully crafted for those who consider themselves novices with some basic familiarity, aspiring to gain mastery over Excel's fundamental features. We applaud your desire to enhance your skills in this dynamic platform.

Content

Basic

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

Advanced

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

Expert

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

The course duration is approximately 14 hours and 38 minutes, consisting of video fragments averaging 2 to 5 minutes each. The pace of learning is personalized, accommodating your individual speed and preferences. Instructional videos, demonstration videos, hands-on lab exercises, and an online Office environment collectively foster an engaging and effective learning experience.

Admission Criteria

To participate in this course, the required level of prerequisite knowledge is basic computer skills. Irrespective of your current expertise, you are welcome to join and expand your understanding of Excel 365. The course is available in both Dutch and English, affording you a comfortable learning environment.

This course encompasses a holistic learning experience, inclusive of an online book and a Certificate of Completion. Additionally, it equips you for the Microsoft Office Specialist (MOS) certification, a testament to the quality and depth of your learning journey. Developed by MOS educators with over 27 years of experience, and endorsed by Microsoft as a Gold Partner, this course is enriched with valuable insights and expertise.

We encourage you to contemplate the value this course can bring to your personal and professional growth. Should you decide to embark on this educational voyage, we stand ready to support you every step of the way.

Accessibility

Recognizing the demands of your schedule, we offer you unrestricted online access to the course content, available 24/7 for a period of 365 days from activation. This flexibility empowers you to learn at your own convenience, ensuring an optimal learning journey.

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