urlscan.io logo urlscan.io
SecurityTrails logo

www.teachexcel.com Open in urlscan Pro
216.92.234.45  Public Scan

Back to summary
URL: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=newsletter_bottom
Submission: On December 29 via api from US — Scanned from DE

Form analysis 5 forms found in the DOM

POST /login/

<form id="login_form" method="post" action="/login/">
  <input type="hidden" name="curpage" value="https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=newsletter_bottom">
  <div class="login_bar_element_container"> Email: <input class="login_bar_input_field" name="email" type="text">
  </div>
  <div class="login_bar_element_container"> Pass: <input class="login_bar_input_field" name="password" type="password">
  </div>
  <div class="login_bar_element_container">
    <input class="login_bar_login_button" type="submit" value="Login">&nbsp;&nbsp; <a href="https://www.teachexcel.com/gen.php?l=forgot_pass">Pass?</a>
  </div>
</form>

Name: subscribe — POST 

<form action="" name="subscribe" method="post">
  <script async="async" language="JavaScript" src="//www.teachexcel.com/includes/code/js/email_submit_ajax.js" type="text/javascript"></script>
  <span style=" color:#000; font-size:20px; margin-left:25px;"> Join over 20,000 People! </span>
  <span style="color:#FFF; font-size:22px; font-weight:bold; margin-left:15px; margin-right:15px;"> Excel Tips in Your Email </span>
  <input style="width:225px; font-size:18px; padding:2px; color:lightgray;" type="text" id="email_top_floating_bar" name="email_top_floating_bar" value="Enter Your Email Here"
    onfocus="this.value = this.value=='Enter Your Email Here'?'':this.value;this.style.color = 'black';" onblur="this.value = this.value==''?'Enter Your Email Here':this.value;this.style.color = 'lightgray';">
  <span style="padding-left:20px;"></span>
  <input style="font-size:18px; padding:4px 6px 4px 6px;" type="button" name="send_request_button" value="Subscribe" onclick="ajax_email_subscribe('email_top_floating_bar','request_response_top_floating_bar','topfloatingbar');">
  <div id="request_response_top_floating_bar" style="text-align:center;"></div>
</form>

POST https://www.teachexcel.com/billing/billing.php?p=1

<form id="cart_page_checkout" method="post" action="https://www.teachexcel.com/billing/billing.php?p=1">
  <input type="hidden" name="gowh" value="cart_checkout">
  <input type="hidden" name="curpage" value="https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=newsletter_bottom">
  <input class="s_cart_preview_checkout_button" type="submit" value="Nothing in Cart" disabled="">
</form>

GET //www.teachexcel.com/store/mask.php

<form id="fillcart" method="get" action="//www.teachexcel.com/store/mask.php">
  <input type="hidden" name="cartpid" value="37">
  <input type="hidden" name="cartpq" value="1">
  <input type="hidden" name="a" value="addtocart">
  <input type="hidden" name="src" value="course_category_page_purchase_btn_above_promo_video">
  <input type="hidden" name="curpage" value="https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=newsletter_bottom">
  <input class="btn_general register_button btn_round_med btn_standout" type="submit" style="font-size: 28px; font-weight: bold; padding: 13px 15px 13px 15px;" value="Add to Cart">
</form>

GET //www.teachexcel.com/store/mask.php

<form id="fillcart" method="get" action="//www.teachexcel.com/store/mask.php">
  <input type="hidden" name="cartpid" value="37">
  <input type="hidden" name="cartpq" value="1">
  <input type="hidden" name="a" value="addtocart">
  <input type="hidden" name="src" value="course_category_page_purchase_btn_below_promo_video">
  <input type="hidden" name="curpage" value="https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=newsletter_bottom">
  <input class="btn_general register_button btn_round_med btn_standout" type="submit" style="font-size: 26px; font-weight: bold; padding: 13px 15px 13px 15px;" value="Add to Cart">
</form>

Text Content

Create Account
Email:
Pass:
   Pass?


Join over 20,000 People! Excel Tips in Your Email

Excel Courses
Shopping Cart

Empty View Cart


Excel Courses > Professional Forms in Excel


PROFESSIONAL FORMS IN EXCEL


BUILD PROFESSIONAL FORMS IN EXCEL


ONLINE VIDEO COURSE - INSTANT ACCESS


VIEW THE INTRODUCTION VIDEO BELOW AND SEE IF THIS COURSE IS FOR YOU!

Tutorials: 45 | Length: 5+ Hours | Excel Files Included: Yes





Price: $49.50 (usd)




IF YOU CAN'T VIEW THIS VIDEO, YOU WON'T BE ABLE TO PARTICIPATE IN THE COURSE. To
view this video please enable JavaScript, and consider upgrading to a web
browser that supports HTML5 video



Video Player is loading.
Play Video
Play
Mute

Current Time 0:00
/
Duration 6:32
Loaded: 0%



Progress: 0%
Stream Type LIVE
Remaining Time -6:32
 
Playback Rate

1x
Chapters
 * Chapters

Descriptions
 * descriptions off, selected

Captions
 * captions settings, opens captions settings dialog
 * captions off, selected

Audio Track

Fullscreen

This is a modal window.



Beginning of dialog window. Escape will cancel and close the window.

TextColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentBackgroundColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparentWindowColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque
Font Size50%75%100%125%150%175%200%300%400%Text Edge
StyleNoneRaisedDepressedUniformDropshadowFont FamilyProportional
Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall
Caps
Reset restore all settings to the default valuesDone
Close Modal Dialog

End of dialog window.


INSTANT ACCESS! - LIFETIME ACCESS!


45 TUTORIALS - 5+ HOURS OF CONTENT - DOWNLOADABLE EXCEL FILES


BUILD PROFESSIONAL - UNBREAKABLE - FORMS IN EXCEL


THESE FORMS ALLOW YOU TO INPUT, VIEW, STORE, UPDATE, AND DELETE DATA IN EXCEL.


EACH TUTORIAL COMES WITH A VIDEO WALK-THROUGH AND DOWNLOADABLE EXCEL FILE.

Original Price $99 >>> Now $49.50 (usd)



SALE ENDS SOON

(50% Discount)



Price: $49.50 (usd)





INTRODUCTION > INTRODUCTION TO THE COURSE

Course introduction and overview.



--------------------------------------------------------------------------------


INTRODUCTION

6:32
Introduction to the Course



FORMATTING

10:35
Formatting the Form

2:28
Consistent Button Formatting

5:11
Different Button Styles

7:14
Hide Entire Excel Interface

2:25
Stop Buttons from Resizing



VALIDATION

28:44
Adding Validation to the Form

6:37
Limit ID Field to a Number (Advanced Methods)

6:22
Require Leading Zeros for an ID

1:55
Data Entry Hints using Input Messages



MACRO AND ERROR DISPLAY

17:58
Add Error Display and Macro Functionality to the Form

2:06
Custom Error Display

4:05
Name Cells for Easier Macro Reference

3:37
Additional Worksheet References in the Macro



PROTECT THE FORM

14:44
Protect the Form

2:52
Hide Data Columns

2:44
Secure Helper Worksheets

2:13
Password Protect the Entire Workbook



SAVE FORM DATA

18:41
Save Form Data

16:20
Keep Formatting when Saving Data

3:22
Keep Leading Zeros when Saving Data

13:36
Prevent Duplicate Entries

5:05
Hide and Protect the Data Worksheet

6:33
Password Protect the Data Worksheet

6:35
Use Form Field Range Variables

5:25
Name Form Ranges for Better Macro Use and Readability



VIEW SAVED DATA USING THE FORM

23:35
View Saved Data

2:14
Case Sensitive Search

1:55
Partial Match Search

2:49
Return the Last Record - Bottom-to-Top Search



UPDATE DATA USING THE FORM

13:13
Update Data

13:07
Request Update Confirmation

14:04
Require a Password to Update a Record

5:42
Update only Certain Fields from the Form



DELETE DATA USING THE FORM

17:03
Delete Data

2:57
Delete Data without Using a Popup Window

2:17
Prevent Title Row Deletion

6:10
Request Delete Confirmation

7:07
Require a Password to Delete a Record

7:28
Reset Form Validation after Deleting Data



ADDITIONAL TOPICS

2:13
Add or Remove Password Protection for the Macros and VBA Project

4:56
Better VBA for Clearing the Form

2:13
Clear Form Button

3:43
Ensure ID Values are Stored and Retrieved Correctly

3:31
Remove Auto-Password Protect Option in VBA

1:25
Rename VBA Modules for Better Readability


Contact | Privacy Policy | Disclaimer | Terms
Copyright© 2023 TeachExcel.com