Join itag

Loading Events

« All Events

  • This event has passed.

XL Intermediate

May 22 @ 9:30 am - 4:30 pm

| €50

Who should attend

Existing users of Microsoft Excel, who want to create more complex graphs and formulas

 

Pre-requisites

A working knowledge of PCs plus Windows and Excel is assumed, gained from the workplace or by prior attendance on an IT course.

 

Course Outline

Using Conditional Formatting                                               

Saving Templates                                           

Date Functions – Today, Now, Month                                              

Using Proper/Upper/Lower functions                                    

Using Count and Counta                                           

Using Countif and Sumif                                          

Using IF Functions                                        

Concatenate Data                                          

Protecting Worksheets/Workbooks                                       

Linking Excel Files                                        

Creating Custom Views                                             

Using Advanced Filters                                             

Subtotal Data in a List                                               

Group and Outline                                         

Creating a Pivot Table           

Details

Date:
May 22
Time:
9:30 am - 4:30 pm
Cost:
€50

Venue

TBC

Tweets

For more pics click here >

Media Partners