Excel courses

...complex tasks using macros summarise data using pivot tables analyse and extrapolate data using scenarios and solver create complex formulae using combinations...

...Microsoft Excel 2007 - All Levels Course Summary: Course Content: This course is offered over four levels: Beginners, Intermediate, Advanced and Masters...

...to have Microsoft excel available and to alread be proficient in usining MS Excel. Suitable for: Researchers, Graduates, Engineers... Learn about: Risk Analysis, Quality Improvement, Process Improvement...

...Data Lists • Sorting & Filtering Data • Sub Totals • Creating Charts • Manipulating Chart Data • Modifying Chart Layouts • Previewing & Printing Charts...

...complex tasks using macros summarise data using pivot tables analyse and extrapolate data using scenarios and solver create complex formulae using combinations...

...who wishes to develop more complex spreadsheets, use more advanced formulae and develop skills in data analysis techniques. The reasonably experienced...

...text enhancement, selecting cells and ranges, text alignment, merging and splitting cells, modifying column width and row height, printing the active sheet...

...Working With Pivot Tables Modifying & Enhancing Pivot Tables Extracting Pivot Data Pivot Calculations Creating Pivot ChartsSetting Defaults Cell Comments...

...and edit formulas and functions use a variety of formatting techniques to enhance worksheet presentation print and select print options manage large worksheets...

...command buttons and sheet and range naming. Excel macros. Suitable for: The experienced Excel user who wishes to examine the more advanced features...

...level who now wish to learn advanced features. Those familiar with using Microsoft Excel to an intermediate level who now wish to learn advanced features...

...including using formulas and enhancing the layout. Course Aims: Be able to set up spreadsheets, change the design and using formulas. Using all the basic functions of excel...

...and edit formulas and functions use a variety of formatting techniques to enhance worksheet presentation print and select print options manage large worksheets...

...Course Content Introducing Excel An overview of the benefits of spreadsheets, the basic spreadsheet structure and a tour of the Excel screen Document Basics...

...Tips and tricks: deliver more in less time Work and calculate with dates for example to obtain delivery dates, durations between dates Use formulas to determine answers...

...To develop skills in advanced features of Microsoft Excel, shortcuts, automated processes and add-ins. To introduce concepts of statistics, practical significance...

...no previous programming skills are necessary, although a good working knowledge of excel is an advantage including using some functions. course description...

...This course is designed to give users an understanding of some of the more advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet...

...Date Formats Custom Formats Conditional Formatting Defining and Naming Ranges Calculation of Named Ranges Chart Creation Creating charts Using the Chart...

...edit and print data using Microsoft Excel. You will learn how to perform various calculations, and successfully enter information in a work sheet...