+49 (0) 30 5201 4923
info@orb-experts.com
A practical introduction to Microsoft Excel for participants who want to create, edit, format and analyse spreadsheets confidently. The course introduces the essential features of the application, simple formulas and functions, cell references and the preparation of professional-looking worksheets for viewing and printing.
You will learn how to work efficiently with workbooks and worksheets and how to create clear, well-structured tables. You will enter and edit data, apply appropriate number and cell formats and perform basic calculations using formulas and functions. You will also understand how cell references work and how to prepare worksheets for printing.
By the end of the course, you will be able to create simple calculations, lists and reports independently and make changes to existing spreadsheets with confidence.
• Navigate the Excel interface, workbooks and worksheets confidently
• Enter, edit, copy and automatically fill data
• Structure and professionally format clear, readable tables
• Create simple formulas and use essential functions
• Understand and apply relative, absolute and mixed cell references
• Sort and filter data and prepare worksheets for printing
• Basic experience using a computer
• Basic keyboard and mouse skills
• No previous Excel experience required
*We customize the course outline and content to your specific needs and relevant use cases.
Module 1: Introduction to Microsoft Excel
• Common uses of Excel for calculations, lists and reports
• Overview of the ribbon, toolbars and worksheet area
• Understanding workbooks, worksheets, rows, columns and cells
• Creating, opening, saving and closing workbooks
• Navigating through larger worksheets
Module 2: Entering data and building tables
• Entering and editing text, numbers and dates
• Selecting, copying, moving and deleting cell contents
• Working with rows, columns and cell ranges
• Using AutoFill for number sequences, dates and patterns
• Inserting, deleting and resizing rows and columns
Module 3: Formatting and presenting worksheets
• Applying fonts, alignment, borders and cell shading
• Using number formats for currency, percentages, dates and decimal values
• Adjusting column widths and row heights
• Merging, wrapping and aligning cell contents
• Using cell styles and table formatting
• Creating consistent and readable worksheet layouts
Module 4: Formula and calculation fundamentals
• Understanding the structure of a formula
• Performing calculations using basic mathematical operators
• Controlling calculation order with brackets
• Copying formulas to other cells
• Identifying and correcting common formula errors
• Displaying formulas and checking calculation results
Module 5: Functions and cell references
• Using essential functions such as SUM, AVERAGE, MIN and MAX
• Counting values with COUNT and COUNTA
• Using AutoSum and quick calculations in the status bar
• Understanding relative references when copying formulas
• Applying absolute and mixed cell references
• Creating calculations using fixed percentages, prices or factors
Module 6: Organising and managing data
• Sorting tables by text, numbers and dates
• Applying and removing basic filters
• Finding and replacing information
• Identifying duplicate or incorrect entries
• Inserting, renaming, moving and copying worksheets
• Using information across multiple worksheets
Module 7: Preparing worksheets for printing
• Using page layout and print preview
• Setting page size, orientation and margins
• Scaling worksheets to fit one or more printed pages
• Defining print areas
• Repeating headings across multiple pages
• Adding headers, footers, page numbers and file information
Module 8: Practical exercises and final project
• Building a structured list or simple calculation worksheet
• Formatting input values and calculation results
• Applying essential formulas and functions
• Using appropriate cell references
• Sorting, filtering and reviewing the data
• Preparing the completed worksheet for printing
Hands-on learning with expert instructors at your location for organizations.
Master new skills guided by experienced instructors from anywhere.
