Description
Microsoft Excel Level-2 – Intermediate Class
How to book: Choose a date from the calendar above > click “Book now” > click on “View Cart” > at the bottom of the screen click “Proceed to checkout” > Fill the form > Click on PayPal and you can pay with PayPal account or a credit card. You can go through the same process if you wish to book other levels.
Class Time: 9:00 am to 5:30 pm
Break: 11:50 am for 20 minutes
Lunch: 1:00 pm to 1:30 pm
Break: 3:30 pm to 20 minutes
Syllabus
Level 2 – Intermediate
Naming Worksheets
Linking Worksheet Data
Creating Different Types of Charts, Column, Line, Pie and so on.
Labeling Charts, Adding Legends
Formatting Charts
Adding Arrows and Text to a Chart
Embedding a Chart in A Worksheet
Creating and Using Templates
Creating a Database
Sorting and Alphabetizing
Searching a Database
Automatic Record Numbering
Finding Records in a Database
Hiding and Un-Hiding Columns
Create and Run Macros
Edit Macros
Create and Apply Filters