Microsoft Excel 365 + Zero measurement + Online book (Office Elearning Menu)

Introductie

We extend a warm welcome to you as you consider embarking on the remarkable journey of the Excel 365 Course + Zero measurement + Online book. Your interest in advancing your Excel skills is highly valued, and it would be our privilege to guide you through this enriching learning experience.

Omschrijving

We proudly present the Excel 365 Course + Zero measurement + Online book, meticulously designed to immerse you in the core functionalities of Excel. Our comprehensive curriculum offers profound insights into data entry, formatting, and management. From fundamental calculations to intricate graphs, adeptly handling large datasets and exploring pivot tables—this course equips you with a versatile toolkit.

Target Group

This course is tailored for individuals seeking to enhance their command over Excel, starting from a foundation of basic knowledge. Beginners are cordially invited to participate and refine their skills with an eye towards mastery.

Course content

Basic

This module provides you with interactive training consisting of 45 lecture 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 the formatting of 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 overview

This module provides you with interactive training consisting of 60 lecture videos, 60 assignments and5 files with additional information.

Evolve to complex tables

• Displaying multiple lines in cell
• An absolute reference in formula
• Copy calculation results and links, transpose
• What you need to know about: Entering functions
• System date and date format
• Simple condition
• Custom notation
• Applying conditional formatting
• Managing conditional formatting
• Cell range name
• Validation criterion
• Cell ranges in functions

Presenting your figures in graph form

• What you need to know about: Charts
• Creating and moving a chart
• Managing a graph
• Selecting chart elements
• Adding or removing chart elements
• Formatting chart elements
• Modifying chart text elements
• Legend and drawing area
• Printing a chart and page layout

Improve the layout of your charts

• Modifying data labels
• Data sets and graph axes
• Managing sequences
• Chart type options
• Manage chart templates
• Create a 2D map chart
• Creating a sparkline chart
• Manage Sparklines

Enhance your tables

• Creating a graphic object
• Selecting and deleting objects
• Copying and moving objects
• Defining the size of a graphic object
• Modifying a text box
• Editing a shape
• Formatting drawing objects
• Inserting an image
• Managing images
• Rotating and aligning objects
• Overlapping and grouping objects

Using your data lists

• Calculating subtotals
• Creating and managing a data table
• Displaying and sorting data from a data table
• Adding a calculation to a data table
• Automatic filtering
• Custom filters
• Empty and duplicate values
• What you need to know about: Criterion ranges
• Filtering with criterion range
• Filtering and copying rows with criterion range
• Calculations with criterion range

Create and use pivot tables and graphs

• What you need to know about: Pivot tables and graphs
• Creating a pivot table
• Modifying a pivot table and adding calculations
• Changing the source of a pivot table
• Selecting, copying, moving, and deleting a pivot table
• Structuring and printing a pivot table
• Formatting a pivot table
• Filtering a pivot table
• To filter using slicers
• Basing a pivot table on multiple data tables
• Adding fields or calculated elements
• Grouping data
• Creating a Pivot Chart

This module provides you with interactive training consisting of 42 lecture videos, 42 assignments and5 files with additional information.

Work even more efficiently

• Convert data
• What you need to know about: Automatic fast fill
• Using data sets
• Custom views
• Note on cell
• Error checking
• Evaluating formulas
• Control window

Use advanced function calculations

• Lookup table and functions
• Text functions
• Calculate time
• Calculate dates
• Conditions with AND, OR, NOT
• absolute conditions
• Conditional functions
• Matrix formula
• Calculating with copies
• Merge
• Financial functions
• Table with double entries

Discover New Functionalities

• Target search
• Solution
• Scenario management
• Hyperlink
• What you need to know about: Styles and templates
• Creating and customizing a theme
• Creating and using a template
• What you need to know about: Import, export and interoperability
• Editing and deleting a template
• Transferring Excel data: PDF, XPS, email and web page
• Converting Excel files
• Importing data
• Update and manage imported data
• Workbook properties

Share workbooks securely

• Workbook security
• Protecting cells
• Share a workbook
• Tracking changes in a workbook
• Merge folders
• Finishing a Workbook
• Digital signature
• Create a form
• Protect and use a form

To learn even more about it....

• Macro command
• Restoring versions and files
• What you need to know about: Customizing the ribbon
• What you need to know about: Good habits for spreadsheets
• What you need to know about: Collaborating on a workbook

Office 2019: CasesExcel, Word or PowerPoint with an Office 365 subscriptionThis module provides you with a 20-minute video.

Emailing ma Office with or without an Office 365 subscription: what are the differences?Creating and saving Office documents to OneDrive, SharePoint Online, or TeamsEditing a document from OneDrive, SharePoint, or TeamsSharing Office documents with colleagues or with people outside the organizationCollaborating on a file

Lesson Structure

Our unique Excel 365 course (version 2019) is presented in a virtual Office 365 cloud environment. This dynamic setting features practical assignments and engaging interactive videos, complete with spoken dialogue and subtitles. This immersive approach bolsters your comprehension and engagement throughout the learning journey.

Admission Criteria

Participation in this course necessitates a foundational grasp of basic computer skills. Regardless of your current expertise, we welcome you to embark on this transformative learning experience. The course is offered in the English language to accommodate your preference.

We anticipate the privilege of welcoming you and embarking on this educational odyssey in the realm of Excel.

Accessibility

The course material is available online, granting you unrestricted access 24/7, spanning a full year from the point of activation. This flexibility empowers you to tailor your learning experience to fit seamlessly into 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