educba7.teachable.com Open in urlscan Pro
104.17.83.54  Public Scan

Submitted URL: https://www.mailing.educba.com/click.html?x=a62e&lc=A4CTA&mc=a&s=5lCpyS&u=3&z=lLMVBIn&
Effective URL: https://educba7.teachable.com/p/excel-comprehensive-training2
Submission: On October 28 via manual from NL — Scanned from NL

Form analysis 2 forms found in the DOM

GET https://educba7.teachable.com/purchase

<form class="block__pricing flex-grow" action="https://educba7.teachable.com/purchase" method="get">
  <input type="hidden" name="course_id" value="2660540" id="course_id">
  <div class="block__pricing__heading empty_state__heading-text b-181816937-heading_text_color rich-text">
    <h4>
      <strong style="color:rgb(5, 65, 4);">Choose a Pricing Option</strong><br class="softbreak">
    </h4>
  </div>
  <div class="block__pricing__plans">
    <label for="5897431">
      <section class="block__pricing__plan" data-id="5897431">
        <div class="block__pricing__plan__radio-wrapper">
          <input checked="" class="radio block__pricing__plan__radio" name="product_id" type="radio" id="5897431" value="5897431">
          <div class="block__pricing__plan__radio__custom-indicator"></div>
        </div>
        <div class="block__pricing__plan__text">
          <div class="block__pricing__plan__price" data-include-vat-price="5897431">$14.52 every 3 months</div>
          <h3 class="block__pricing__plan__name">EDUCBA</h3>
          <h4 class="block__pricing__plan__subtitle">
          </h4>
          <span htmlfor="5897431" class="hidden bnpl__installments__text product_5897431">or pay in installments:</span>
          <div htmlfor="5897431" id="payment-method-messaging-element" class="product_5897431 hidden"></div>
          <div class="block__pricing__plan__description__container" data-collapsed="false">
            <button class="block__pricing__plan__description__show-button expanded auto_expanded" type="button">
              <span class="block__pricing__plan__description__show-button__text" data-more="More" data-less="Less">Less</span>
              <span class="block__pricing__plan__description__show-button__icon"></span>
            </button>
            <div class="block__pricing__plan__description" aria-hidden="false">
              <span> This is a subscription product billed on a quarterly basis until you cancel. Cancel anytime from the account management page. <span class="block__pricing__plan__disclosure" data-include-vat-price="5897431">Contact EDUCBA at
                  <a target="_blank" rel="noopener" href="mailto:learning@educba.com">EDUCBA</a> for more info.</span>
              </span>
            </div>
          </div>
        </div>
      </section>
    </label>
    <label for="5914436">
      <section class="block__pricing__plan" data-id="5914436">
        <div class="block__pricing__plan__radio-wrapper">
          <input class="radio block__pricing__plan__radio" name="product_id" type="radio" id="5914436" value="5914436">
          <div class="block__pricing__plan__radio__custom-indicator"></div>
        </div>
        <div class="block__pricing__plan__text">
          <div class="block__pricing__plan__price" data-include-vat-price="5914436">$22.99 every 6 months</div>
          <h3 class="block__pricing__plan__name">EXCEL-EDUCBA02</h3>
          <h4 class="block__pricing__plan__subtitle">
          </h4>
          <span htmlfor="5914436" class="hidden bnpl__installments__text product_5914436">or pay in installments:</span>
          <div htmlfor="5914436" id="payment-method-messaging-element" class="product_5914436 hidden"></div>
          <div class="block__pricing__plan__description__container" data-collapsed="true">
            <button class="block__pricing__plan__description__show-button" type="button">
              <span class="block__pricing__plan__description__show-button__text" data-more="More" data-less="Less">More</span>
              <span class="block__pricing__plan__description__show-button__icon"></span>
            </button>
            <div class="block__pricing__plan__description hidden">
              <span> This is a subscription product billed on a semi-annual basis until you cancel. Cancel anytime from the account management page. <span class="block__pricing__plan__disclosure" data-include-vat-price="5914436">Contact EDUCBA at
                  <a target="_blank" rel="noopener" href="mailto:learning@educba.com">EDUCBA</a> for more info.</span>
              </span>
            </div>
          </div>
        </div>
      </section>
    </label>
  </div>
  <div class="block__pricing__button-wrapper">
    <button id="enroll-button" class="block__pricing__button b-181816937-button_border_radius base-button" type="submit">Enroll now</button>
    <script>
      $(document).ready(function() {
        $("form.block__pricing").on("submit", function(event) {
          $("#enroll-button").attr("disabled", true);
          $("#enroll-button").addClass("disabled");
          $("#enroll-button").text("Processing...");
        });
      });
    </script>
  </div>
</form>

<form onsubmit="return false" data-block-id="181816938" data-source="Email Leads" data-ss-school-id="2208765">
  <h4 class="b-181816938-heading_text_color"><strong>Let’s keep in touch</strong></h4>
  <p>Subscribe to the mailing list and receive the latest updates</p>
  <fieldset>
    <div>
      <label for="email">Email Address</label>
      <input type="email" name="email" class="block__email_leads__input" required="">
    </div>
    <div class="block__email_leads__checkbox_wrapper">
      <input type="checkbox" name="consent" class="block__email_leads__checkbox" required="">
      <label for="consent"> By clicking this checkbox, you consent to receiving emails from this school or course </label>
    </div>
  </fieldset>
  <button class="base-button" type="submit">Subscribe</button>
  <p class="disclaimer_text">We respect your privacy.</p>
  <div class="block__email_leads__error"></div>
</form>

Text Content

   
 * Login
 * Sign Up


EXCEL COMPRESHENSIVE COURSE


THIS EXCEL COURSE INCLUDES 02 COURSES WITH 17+ HOURS OF VIDEO TUTORIALS AND YOU
WILL ALSO GET VERIFIABLE CERTIFICATES WHEN YOU COMPLETE THEM.

YOU WILL LEARN EXCEL FUNCTIONS, FORMULAS, CHARTS, AND GRAPHS, PIVOT TABLES,
EXCEL DASHBOARD CREATION, SIMULATIONS IN EXCEL.


Enroll Now

COURSE OVERVIEW


2 Courses and 17+ hours of tutorials on the Excel Comprehensive Training Course


CORE COVERAGE


You will learn Excel Functions, Formula, Charts, and Graphs, formatting, pivot
tables, power pivot, power excel, excel dashboard creation, simulations,
statistical tools, financial functions in excel


ELIGIBILITY


Anyone who is serious about mastering Microsoft Excel

Anytime, Anywhere Access: Learn at your own pace, wherever you are

Verifiable Certificates: Earn certificates for course completion



EXCEL COMPREHENSIVE COURSE CURRICULUM


  Basic Excel Training
Available in days
days after you enroll
 * accessing MS Excel new (2:41) Preview
 * MS Excel Startup Screen (2:27) Preview
 * Understanding the Ribbon (3:03) Preview
 * Cells in Excel (1:18) Start
 * Worksheet Essentials (3:10) Start
 * Saving the File (1:14) Start
 * Custom Cell Styles (6:12) Start
 * Custom Number Formatting in Excel (11:39) Start
 * More on Custom Number Formatting (10:59) Start
 * Custom Formats of Data (13:33) Start
 * The BEDMAS Order of Mathematical Operations (9:04) Start
 * Mathematical Operations without Functions (9:43) Start
 * Mathematical Operations without Functions Continued (11:38) Start
 * IF Function (10:32) Start
 * More on IF Function (8:25) Start
 * Importing Data and Calculations (10:46) Start
 * Working with the Count Function (4:57) Start
 * Conditional Counts - CountIF Function (4:58) Start
 * Working with the Sum Function (14:02) Start
 * Finding the Average (11:17) Start
 * Conditional Average - Average IFS Function (8:31) Start
 * Finding the Maximum Value Using the MAX Function (8:36) Start
 * Finding the Minimum Value Using the MINFS Function (8:04) Start
 * Determining Proportions and Updating a Calculation (10:06) Start
 * Conditional Formatting new1 (18:24) Start
 * More on Conditional Formatting (7:47) Start
 * Working with Tables (13:03) Start
 * Formatting Table (13:31) Start
 * Filtering and Sorting of Data (9:40) Start
 * Freeze and Split (11:18) Start
 * Printing and Layouts in Excel (9:51) Start
 * Pivot Tables (7:50) Start
 * Creating Custom Tables (8:58) Start
 * Organizing Pivot Tables (8:35) Start
 * Column Chart (10:32) Start
 * Bar Chart (8:03) Start
 * Line Chart (14:24) Start
 * Pie Chart (10:27) Start
 * Map Chart (6:46) Start
 * Common Errors in Excel (11:12) Start
 * More on Common Errors (13:42) Start
 * Accessing MS Excel (2:41) Start
 * Formatting Cells (14:23) Start

  Advanced Excel Training
Available in days
days after you enroll
 * Logical Function - IF new (8:21) Preview
 * AND OR and XOR Functions (8:48) Start
 * IFS Function - Example 1 (6:25) Start
 * IFS Function - Example 2 (9:02) Start
 * SWITCH Function (10:17) Start
 * Other Logical Functions (8:20) Start
 * Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT (10:49)
   Start
 * Date Functions - TODAY DAY (9:36) Start
 * MONTH YEAR WEEKDAY WEEKNUM Functions (11:23) Start
 * EDATE and EOMONTH Functions (8:38) Start
 * YEARFRAC Function (7:19) Start
 * Joining Data using CONCAT and TEXTJOIN (9:59) Start
 * LEN FIND LEFT RIGHT TRIM (10:26) Start
 * Using UNIQUE and TRANSPOSE (11:27) Start
 * TEXT Function (10:00) Start
 * CHOOSE Function (10:46) Preview
 * More on CHOOSE Function (6:34) Start
 * VLookUp Function (12:47) Start
 * HLOOKUP Function (5:12) Start
 * Index Function (10:31) Start
 * Match Function (9:24) Start
 * XLOOKUP and XMATCH Functions (8:43) Start
 * Using the OFFSET Function (8:49) Start
 * OFFSET Function - Total and Average Score (9:29) Start
 * OFFSET Function - Highest and Lowest Score (8:57) Start
 * OFFSET Function - Year to Month Sales (11:01) Start
 * OFFSET Function - Quarterly and Half-Month Sales (6:39) Start
 * Naming of Cell (12:30) Start
 * Naming a Range (10:01) Start
 * Text to Columns (6:35) Start
 * Grouping Tabs and Subtotal Function (12:47) Start
 * Working with Hyperlinks (11:17) Start
 * Data Validation (11:00) Start
 * Data Validation Continued (11:14) Start
 * Custom Data Validation (12:17) Start
 * Generating Random Numbers (6:10) Start
 * Custom Views (10:34) Start
 * Protecting Worksheet and Workbook (17:36) Start
 * PivotTable - Advanced Features (10:02) Start
 * More on Advanced Features (6:50) Start
 * Slicers and Timelines (6:43) Start
 * Solver (11:37) Start
 * Data Tables (10:42) Start
 * More on Data Tables (9:53) Start
 * Goal Seek (8:43) Start
 * Combo Charts (13:51) Start
 * More on Combo Charts (12:11) Start
 * Sparklines (8:10) Start
 * Waterfall Chart (9:37) Start
 * Box Chart (12:48) Start
 * Whisker Chart (11:29) Start
 * TreeMap and Sun Burst Charts (11:53) Start
 * Radar Chart (7:55) Start
 * Scroll Bar (10:00) Start
 * Spin Button and Radio Button (10:52) Start
 * Form Control Application (10:01) Start
 * Form Control Application Continued (5:32) Start
 * Data Entry Form (3:44) Start

CHOOSE A PRICING OPTION


$14.52 every 3 months


EDUCBA



or pay in installments:

Less
This is a subscription product billed on a quarterly basis until you cancel.
Cancel anytime from the account management page. Contact EDUCBA at EDUCBA for
more info.
$22.99 every 6 months


EXCEL-EDUCBA02



or pay in installments:

More
This is a subscription product billed on a semi-annual basis until you cancel.
Cancel anytime from the account management page. Contact EDUCBA at EDUCBA for
more info.
Enroll now

LET’S KEEP IN TOUCH

Subscribe to the mailing list and receive the latest updates

Email Address
By clicking this checkbox, you consent to receiving emails from this school or
course
Subscribe

We respect your privacy.


Check your inbox to confirm your subscription
 * © EDUCBA 2024

 * Terms of Use
 * Privacy Policy
 * Teach Online with

Completed Incomplete Incomplete disabled