www.concordeducations.com
Open in
urlscan Pro
192.124.249.108
Public Scan
Submitted URL: https://email.concordeducations.com/pub/cc?_ri_=X0Gzc2X%3DAQpglLjHJlCQGvdDUL5f73DHthu77o2zeajcODTNBNJ0PjLzgzgktfze4v7rniPgVXtpKX%3DS...
Effective URL: https://www.concordeducations.com/Product/details/70050?utm_source=Dec06_70005_RAdler_Jan13&utm_campaign=70005_TP&utm_medium=Respo...
Submission: On February 22 via manual from NL — Scanned from NL
Effective URL: https://www.concordeducations.com/Product/details/70050?utm_source=Dec06_70005_RAdler_Jan13&utm_campaign=70005_TP&utm_medium=Respo...
Submission: On February 22 via manual from NL — Scanned from NL
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="70050">
<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="Advanced Excel Skills for Accountants">
<input type="hidden" id="WEBINAR_ID" name="WEBINAR_ID" value="70050">
<input type="hidden" id="SPEAK_NAME" name="SPEAK_NAME" value="David Ringstrom">
<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 $ 159</span>
<input type="checkbox" name="LIVE_SESSION[]" id="LIVE_SESSION0" style="margin-top: 15px;" onclick="calculatePrice(this.value,'LIVE', this.checked,0);" value="6462-159-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="6463-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="6464-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="6465-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="6466-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="6467-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="6468-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="6469-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="6470-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="6471-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="6472-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="6473-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="6474-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="6475-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
Advanced Excel Skills for Accountants
Click For Bio
×
OPTION INFORMATION
David Ringstrom
President, Accounting Advisors, Inc.
Training made by Speaker
David H. Ringstrom, CPA, is an author and nationally recognized instructor who
teaches scores of webinars each year. His Excel courses are based on 25 years of
consulting and teaching experience. David’s mantra is "Either you work Excel, or
it works you," so he focuses on what he sees users don’t, but should, know about
Microsoft Excel. His goal is to empower you to use Excel more effectively.
Close
Schedule
March 14, 2022 || 01:00 PM ET / 10:00 AM PT
Duration
60 Mins
Level
Intermediate
Webinar ID
70050
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
20 DAYS LEFT REGISTER
Add to Cart
×
REGISTRATION OPTIONS
$00
Add to Cart
LIVE WEBINAR ONLY
1 ATTENDEE $ 159
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
Excel expert David Ringstrom, CPA, explains helpful ways you can improve the
integrity of your spreadsheets using Excel’s lookup functions and pivot tables.
In this comprehensive presentation, David reveals alternatives to VLOOKUP,
including the HLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, and IFNA. You’ll also get
a preview of the new XLOOKUP function being added to Microsoft 365. Lookup
functions are only the start, though. In many cases you’re only a few mouse
clicks away from transforming overwhelming lists of data into meaningful
reports.
David demonstrates every technique at least twice: first, on a PowerPoint slide
with numbered steps, and second, in the Microsoft 365 (formerly known as Office
365) version of Excel. David draws your attention to any differences in the
older versions of Excel (2019, 2016, 2013, and earlier) during the presentation
as well as in his detailed handouts. David also provides an Excel workbook that
includes most of the examples he uses during the webcast.
Microsoft 365 is a subscription-based product that provides new-feature updates
as often as monthly. Conversely, the perpetual licensed versions of Excel have
feature sets that don’t change. Perpetual licensed versions have year numbers,
such as Excel 2019, Excel 2016, and so on.
Why Should You Attend
» Apply a variety of lookup functions in order to work more efficiently in
Excel.
» Recognize why the INDEX and MATCH combination is often superior to VLOOKUP or
HLOOKUP.
» Contrast pivot tables to lookup functions.
Areas Covered in the Session
» Adding fields to a blank pivot table to create instant reports.
» Contrasting the INDEX and MATCH combination to VLOOKUP or HLOOKUP.
» Creating a pivot table to transform lists of data into on-screen reports.
» Determining which refresh commands in Excel update a single pivot table
versus all pivot tables in a workbook.
» Discovering four different ways to remove data from a pivot table report.
» Discovering how to use wildcards and multiple criteria within lookup
formulas.
» Distinguishing the differences among pivot table-related menus in Excel 2013
and later versus older versions of Excel.
» Employing the SUMIF function to sum values related to multiple instances of
criteria you specify.
» Explaining the new XLOOKUP worksheet function being rolled out to Microsoft
365 users.
» Filtering data within pivot tables in Excel 2010 and later by way of the
Slicer feature.
» Identifying situations where VLOOKUP may return #N/A instead of a value.
» Identifying the ideal data for analysis with Excel’s PivotTable feature.
» Integrating data on web pages into your workbooks and creating automatic
links.
» Learning about the IFNA function available in Excel 2013 and later.
» Learning what types of user actions can trigger #REF! errors.
» Performing dual lookups, which allow you to look across columns and down rows
to cross-reference the data you need.
» Summarizing data from Access databases with pivot tables, even if you don’t
have Microsoft Access installed.
» Transforming numbers stored as text into values by way of the Text to Columns
wizard.
» Understanding how the VLOOKUP function allows you to look up data instead of
having to manually reference individual cells.
» Using the HLOOKUP function to look horizontally across rows in any version of
Excel.
» Using the MATCH function to find the position of an item in a list.
» Using the SUMIFS function to sum values based on multiple criteria.
» Using VLOOKUP to perform approximate matches.
» Utilizing Excel’s IFERROR function to display alternate values when VLOOKUP
returns an error.
Who Will Benefit
» Accountants
» CPAs
» CFOs
» Controllers
» Income Tax Preparers
» Enrolled Agents
» Financial Consultants
» IT Professionals
» Auditors
» Human Resource Personnel
» Bookkeepers
» Excel Users
» Marketers
» Government Personnel
David Ringstrom
David H. Ringstrom, CPA, is an author and nationally recognized instructor who
teaches scores of webinars each year. His Excel courses are based on 25 years of
consulting and teaching experience. David’s mantra is "Either you work Excel, or
it works you," so he focuses on what he sees users don’t, but should, know about
Microsoft Excel. His goal is to empower you to use Excel more effectively.
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
ADVANCED EXCEL SKILLS FOR ACCOUNTANTS
David Ringstrom
President, Accounting Advisors, Inc.
Mar 14, 2022
Duration : 60 Min
01:00 PM ET / 10:00 AM PT
Webinar Id: 70050
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.