Instructor Led Conditional Formatting Training
Conditional Formatting Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United States
United Kingdom
Canada
Croatia
Singapore
Australia
South Africa
India
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From The Career Center
Microsoft Excel 2007 New Features
You have worked with Microsoft Office Excel 2003, and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will work with the new and enhanced features in Microsoft Office Excel 2007. Objectives: You will be introduced to the new features in Microsoft
more...
Microsoft Excel 2007 New Features
You have worked with Microsoft Office Excel 2003, and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will work with the new and enhanced features in Microsoft Office Excel 2007. Objectives: You will be introduced to the new features in Microsoft
more...
From Mullan Training
Introduction To Crystal Reports
...ross-Tab layout features
Conditional Reporting
- Using Conditional Formatting
- Using the Highlighting Expert
Charting
- Using the Graph/Chart Expert
- Graphing on Summary information
- Graphing Detail or Formula fields
- Drilling down on a graph
- Customising a graph
Basic Report Distribution
- Exporting your reports
- Viewing from a web browser
LOCATIONS
Courses can be
more...
...ross-Tab layout features
Conditional Reporting
- Using Conditional Formatting
- Using the Highlighting Expert
Charting
- Using the Graph/Chart Expert
- Graphing on Summary information
- Graphing Detail or Formula fields
- Drilling down on a graph
- Customising a graph
Basic Report Distribution
- Exporting your reports
- Viewing from a web browser
LOCATIONS
Courses can be
more...
Advanced Crystal Reports
...running totals
- Adding User Functions Libraries (UFLs)
Conditional Formatting
- Types of formatting
- Absolute formatting
- Conditional on/off formatting
- Conditional attribute formatting
- Using the highlighting feature
Multiple Sections
- Inserting sections
- Splitting Sections
- Moving sections
- Deleting sections
- Multiple section formats (underlay following sections)
- Example
more...
...running totals
- Adding User Functions Libraries (UFLs)
Conditional Formatting
- Types of formatting
- Absolute formatting
- Conditional on/off formatting
- Conditional attribute formatting
- Using the highlighting feature
Multiple Sections
- Inserting sections
- Splitting Sections
- Moving sections
- Deleting sections
- Multiple section formats (underlay following sections)
- Example
more...
From Last Minute Training
Microsoft Excel - private, one on one training - INTERMEDIATE level
Duration Details
3 hour block of time
What can be learned at this seminar:
NOTE: This is PC based training - Versions Offered: 97, 2000, 2002, 2003.
VIEWING WORKSHEETS
Customizing View Options
Displaying and Customizing Toolbars
Hiding Workbooks and Worksheets
Freezing Panes
Grouping and Ungrouping Worksheets
MORE FORMATTING TECHNIQUES
Styles, Guidelines and the
more...
Duration Details
3 hour block of time
What can be learned at this seminar:
NOTE: This is PC based training - Versions Offered: 97, 2000, 2002, 2003.
VIEWING WORKSHEETS
Customizing View Options
Displaying and Customizing Toolbars
Hiding Workbooks and Worksheets
Freezing Panes
Grouping and Ungrouping Worksheets
MORE FORMATTING TECHNIQUES
Styles, Guidelines and the
more...
Microsoft Excel 2003 - level 2
Microsoft Excel is a powerful spreadsheet package for working with numerical data. It easily does calculations and allows you to manipulate, track and store the data. This session is designed to give those who are already familiar with the basics of Excel the opportunity to use more advanced techniques in their spreadsheets. In this session, participants will:
* apply intermediate formats
more...
Excel 2007 Upgrade 1 Day
This course is a must if you want to get up to speed quickly with the many changes and improvements in Excel version 2007. Topics include: the brand new user-interface, changes in spreadsheet limits, themes and styles, conditional formatting, improved formula writing, improved sorting and filtering, table enhancements, the new look of charts, improved pivot tables, new file formats, changes in
more...
Microsoft Excel 2000 - 2003 Level 2 nexient
Performance Objectives
Upon completion of the course, participants will be able to accomplish the following:
Organize, protect, and display data, using various tools
Create linking formulas and use the IF function
Set up multiple worksheets, use information from other sources through consolidation, and copy and paste links to combine information into one worksheet
Create and modify
more...
Microsoft Excel 2007 Level 2 - nexient
Who should attend
This course is intended for participants who are familiar with Microsoft Office Excel 2007.
Performance Objectives
Upon completion of the course, participants will be able to accomplish the following:
Organize, protect, and display data, using various tools
Create linking formulas and use the IF function
Set up multiple worksheets, using information from other
more...
Microsoft Excel 2007 Level 2- Nexient
Participants will learn to: organize, protect, and display data; create linking formulas; use the IF function; set up multiple worksheets; create & modify charts ; use styles to format worksheets; use conditional formatting, comments, & text boxes.
more...
Microsoft Excel 2007 Level 2-Nexient
Participants will learn to: organize, protect, and display data; create linking formulas; use the IF function; set up multiple worksheets; create & modify charts ; use styles to format worksheets; use conditional formatting, comments, & text boxes.
more...
Microsoft Excel 2007 Level 2 - nexient
Participants will learn to: organize, protect, and display data; create linking formulas; use the IF function; set up multiple worksheets; create & modify charts ; use styles to format worksheets; use conditional formatting, comments, & text boxes
more...
Excel Upgrade to 2007 - 1 Day
Topics include: the brand new user-interface, changes in spreadsheet limits, themes and styles, conditional formatting, improved formula writing, improved sorting and filtering, table enhancements, the new look of charts, improved pivot tables and more
more...
From Affinity IT Training, LLC
SQL Server 2005 Reporting Services
...tudio. Explore creating reports with
groups, expressions, conditional formatting, and parameters.
Explore the deployment and printing of reports and the
export of reports to PDF, Excel, and other formats.
Gain a thorough understanding of Reporting Services security,
report snapshots, subscriptions, and the use of custom assemblies.
Discover how to integrate reports into your ASP.NET and other
more...
...tudio. Explore creating reports with
groups, expressions, conditional formatting, and parameters.
Explore the deployment and printing of reports and the
export of reports to PDF, Excel, and other formats.
Gain a thorough understanding of Reporting Services security,
report snapshots, subscriptions, and the use of custom assemblies.
Discover how to integrate reports into your ASP.NET and other
more...
From Cognita
MS Excel Advanced
Training overvew
In this instructor-led live training session you will learn advanced functions and techniques in using Microsoft Excel. If you use this great tool for data operations on everyday basis this course is a must see!
Training agenda:
- Using Excel As a Database
- Filtering Excel data list
- Advanced formulas and functions
- Searching and extracting data
- Conditional
more...
Training overvew
In this instructor-led live training session you will learn advanced functions and techniques in using Microsoft Excel. If you use this great tool for data operations on everyday basis this course is a must see!
Training agenda:
- Using Excel As a Database
- Filtering Excel data list
- Advanced formulas and functions
- Searching and extracting data
- Conditional
more...
From Intellisoft Systems
Advanced Microsoft Excel 2007
...treamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting in Excel
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings
Advanced Excel Lesson 7:
Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Multiple Workbooks
Restrict Document Access
Advanced Excel
more...
...treamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting in Excel
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings
Advanced Excel Lesson 7:
Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Multiple Workbooks
Restrict Document Access
Advanced Excel
more...
From Navigator Project Finance
Project Finance Modelling A
...* Avoidance of Circular References
* Applications of Conditional Formatting
* Application of Data Validation (incl offsheet list selection)
Smart Functions
* Discussion around recommended functions and their applications
* SUMIF/ COUNTIF/ SUMPRODUCT/ DATE FUNCTIONS
* + takeaway file of demonstrations
* Array Functions {Average()}, {Min()},{Transpose()}
more...
...* Avoidance of Circular References
* Applications of Conditional Formatting
* Application of Data Validation (incl offsheet list selection)
Smart Functions
* Discussion around recommended functions and their applications
* SUMIF/ COUNTIF/ SUMPRODUCT/ DATE FUNCTIONS
* + takeaway file of demonstrations
* Array Functions {Average()}, {Min()},{Transpose()}
more...
From Training-2-Go
Excel 2007 - Advanced
Advanced functions
Lookups and data tables
Advanced list management
PivotTables and PivotCharts
Exporting and importing
Analytical options
Macros and custom functions
Conditional formatting and SmartArt
more...
From Intertech
SQL Server 2005 Reporting Services SSRS Training
...You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services
more...
SQL Server 2008 Reporting Services SSRS Training
...You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services
more...
...You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services
more...
From Decision Modelling Systems
FINANCIAL MODEL ANALYSIS WITH EXCEL
...ent modeling and valuation
a Sensitivity analysis
a Conditional formatting and conditional Excel functions
a Text functions and dynamic graph titles
DCF, Cost of Capital and Real Options
a Modeling case - develop firm financial model from scratch
a Cost of capital models
a Lease versus purchase decisions
a Introduction to options
a Excel techniques: regressions, array
more...
From NetLearn
Excel 2007 basic - advanced
Unit 1: Advanced functions
Topic A: Logical functions
A-1: Using the IF function
A-2: Using OR, AND, and NOT as nested functions
A-3: Using nested IF functions
A-4: Using the IFERROR function
Topic B: Math and statistical functions
B-1: Using SUMIF
B-2: Using COUNTIF
B-3: Using AVERAGEIF
B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
B-5: Using ROUND
Topic C: Financial functions
more...
Unit 1: Advanced functions
Topic A: Logical functions
A-1: Using the IF function
A-2: Using OR, AND, and NOT as nested functions
A-3: Using nested IF functions
A-4: Using the IFERROR function
Topic B: Math and statistical functions
B-1: Using SUMIF
B-2: Using COUNTIF
B-3: Using AVERAGEIF
B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
B-5: Using ROUND
Topic C: Financial functions
more...
From Applied Office
Microsoft Office 2007 - Overview
Whether you're a user of Microsoft Outlook, Word, Excel, or PowerPoint, if you've upgraded to Office 2007 you know there are new features just waiting to be used, and there's new shortcuts that you're dying to learn.
This class, intended for users at all levels, will introduce you to Office 2007 with a whirlwind of tips, tricks, and new features, such as:
a customizing the Ribbon to suit
more...
Whether you're a user of Microsoft Outlook, Word, Excel, or PowerPoint, if you've upgraded to Office 2007 you know there are new features just waiting to be used, and there's new shortcuts that you're dying to learn.
This class, intended for users at all levels, will introduce you to Office 2007 with a whirlwind of tips, tricks, and new features, such as:
a customizing the Ribbon to suit
more...
From Dataspark
ExcelVBMS Access training in Bangalore
...ata tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros writing in Excel/ VBA. Duration:
more...
From GITS Academy
MS Excel Advacned training Bangalore
...ata tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros writing in Excel/ VBA. Duration:
more...
From MasterSkills Learning Solutions
Financial Modeling using Microsoft Excel
..., Logical, Text, Date, Time a Lookup & Reference a Conditional Formatting a Cell, Row, Column & Sheet a Data Validations a Linking Worksheets a Hyperlinks a Referencing a Relative, Absolute & Mixed a Formula Auditing a Sharing workbook a Charts, Graphs & Reports a Financial Functions a Statistical Functions a What a If Analysis a Datatable a
more...
From Wintrac Inc.
SQL SERVER 2005 REPORTING SERVICES
...You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services
more...
From ExcelTech Consultant
Advance Excel
...applications. Key contents of this workshop would be;
1. Conditional Formatting
2. Lookup functions
3. Array functions
4. Database functions
5. Error Handling Processes
6. Charts and Pivot Tables
7. Shortcut Keys for quick working and many more things, which will help you to reduce your routine working time by more than 50% and would increase the accuracy level near to 100%.
For
more...
...applications. Key contents of this workshop would be;
1. Conditional Formatting
2. Lookup functions
3. Array functions
4. Database functions
5. Error Handling Processes
6. Charts and Pivot Tables
7. Shortcut Keys for quick working and many more things, which will help you to reduce your routine working time by more than 50% and would increase the accuracy level near to 100%.
For
more...
From Ryan Consulting Group, Inc
Reporting on the Web with Cognos 8
...lations and more. Intermediate topics include formatting, conditional formatting, multi-query reports, drill through reports and more. The course format includes lecture, instructor-led exercises and independent workshops.
Intended Audience
Report Authors and other users, who will create, maintain, and run reports in Report Studio
Prerequisites
A basic knowledge of Windows,
more...
Queries on the Web with Cognos 8
Course Description
This course introduces basic querying techniques with Cognosa Query Studio. Topics include Studios, Cognos Connection, designing simple queries, grouping, filters, prompts, charts, calculations, formatting reports, conditional formatting running reports, and more. The course format includes lecture, instructor-led exercises and independent workshops.
Intended Audience
more...
online course |
instructor-led class |
learn at home |
group study |
self-directed study |
cd-based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer-based learning |
discount pricing |
online tutorial |
