Microsoft Excel 365 Basic + Online book (Office Elearning Menu)

Introductie

We extend our warmest welcome to you to the distinguished Excel 365 Basic E-Learning Course + Online Book. We are genuinely honored by your interest in enhancing your Excel proficiency, and we are excited to guide you through this enlightening journey.

Omschrijving

It is with great pride that we present the Excel 365 Basic E-Learning Course + Online Book, meticulously designed to offer a comprehensive understanding of Excel's fundamental functionalities. This course equips you with the skills to master data entry, formatting, and management. From elementary calculations to intricate graphs, handling large datasets, and exploring pivot tables - our course presents you with an expansive toolkit.

Target Audience

This course is tailored for individuals who possess basic computer knowledge and aspire to grasp the foundational features of Excel. We cordially invite beginners to participate and refine their fundamental skills, with an eye towards future advancement.

Content

Basic

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

Introduction to Excel, filling out a table

• What you need to know about: Spreadsheets
• Opening workbooks
• General work environment
• Moving around in a workbook
• What you need to know about: Entry help
• Entering data
• What you need to know about: Selecting, copying and moving
• Selecting and deleting cells
• Cancel and restore operation
• Column width/row height
• What you need to know about: Saving files
• Saving workbooks
• Modifying cell contents
• Creating a new workbook

Make your first calculations

• Entering formulas
• Sum and other simple calculations
• Calculating a percentage
• Copy to adjacent cells

Take care of formatting your data

• Simple number notations
• Apply Theme
• Character Formatting
• Font and font size
• Aligning cell contents
• Cell Color
• Cell borders

Print and set up page layouts in your worksheets

• Page Layout
• Print preview and print
• Page Break
• Print area
• What you need to know about: Header and footer
• Header and footer

Working more efficiently with Excel

• Using Excel help
• Spellcheck
• Search and Replace
• Zooming in and out
• Inserting or removing rows, columns and cells
• Moving cells
• Copy to non-adjacent cells
• Quickly copy cell formatting
• Merge cells
• Print cell contents
• Cell styles
• Sorting a table

Manage worksheets

• Worksheet name and tab color
• Inserting, deleting worksheets and setting the background
• Move, copy and hide worksheets
• Block column/row, split screen
• Print column and row titles repeatedly
• Hide worksheet items
• Grouping data in view

Office 2019: Cases

Excel, Word or PowerPoint with an Office 365 subscriptionThis module offers a 20-minute video.

• Creating an email message with or without an Office 365 subscription: what are the differences?
• Creating and saving Office documents to OneDrive, SharePoint Online, or Teams
• Edit a document from OneDrive, SharePoint, or Teams
• Sharing Office documents with colleagues or with people outside the organization
• Collaborating on a file

Excel 2019: CasesThis module provides you with a video that is 48 minutes in length.

• Setting up quality control
• Presentation of the user case
• Creating the statistical formulas
• Preparing the diagram
• Create a control chart
• Adjusting the display of the control chart
• Conclusion

Analyzing the library visit

• Presentation of the use case
• The graph Development of the number of visitors
• Creating the pivot tables
• Conclusion

Keeping track of the budget

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

Reducing costs

• Presentation of the use case
• Creating the formulas
• Solving the problem with the Solver
• Conclusion

Course Structure

Our exclusive Excel 365 course (2019 version) is hosted within a virtual Office 365 cloud environment. Here, you will engage with enriching practice assignments and engaging interactive videos enriched with spoken narration and subtitles. This dynamic approach enhances comprehension and involvement.

Admission Criteria

Participation in this course mandates basic computer skills. Regardless of your current proficiency, we extend a warm invitation for you to partake in this educational journey. The course content is available in both English and Dutch, catering to your language preference.

We earnestly hope to have the privilege of welcoming you, and jointly embarking on a voyage of Excel mastery.

Accessibility

We offer online access to the course around the clock, 365 days after activation. This flexibility empowers you to learn at your own pace, harmonizing learning with your daily commitments.

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