www.concordeducations.com
Open in
urlscan Pro
192.124.249.108
Public Scan
Submitted URL: https://email.concordeducations.com/pub/cc?_ri_=X0Gzc2X%3DAQpglLjHJlCQG3q85rya2H40KkA3m3hzgCeoaHBrfzazfzf8zfwPag3dDFpyf9qNFVXtpKX%3D...
Effective URL: https://www.concordeducations.com/Product/details/70066?utm_source=Oct17_70066_CHorwitz_Nov17&utm_campaign=70066_TP&utm_medium=Res...
Submission: On November 11 via manual from HK — Scanned from DE
Effective URL: https://www.concordeducations.com/Product/details/70066?utm_source=Oct17_70066_CHorwitz_Nov17&utm_campaign=70066_TP&utm_medium=Res...
Submission: On November 11 via manual from HK — Scanned from DE
Form analysis 3 forms found in the DOM
POST https://www.concordeducations.com/Product/search
<form action="https://www.concordeducations.com/Product/search" class="search" id="mainsearch" method="post">
<div class="control-group">
<input required="" type="text" name="all_search" id="all_search" placeholder="Search your Training, Speaker, Category..." autocomplete="off" class="search-field" style="width:90% !important;">
<button type="submit" class="search-button" id="searchsubmit">
<!--<i class="fa fa-search"></i>-->
</button>
</div>
</form>POST
<form method="post">
<div class="form-group">
<label for="name">Your Name:</label>
<input type="text" name="name" class="form-control" required="required" id="name">
<p id="name_errors" class="promo_val_text" style="display: none;"></p>
</div>
<input type="hidden" name="currentURL" value="">
<div class="form-group">
<label for="email">Email:</label>
<input type="email" name="email" required="required" class="form-control" id="email">
<p id="emal_errors" class="promo_val_text" style="display: none;"></p>
</div>
<div class="form-group">
<label for="email">Topic/Content:</label> Excellent <input type="radio" name="Topic" value="Excellent" id="Topic"> Very Good <input type="radio" name="Topic" value="Very Good" id="Topic"> Good <input type="radio" name="Topic" value="Good"
id="Topic"> Fair <input type="radio" name="Topic" value="Fair" id="Topic"> Poor <input type="radio" name="Topic" value="" id="Topic">
</div>
<div class="form-group">
<label for="email">Price:</label> Excellent <input type="radio" name="Price" value="Excellent" id="Price"> Very Good <input type="radio" name="Price" value="Very Good" id="Price"> Good <input type="radio" name="Price" value="Good" id="Price">
Fair <input type="radio" name="Price" value="Fair" id="Price"> Poor <input type="radio" name="Price" value="Poor" id="Price">
</div>
<div class="form-group">
<label for="email">Our Support Service:</label> Excellent <input type="radio" name="Support" value="Excellent" id="Support"> Very Good <input type="radio" name="Support" value="Very Good" id="Support"> Good <input type="radio" name="Support"
value="Good" id="Support"> Fair <input type="radio" name="Support" value="Fair" id="Support"> Poor <input type="radio" name="Support" value="Poor" id="Support">
</div>
<div class="form-group">
<label for="email">About Organisation?:</label> Excellent <input type="radio" name="Organization" value="Excellent" id="Organization"> Very Good <input type="radio" name="Organization" value="Very Good" id="Organization"> Good <input type="radio"
name="Organization" value="Good" id="Organization"> Fair <input type="radio" name="Organization" value="Fair" id="Organization"> Poor <input type="radio" name="Organization" value="Poor" id="Organization">
</div>
<div class="form-group">
<label for="email">Overall Satisfaction:</label> Excellent <input type="radio" name="Satisfaction" value="Excellent" id="Satisfaction"> Very Good <input type="radio" name="Satisfaction" value="Very Good" id="Satisfaction"> Good <input
type="radio" name="Satisfaction" value="Good" id="Satisfaction"> Fair <input type="radio" name="Satisfaction" value="Fair" id="Satisfaction"> Poor <input type="radio" name="Satisfaction" value="Poor" id="Satisfaction">
</div>
<!-- <div class="form-group">
<label for="email">Have you attended this event before?:</label>
Yes <input type="radio" name="Attended" id="Attended" >
No <input type="radio" name="Attended" id="Attended">
</div>
<div class="form-group">
<label for="email">Did the event help you with new learnings or knowledge?</label>
Yes <input type="radio" name="Knowledge" id="Knowledge" >
No <input type="radio" name="Knowledge" id="Knowledge">
</div>
<div class="form-group">
<label for="email">Did the event meet your expectations?:</label>
Yes <input type="radio" name="Event" id="Event" >
No <input type="radio" name="Event" id="Event">
</div>
-->
<div class="form-group">
<label for="email">Do you have any other comments/suggestions that would help us make future events better?:</label>
<textarea name="Suggestions" class="form-control" id="Suggestions"></textarea>
</div>
<!-- <div class="form-group">
<label for="email">Please share your valuable thought; we'll provide the best of our service.:</label>
<textarea name="Service" class="form-control" id="Service"></textarea>
</div>
-->
<div class="text-center">
<button class="button outline blue-alt text-center" id="reviews">Send</button>
</div>
</form>POST https://www.concordeducations.com/Webinar/add_to_cart
<form action="https://www.concordeducations.com/Webinar/add_to_cart" method="post">
<input type="hidden" id="price" name="price">
<input type="hidden" id="total_price" name="total_price" value="0">
<input type="hidden" id="temp_live" name="temp_live" value="0">
<input type="hidden" id="temp_live_id" name="temp_live_id">
<input type="hidden" id="live_check" name="web_id1" value="70066">
<input type="hidden" id="live_id" name="web_id">
<input type="hidden" id="live_idc" name="web_idc">
<input type="hidden" id="live_idc" name="web_ido">
<input type="hidden" id="live_idondemand" name="live_idondemand">
<input type="hidden" id="live_price" name="live_price">
<input type="hidden" id="combo_price" name="combo_price">
<input type="hidden" id="combo_price1" name="combo_price1">
<input type="hidden" id="ondemand_price" name="ondemand_price">
<input type="hidden" id="get_livesession_attend" name="get_livesession_attend">
<input type="hidden" id="get_combo_attend" name="get_combo_attend">
<input type="hidden" id="get_ondemand_attend" name="get_ondemand_attend">
<input type="hidden" id="name" name="name" value="Using Excel's Conditional Formatting and Data Validation Tool">
<input type="hidden" id="WEBINAR_ID" name="WEBINAR_ID" value="70066">
<input type="hidden" id="SPEAK_NAME" name="SPEAK_NAME" value="Cathy Horwitz">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Registration Options</h4>
</div>
<div class="modal-body">
<div class="whole_price">
<div class="no_price">
<p id="selected_price">$00</p>
</div>
<div class="add">
<button type="submit" class="btn-upper btn btn-primary" id="add_to_card">Add to Cart</button>
</div>
</div>
<div class="panel-group" id="accordion" role="tablist" aria-multiselectable="true">
<h5 class="live">Live Webinar Only</h5>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingOne">
<h4 class="panel-title">
<label class="choose"><span>1 Attendee $ 149</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION0" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,0);" value="6674-149-1_Attendee">
<span class="checkmark"></span>
</label>
<a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
<span> </span>
</a>
</h4>
</div>
<div id="collapseOne" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingOne">
<div class="panel-body"> Only 1 attendees is allowed </div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingTwo">
<h4 class="panel-title">
<label class="choose"><span>2 Attendee $ 249</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION1" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,1);" value="6675-249-2_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseTwo" aria-expanded="false" aria-controls="collapseTwo">
<span></span>
</a>
</h4>
</div>
<div id="collapseTwo" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingTwo">
<div class="panel-body"> Only 2 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingThree">
<h4 class="panel-title">
<label class="choose"><span>3 Attendee $ 349</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION2" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,2);" value="6676-349-3_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseThree" aria-expanded="false" aria-controls="collapseThree">
<span></span>
</a>
</h4>
</div>
<div id="collapseThree" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingThree">
<div class="panel-body"> Only 3 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingFour">
<h4 class="panel-title">
<label class="choose"><span>4 Attendee $ 449</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION3" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,3);" value="6677-449-4_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseFour" aria-expanded="false" aria-controls="collapseFour">
<span></span>
</a>
</h4>
</div>
<div id="collapseFour" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingFour">
<div class="panel-body"> Only 4 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default text" style="display: none;">
<div class="panel-heading" role="tab" id="headingFive">
<h4 class="panel-title">
<label class="choose"><span>5 Attendee $ 549</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION4" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,4);" value="6678-549-5_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseFive" aria-expanded="false" aria-controls="collapseFive">
<span></span>
</a>
</h4>
</div>
<div id="collapseFive" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingFive">
<div class="panel-body"> Only 5 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default text" style="display: none;">
<div class="panel-heading" role="tab" id="headingSix">
<h4 class="panel-title">
<label class="choose"><span>6 Attendee $ 599</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION5" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,5);" value="6679-599-6_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseSix" aria-expanded="false" aria-controls="collapseSix">
<span></span>
</a>
</h4>
</div>
<div id="collapseSix" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingSix">
<div class="panel-body"> Only 6 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default text" style="display: none;">
<div class="panel-heading" role="tab" id="headingSeven">
<h4 class="panel-title">
<label class="choose"><span>7 Attendee $ 649</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION6" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,6);" value="6680-649-7_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseSeven" aria-expanded="false" aria-controls="collapseSeven">
<span></span>
</a>
</h4>
</div>
<div id="collapseSeven" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingSeven">
<div class="panel-body"> Only 7 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default text" style="display: none;">
<div class="panel-heading" role="tab" id="headingEight">
<h4 class="panel-title">
<label class="choose"><span>8 Attendee $ 699</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION7" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,7);" value="6681-699-8_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseEight" aria-expanded="false" aria-controls="collapseEight">
<span></span>
</a>
</h4>
</div>
<div id="collapseEight" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingEight">
<div class="panel-body"> Only 8 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default text" style="display: none;">
<div class="panel-heading" role="tab" id="headingNine">
<h4 class="panel-title">
<label class="choose"><span>9 Attendee $ 749</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION8" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,8);" value="6682-749-9_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseNine" aria-expanded="false" aria-controls="collapseNine">
<span></span>
</a>
</h4>
</div>
<div id="collapseNine" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingNine">
<div class="panel-body"> Only 9 attendees are allowed </div>
</div>
</div>
<div class="panel panel-default text" style="display: none;">
<div class="panel-heading" role="tab" id="headingTen">
<h4 class="panel-title">
<label class="choose"><span>10 Attendee $ 799</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION9" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,9);" value="6683-799-10_Attendee">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseTen" aria-expanded="false" aria-controls="collapseTen">
<span></span>
</a>
</h4>
</div>
<div id="collapseTen" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingTen">
<div class="panel-body"> Only 10 attendees are allowed </div>
</div>
</div>
<section class="btn-container">
<span class="rotate"><i class="fa fa-angle-down " id="up" aria-hidden="true"></i><a id="toggle" class="more" href="#">More Attendees</a></span>
</section>
<h5 class="live2">Live Webinar + Recording</h5>
<p><strong>Best Value Pack</strong></p>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingEleven">
<h4 class="panel-title">
<label class="choose"><span>Live With Recorded $ 299</span>
<input type="checkbox" name="comboTypes[]" id="COMBO0" value="6684-299-Live_With_Recorded" onchange="calculatePrice(this.value, 'COMBO', this.checked,0);">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#livewithrecored" aria-expanded="false" aria-controls="collapseEleven">
<span></span>
</a>
</h4>
</div>
<div id="livewithrecored" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingEleven">
<div class="panel-body"> Live with Rec. webinar presentation with audio and slideshow, single-user unlimited access to any compatible device for 6 months. (Access information will be emailed 24 hours after the completion of live
webinar) </div>
</div>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingEleven">
<h4 class="panel-title">
<label class="choose"><span>Live With Digital $ 349</span>
<input type="checkbox" name="comboTypes1[]" value="6685-349-Live_With_Digital" onchange="calculatePrice(this.value, 'COMBO1', this.checked,0);">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#livewithdigital" aria-expanded="false" aria-controls="collapseEleven">
<span></span>
</a>
</h4>
</div>
<div id="livewithdigital" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingEleven">
<div class="panel-body"> Live with the downloadable recording of a webinar along with presentation slides and reference manual. Unlimited access on any compatible device for 1 year. (Access information will be emailed 24 hours
after the completion of live webinar) </div>
</div>
</div>
<h5 class="live2">Recorded Options</h5>
<p><strong>Best Value Pack</strong></p>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingFourteen">
<h4 class="panel-title">
<label class="choose"><span>Recorded $ 199</span>
<input type="checkbox" name="recordTypes[]" onchange="calculatePrice(this.value, 'RECORD', this.checked,);" value="6686-199-Recorded">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapsedigital" aria-expanded="false" aria-controls="collapseEleven">
<span></span>
</a>
</h4>
</div>
<div id="collapsedigital" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingEleven">
<div class="panel-body"> Rec. webinar presentation with audio and slideshow, single user unlimited access for 6 months. </div>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="headingFifteen">
<h4 class="panel-title">
<label class="choose"><span>Digital Download $ 298</span>
<input type="checkbox" name="recordTypes1[]" onchange="calculatePrice(this.value, 'RECORD1', this.checked,0);" value="6687-298-Digital_Download">
<span class="checkmark"></span>
</label>
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseEleven" aria-expanded="false" aria-controls="collapseEleven">
<span></span>
</a>
</h4>
</div>
<div id="collapseEleven" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingEleven">
<div class="panel-body"> Audio recording of a webinar and reference manual delivered by download. Listen anytime on any compatible device for 1 year. </div>
</div>
</div>
</div>
<div class="modal-footer">
<div style="display:flex;">
<div align="left" style="font-size:15px; line-height:35px; width:50%;">
<a href="https://www.concordeducations.com/Refund" style="font-weight:bolder;" target="_blank"><i class="fa fa-share"></i> Refund Policy</a>
</div>
<div class="whole_price">
<div class="add">
<button type="submit" class="btn-upper btn btn-primary checkcart" id="add_to_card">Add to Cart</button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</form>Text Content
* +1-989-341-8773
* Sign Up
* Sign In
*
0
cart - $0
Toggle navigation
0
cart - $0
Toggle navigation
* Home
* About Us
* Industries
* BANKING & FINANCIAL SERVICES
ACCOUNTING, PAYROLL & TAXATION
AUDIT & REPORTING
BANKS AND CREDIT UNIONS
BUSINESS BANKING AND LENDING
FINANCIAL SERVICES AND TRADING
INSURANCE
LIFE SCIENCES
CLINICAL RESEARCH
DRUG & CHEMICALS
FDA REGULATION
LABORATORY COMPLIANCE
MEDICAL DEVICE
PHARMACEUTICAL TRAININGS
HUMAN RESOURCES
ALL HR COURSES
HR MANAGEMENT
RECRUITING - HIRING
FEDERAL REGULATORY COMPLIANCE
LABOR LAW TRAINING
COMPENSATION AND BENEFITS
HEALTH CARE
AUDIT & DATA SECURITY
GENERAL HEALTH CARE
HIPAA TRAININGS
HOSPITAL MANAGEMENT
MEDICAID & MEDICARE
HITECH
CROSS INDUSTRY
EHS COMPLIANCE
IT AND PCI COMPLIANCE
OSHA COMPLIANCE
QUALITY & SAFETY
RISK MANAGEMENT
TRADE & LOGISTICS
FOOD AND SAFETY
AUDITS & INSPECTIONS
FOOD SAFETY COMPLIANCE
MANUFACTURING & CONTAMINATION CONTROL
PACKAGING & LABELING
RECALLS & CRISIS MANAGEMENT
STORAGE & DISTRIBUTION
MICROSOFT TRAINING COURSES
MICROSOFT EXCEL
ACCESS AND MACROS
OFFICE 365 AND OUTLOOK
POWERPOINT
MS WORD
NEW OFFICE ESSENTIAL
INFORMATION TECHNOLOGY
ADOBE COURSES
CISCO TRAINING COURSES
CLOUD COMPUTING
WINDOWS SERVER
AUTOCAD
SEO TRAINING
* Live Webinar
* Recorded Webinar
* Membership Package
* Webinar Packs
* Top Trend Package
* Customized Package
* Company
* Career With Us
* Testimonial
* Blog
* Contact Us
Using Excel's Conditional Formatting and Data Validation Tool
Click For Bio
×
OPTION INFORMATION
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Training made by Speaker
Cathy Horwitz believes that when your employees know the capabilities of the
software they use, they will demonstrate improved productivity, will be more
efficient and will be able to problem solve more easily.
Cathy teaches classes on the Microsoft suite of application software including
Excel, PowerPoint, Word, Access and Outlook. Cathy has over 30 years of
experience in classroom and virtual training and has been an instructor of
Microsoft Office since 1989.
Her strengths include customizing classes based on the needs of individual
students and providing realistic business examples to compliment training. She
is a high energy trainer with a flair for training the adult student.
She holds the Modern Classroom Certified Trainer certification from Logical
Operations which prepares instructors for all aspects of delivering a course
using the latest training technologies and approaches.
When not teaching, Cathy enjoys gardening, shopping estate sales and refinishing
mid-century furniture.
Close
Schedule
November 17, 2022 || 01:00 PM ET / 10:00 AM PT
Duration
60 Mins
Level
Intermediate
Webinar ID
70066
Review
Share
Tell a Friend
Add to calender
* Google calender
* Outlook calender
Modal content
×
TELL A FRIEND
Friend's Name:
Friend's Email:
Your Name:
Send
Close
Add Review
×
YOUR FEEDBACK IS PRECIOUS TO US!
Your Name:
Email:
Topic/Content: Excellent Very Good Good Fair Poor
Price: Excellent Very Good Good Fair Poor
Our Support Service: Excellent Very Good Good Fair Poor
About Organisation?: Excellent Very Good Good Fair Poor
Overall Satisfaction: Excellent Very Good Good Fair Poor
Do you have any other comments/suggestions that would help us make future events
better?:
Send
Close
6 DAYS LEFT REGISTER
Add to Cart
×
REGISTRATION OPTIONS
$00
Add to Cart
LIVE WEBINAR ONLY
1 ATTENDEE $ 149
Only 1 attendees is allowed
2 ATTENDEE $ 249
Only 2 attendees are allowed
3 ATTENDEE $ 349
Only 3 attendees are allowed
4 ATTENDEE $ 449
Only 4 attendees are allowed
5 ATTENDEE $ 549
Only 5 attendees are allowed
6 ATTENDEE $ 599
Only 6 attendees are allowed
7 ATTENDEE $ 649
Only 7 attendees are allowed
8 ATTENDEE $ 699
Only 8 attendees are allowed
9 ATTENDEE $ 749
Only 9 attendees are allowed
10 ATTENDEE $ 799
Only 10 attendees are allowed
More Attendees
LIVE WEBINAR + RECORDING
Best Value Pack
LIVE WITH RECORDED $ 299
Live with Rec. webinar presentation with audio and slideshow, single-user
unlimited access to any compatible device for 6 months. (Access information will
be emailed 24 hours after the completion of live webinar)
LIVE WITH DIGITAL $ 349
Live with the downloadable recording of a webinar along with presentation slides
and reference manual. Unlimited access on any compatible device for 1
year. (Access information will be emailed 24 hours after the completion of live
webinar)
RECORDED OPTIONS
Best Value Pack
RECORDED $ 199
Rec. webinar presentation with audio and slideshow, single user unlimited access
for 6 months.
DIGITAL DOWNLOAD $ 298
Audio recording of a webinar and reference manual delivered by download. Listen
anytime on any compatible device for 1 year.
Refund Policy
Add to Cart
Data is important. Locating specific data is important. Being sure that the
correct data is being input is critical. Thanks to Conditional Formatting, you
can highlight all information that is important to you (the highest or lowest
values, duplicate values, values that are larger or smaller than a certain
value). This will provide you with the necessary information to make important
business decisions. Conditional formatting is one of the major strengths of
Excel!
Why Should You Attend
To be sure that the data is entered accurately, use Data Validation to restrict
the input type of a value based on a specific set of criteria. Trying to enter
data that does not meet the criteria will generate an error message.
Create a drop-down list of items in a cell with data validation. This will make
data entry easier, and reduce input errors and typing mistakes.
Both of these tools give you greater control over the data you are working with.
With Conditional Formatting, we’ll show you how massive amounts of data can be
analyzed to visually emphasize relationships, find exceptions, and spot trends.
Conditional formatting can change the format of cells based on their values in
multiple ways including font style, underline style, font color, fill color and
more.
Adding your own formula to a conditional formatting rule gives it a power boost
to help you do things the built-in rules can’t do.
Data bars can be used to show the value of a cell relative to other cells. Data
bars can be modified multiple ways.
Color scales shows data distribution and variation. Shades of color represent
high, middle and low values. A variety of color combinations are available.
Icon sets allow annotation and classification of data into three to five
categories using icons. It is possible to customize icon sets.
To be sure that the data is entered accurately, use Data Validation to restrict
the input type of a value based on a specific set of criteria. Trying to enter
data that does not meet the criteria will generate an error message.
Settings include value type, such as decimal, date, and time. Ranges can be set
here. Input messages can be generated to give the user a description of the data
allowed in the cell. Error messages can be customized to describe the error a
user encounters when invalid data is entered.
Create a drop-down list of items in a cell with data validation. This will make
data entry easier, and reduce input errors and typing mistakes.
Invalid data can automatically be highlighted in a worksheet.
Areas Covered in the Session
How to use conditional formatting in Excel
» Types of conditional formats
» Highlighting cells rules
» Applying data bars, color scales and icon sets
» Removing conditional formatting
» Modifying conditional formatting
» Using the conditional formatting rules manager
» Creating conditional formatting based on a formula
Using Data Validation
» Using the data validation dialog box
» Creating data validation criteria
» Modifying and removing data validation
» Creating an input message
» Modifying the error message
» How to create drop down list in Excel for data entry
» Copying a drop-down list to multiple columns or rows
Who Will Benefit
» Business Owners
» CEO's / CFO's / CTO's
» Managers
» Accountants
» CPA's
» Financial Consultants
» IT Professionals
» Auditors
» Human Resource Personnel
» Bookkeepers
» Marketers
» Anybody with large amounts of Data
» Anybody who uses Microsoft Excel on a regular basis, and wants to be more
efficient and productive
Cathy Horwitz
Cathy Horwitz believes that when your employees know the capabilities of the
software they use, they will demonstrate improved productivity, will be more
efficient and will be able to problem solve more easily.
Cathy teaches classes on the Microsoft suite of application software including
Excel, PowerPoint, Word, Access and Outlook. Cathy has over 30 years of
experience in classroom and virtual training and has been an instructor of
Microsoft Office since 1989.
Her strengths include customizing classes based on the needs of individual
students and providing realistic business examples to compliment training. She
is a high energy trainer with a flair for training the adult student.
She holds the Modern Classroom Certified Trainer certification from Logical
Operations which prepares instructors for all aspects of delivering a course
using the latest training technologies and approaches.
When not teaching, Cathy enjoys gardening, shopping estate sales and refinishing
mid-century furniture.
NOT RELEVANT ? CLICK HERE TO SELECT YOUR PERTINENT INDUSTRY.
RECENTLY MICROSOFT TRAINING COURSES WEBINARS UPCOMING WEBINAR
*
*
WEBINARS BY THIS KEYNOTE SPEAKER
* Recorded Webinars
* Live Webinars
Live webinar
USING EXCEL'S CONDITIONAL FORMATTING AND DATA VALIDATION TOOL
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Nov 17, 2022
Duration : 60 Min
01:00 PM ET / 10:00 AM PT
Webinar Id: 70066
Learn more
Record webinar
VISUALIZING EXCEL DATA WITH SMARTART AND CHARTS
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 60 Min
Webinar Id: 70051
Learn more
Record webinar
USING EXCEL PIVOTTABLES TO EASILY SUMMARIZE AND ANALYZE DATA
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 75 Min
Webinar Id: 70061
Learn more
Record webinar
EXPLORING EXCEL'S TOP TEN ESSENTIAL FUNCTIONS
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 90 Min
Webinar Id: 70062
Learn more
Record webinar
EXCEL FUNCTIONS AND LOOKUP FORMULAS: USING VLOOKUP, HLOOKUP, MATCH, INDEX AND
MORE...
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 75 Min
Webinar Id: 70045
Learn more
Record webinar
CREATING SMART PRESENTATIONS: INTEGRATING WORD EXCEL AND PPT
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 90 Min
Webinar Id: 70068
Learn more
Record webinar
TIPS AND TOOLS FOR MANAGING EXCEL LISTS AND DATABASES
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 90 Min
Webinar Id: 70063
Learn more
Record webinar
HOW TO USE MICROSOFT EXCEL PIVOT TABLES TO EASILY SUMMARIZE AND ANALYZE DATA
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 75 Min
Webinar Id: 70203
Learn more
Record webinar
MASTERING EXCEL CHARTS AND GRAPHS - COMMUNICATE INSIGHTS MORE EFFECTIVELY
Cathy Horwitz
Microsoft Office Instructor & Consultant at PC Training and Consulting
Duration : 60 Min
Webinar Id: 70064
Learn more
CONTACT US
* Live Webinar
* Recorded Webinar
* Digital Marketing
* Customized Package
QUICK LINKS
* Suggest A Topic
* Ask A Question
* Speaking Opportunity
* Subscribe Newsletter
REACH US
* IT Consulting
* Disclaimer
* Site Map
* Anti Spam Policy
USEFUL LINKS
* Privacy Policy
* Terms & condition
* Refund, Cancellation Policy
* Unsubscribe
*
*
secured by
*
*
*
*
*
COPYRIGHT © 2022 CONCORDEDUCATIONS.COM ALL RESERVED.