What you will learn:
✓ Data Entry: Enter and edit text, numbers, and dates,
✓ Formulas: Calculations using formulas,
✓ Formatting: Layout of formatting with font, colors, numeric and date/time display,
✓ Import: Import large data files,
✓ Printing: Basic print preview and printing settings,
✓ Charts: Create and customize tables and graphs.
✓ Sorting and Filtering: Sorting data tables and selection criteria on one or more columns,
✓ Pivot Table: Grouping data tables,
✓ Graphics: Display data tables in graphs,
✓ Lookup: Find data rows in tables by criteria.
Course Description:
With our practical MS Excel course, you will learn in a fun and educational way to use formulas and make calculations. This in combination with a nice layout and the right cell properties. You will learn to create dynamic and effective visualizing reports using tables and charts.
During the second part of the course, you will learn how to work with large data sets using the data table functions and formulas of MS Excel. You will also learn how to secure your sensitive excel spreadsheets using the password protection functionality to prevent unwanted changes.
The course consists of a two-day training session. The duration of a session is two hours. To get the maximum efficiency from the course we give the participant the space between the first and second day to independently perform exercises at home or at work. For performing exercises, a computer with MS Excel must be available at home or work.
The course is taught in class by a teacher in Papiamentu, Dutch, English, and/or Spanish.
Prerequisites:
✓ Basic computer skills, including how to use a mouse and keyboard.
✓ Familiarity with the Windows or Mac operating system.
✓ An interest in learning how to use Excel for personal or professional purposes.
✓ No prior experience with Excel is required.
So, whether you want to learn from the basics or want to upgrade your knowledge and apply useful tips and tricks, you can sign up for this course by clicking on the 'Register' button or send an email to training@meditsol.net.
Register and our training coordinator will contact you with the training details!