excel advanced

mullan training
belfast, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Fee: £140+vat

Course Description:

'' course content





advanced functions

§ if function & nested if statements

§ and & or functions

§ lookup functions (horizontal and vertical lookup

§ subtotals

§ conditional formatting





3d ranges

§ create & maintain (within worksheets in a single file & between external files)

§ consolidate data (via 3d ranges & using the consolidate tool)





pivot5?s

§ create pivot5?

§ work with row/ column fields

§ data fields

§ customise5? display





organising workbooks

§ create templates

§ protect ranges & worksheets





data

§ enter & select records using the input form

§ sort data into lists

§ filter data - autofilter, advanced filter

§ validation rules









macros

§ create macros �record & modify the vba code generated

§ relative referencing

§ assign to toolbars/ keyboard

§ make available to all new documents/ current document only





outlines

§ group row/ column data to create outline levels based on worksheet formulae

§ display summary rows and summary styles





custom views

§ create, modify, delete

§ include hidden rows, columns, filter settings



...''

Elements of this syllabus are subject to change.

Phone:+44 028 90 32 22 28

School Address/Venue(s):

mullan training
ist floor, blackstaff studios
blackstaff square
8-10 amelia st
belfast
bt2 7gs


Jobs & Resumes: belfast
Houses & Roommates: belfast
Travel Agencies: belfast

Search other schools for excel advanced training resources.

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!