auroratrainingadvantage.com Open in urlscan Pro
67.222.139.58  Public Scan

Form analysis
1 forms found in the DOM

Name: formCart — POST https://auroratrainingadvantage.com/cart/webinar/live/

<form id="formCart" name="formCart" action="https://auroratrainingadvantage.com/cart/webinar/live/" method="post" enctype="multipart/form-data" role="form"> <input type="hidden" name="_token" value="KYVHriaNf68Ex2n9QUjdCDrZLHfo6JhqlOJ3QE2N"> <input
    type="hidden" id="eco_product_id" name="eco_product_id" value="1985960343">
  <div class="modal-header">
    <h5 class="modal-title">Using AI in and with Microsoft Excel</h5> <button type="button" class="close" data-dismiss="modal">×</button>
  </div>
  <div class="modal-body">
    <div class="container-fluid">
      <div class="row">
        <div class="col text-center form-group" data-toggle="tooltip" data-placement="top" title=""
          data-original-title="This option allows you to attend the live webinar and then receive access to the online video recording after the event as well. Your access to the recording is good for 12 months.">
          <h6>Live Webinar + Recording</h6>
          <h3 id="price-both">$298.00</h3> <label for="attendee-both" class="d-none">Both Live and Recorded Webinar Attendees:</label> <select id="selAttendeeBoth" name="attendee-both" class="checkForBlankSubmission form-control">
            <option selected="" data-price="$0.00" value="0"> No Attendee </option>
            <option data-price="$298.00" value="1"> 1 Attendees - $298.00 </option>
            <option data-price="$377.00" value="2"> 2 Attendees - $377.00 </option>
            <option data-price="$456.00" value="3"> 3 Attendees - $456.00 </option>
            <option data-price="$535.00" value="4"> 4 Attendees - $535.00 </option>
            <option data-price="$614.00" value="5"> 5 Attendees - $614.00 </option>
            <option data-price="$693.00" value="6"> 6 Attendees - $693.00 </option>
            <option data-price="$772.00" value="7"> 7 Attendees - $772.00 </option>
            <option data-price="$851.00" value="8"> 8 Attendees - $851.00 </option>
            <option data-price="$930.00" value="9"> 9 Attendees - $930.00 </option>
            <option data-price="$1,009.00" value="10"> 10 Attendees - $1,009.00 </option>
            <option data-price="$1,088.00" value="11"> 11 Attendees - $1,088.00 </option>
            <option data-price="$1,167.00" value="12"> 12 Attendees - $1,167.00 </option>
            <option data-price="$1,246.00" value="13"> 13 Attendees - $1,246.00 </option>
            <option data-price="$1,325.00" value="14"> 14 Attendees - $1,325.00 </option>
            <option data-price="$1,404.00" value="15"> 15 Attendees - $1,404.00 </option>
          </select>
        </div>
        <div class="col text-center form-group border border-top-0 border-bottom-0" data-toggle="tooltip" data-placement="top" title=""
          data-original-title="This option allows you to attend the live webinar on the date and time indicated. You can interact with the speakers through a chat box and ask questions that will be answered either during the program or at the end of the presentation during a Q&amp;A session.">
          <h6>Live Webinar Only</h6>
          <h3 id="price-live">$219.00</h3> <label for="attendee-live" class="d-none">Live Webinar Attendees:</label> <select id="selAttendeeLive" name="attendee-live" class="checkForBlankSubmission form-control">
            <option selected="" data-price="$0.00" value="0"> No Attendee </option>
            <option data-price="$219.00" value="1"> 1 Attendees - $219.00 </option>
            <option data-price="$298.00" value="2"> 2 Attendees - $298.00 </option>
            <option data-price="$377.00" value="3"> 3 Attendees - $377.00 </option>
            <option data-price="$456.00" value="4"> 4 Attendees - $456.00 </option>
            <option data-price="$535.00" value="5"> 5 Attendees - $535.00 </option>
            <option data-price="$614.00" value="6"> 6 Attendees - $614.00 </option>
            <option data-price="$693.00" value="7"> 7 Attendees - $693.00 </option>
            <option data-price="$772.00" value="8"> 8 Attendees - $772.00 </option>
            <option data-price="$851.00" value="9"> 9 Attendees - $851.00 </option>
            <option data-price="$930.00" value="10"> 10 Attendees - $930.00 </option>
            <option data-price="$1,009.00" value="11"> 11 Attendees - $1,009.00 </option>
            <option data-price="$1,088.00" value="12"> 12 Attendees - $1,088.00 </option>
            <option data-price="$1,167.00" value="13"> 13 Attendees - $1,167.00 </option>
            <option data-price="$1,246.00" value="14"> 14 Attendees - $1,246.00 </option>
            <option data-price="$1,325.00" value="15"> 15 Attendees - $1,325.00 </option>
          </select>
        </div>
        <div class="col text-center form-group" data-toggle="tooltip" data-placement="top" title=""
          data-original-title="This is an online video recording of the live event so you see and hear everything the live attendees experienced. Your access is good for 12 months and you can view the webinar as many times as you would like. ">
          <h6>Recorded Webinar Only</h6>
          <h3 id="price-demand">$219.00</h3> <label for="attendee-demand" class="d-none">Record Webinar Attendees:</label> <select id="selAttendeeDemand" name="attendee-demand" class="checkForBlankSubmission form-control">
            <option selected="" data-price="$0.00" value="0"> No Attendee </option>
            <option data-price="$219.00" value="1"> 1 Attendees - $219.00 </option>
            <option data-price="$298.00" value="2"> 2 Attendees - $298.00 </option>
            <option data-price="$377.00" value="3"> 3 Attendees - $377.00 </option>
            <option data-price="$456.00" value="4"> 4 Attendees - $456.00 </option>
            <option data-price="$535.00" value="5"> 5 Attendees - $535.00 </option>
            <option data-price="$614.00" value="6"> 6 Attendees - $614.00 </option>
            <option data-price="$693.00" value="7"> 7 Attendees - $693.00 </option>
            <option data-price="$772.00" value="8"> 8 Attendees - $772.00 </option>
            <option data-price="$851.00" value="9"> 9 Attendees - $851.00 </option>
            <option data-price="$930.00" value="10"> 10 Attendees - $930.00 </option>
            <option data-price="$1,009.00" value="11"> 11 Attendees - $1,009.00 </option>
            <option data-price="$1,088.00" value="12"> 12 Attendees - $1,088.00 </option>
            <option data-price="$1,167.00" value="13"> 13 Attendees - $1,167.00 </option>
            <option data-price="$1,246.00" value="14"> 14 Attendees - $1,246.00 </option>
            <option data-price="$1,325.00" value="15"> 15 Attendees - $1,325.00 </option>
          </select>
        </div>
      </div>
      <div class="row border border-bottom-0 border-left-0 border-right-0 mt-3" style="position:relative;">
        <div class="text-danger" style="padding:0 5px 0 5px; background-color:#ffffff; text-align:center; z-index:1; position:absolute; top:-12px; left:50%; text-transform:uppercase; font-size:large; font-weight:bold;">or</div>
        <div class="col-sm-12 col-md-9 text-left mt-4">
          <h5>All Access Membership</h5>
          <p>The Aurora All Access Membership is designed to provide you with the training that you want when you want it. You will have 100% access to every live webinar, on demand webinar, professional alert, and podcast that Aurora Training
            Advantage offers with no additional cost.</p>
        </div>
        <div class="col-sm-12 col-md-3 text-center mt-4" data-toggle="tooltip" data-placement="top" title=""
          data-original-title="This membership gives you unlimited access to every live webinar and online video recording we offer for 12 months. You would have access to 100's of live events and online video recordings.">
          <h6>Yearly Subscription</h6>
          <h3 id="price-member">$599.00</h3> <label for="attendee-member" class="d-none">Membership Attendees:</label> <select id="selAttendeeMember" name="attendee-member" class="checkForBlankSubmission form-control">
            <option selected="" data-price="$0.00" value="0">No Attendee</option>
            <option data-price="$599.00" value="1">1 Attendee - $599.00</option>
          </select>
        </div>
      </div>
    </div>
  </div>
  <div class="modal-footer text-right"> <span id="formErrorMessage" class="text-danger" role="alert"></span> <button type="submit" id="btnAddCart" class="btn btn-info ml-2">Add to Cart</button> </div>
</form>

Text Content

 * Home
 * About
 * Training
   Articles Live Webinars On Demand Webinars Packages Podcasts Podcasts
   (Archive) Private Training
 * Membership
 * Experts
 * FAQs
 * Login

 1. Aurora Training Advantage
 2. Live Webinar
 3. Using AI in and with Microsoft Excel


LIVE WEBINAR




USING AI IN AND WITH MICROSOFT EXCEL

WEBINAR DETAILS $219

 * Webinar Date: February 12, 2024
 * Webinar Time: 2:00pm - 3:40pm EST   live
 * Webinar Length: 100 Minutes
 * Guest Speaker:   David Ringstrom
 * Topic:   Business Administration, Business Skills, Finance, Software,
   Taxation and Accounting
 * Credit:   CPE 2.0, ATATX 1.5, ATAAA 1.5, ATAOP 1.5

 * Purchase Options

 * 


 * Overview

Although artificial intelligence seems like it is suddenly permeating every
aspect of our daily lives, AI has been part of Excel for over a decade now. In
this presentation author and Excel expert David Ringstrom, CPA will walk you
through various AI-powered features in Excel, including Flash Fill, Analyze
Data, Power Query's Column From Example, extracting data from pictures and PDF
documents, and more. Of course, no discussion of AI would be complete without an
exploration of ChatGPT, so David will show you how to write and deconstruct
formulas as well as automate repetitive tasks with only a minimal understanding
of Excel's Visual Basic for Applications programming language.

David is the author of “Exploring Microsoft Excel's Hidden Treasures:
Turbocharge your Excel proficiency with expert tips, automation techniques, and
overlooked features”. He demonstrates every technique at least twice: first, on
a PowerPoint slide with numbered steps, and second, in the subscription-based
Excel for Microsoft 365. David draws your attention to any differences in Excel
2021, 2019 or 2016 during the presentation and in his detailed handouts. The
handouts include an Excel workbook with most of the examples he uses during his
demonstrations. 

Excel for Microsoft 365 is a subscription-based product that receives periodic
feature updates. Conversely, perpetually licensed versions have year numbers in
their names and do not receive any feature updates.

Topics typically covered:

 * Transforming data in Power Query by way of the Column From Example feature.
 * Creating PivotTables and PivotCharts based upon your data by asking natural
   language questions with the Analyze Data feature in Excel for Microsoft 365.
 * Linking charts to dynamic array results to create self-updating charts
   without using programming code.
 * Using the Recommended Charts feature to create suitable charts from data with
   a couple of mouse clicks.
 * Installing the free Excel Labs Add-In which enables API access to ChatGPT.
 * Extracting data from pictures by way of the From Picture command.
 * Separating first/last names into two columns without using formulas or
   retyping.
 * Jump-starting PivotTables by way of the Recommended PivotTables feature.
 * Understanding the nuance of editing dynamic array-based formulas in Excel
   2021 and Microsoft 365.
 * Using ChatGPT to create formulas in Excel based upon a written description of
   the desired calculation.
 * Deconstructing existing formulas by asking ChatGPT to explain the formula in
   detail.
 * Keep or remove rows from the start or end of an array with the TAKE and DROP
   functions.

Learning objectives:

 * State the functionality that the Flash Fill feature offers.
 * Define the purpose of the Forecast feature in Excel 2016 and later.
 * Recognize the color that dynamic array functions are displayed in within
   Excel's formula bar in all cells except the cell where the formulas was
   entered.

Skill Level: 

Beginner/Intermediate

 1.  Introduction
 2.  Formula Overview - Basic Formulas 00:02:53
 3.  Absolute 00:15:32
 4.  Date Functions 00:24:22
 5.  Age Calculation 00:41:17
 6.  Basic Functions - Sum And Average 00:48:30
 7.  Text Function 00:55:04
 8.  UPPER, LOWER, And PROPER 01:01:08
 9.  Text Functions - Text to Columns Wizard 01:05:10
 10. MID Function 01:08:09
 11. LOOKUP Functions 01:16:07
 12. VLOOKUP 01:16:23
 13. XLOOKUP 01:29:14
 14. The Difference Between True And False 01:31:44
 15. IF Function 01:35:40
 16. Presenter’s Closing And Email Address 01:39:30
 17. Presentation Closing 01:40:05

 * Absolute Reference 00:15:32, 00:45:00
 * AVERAGE 00:48:45, 00:52:11
 * Cell 00:06:53, 00:12:30, 00:30:31, 00:42:05, 01:10:24
 * Column 00:27:29, 00:30:09, 01:06:46, 01:16:33, 01:22:01
 * Formula 00:01:22, 00:05:56, 00:08:46, 00:21:59, 00:28:30, 00:36:36, 00:45:19,
   00:53:59
 * Function 00:01:22, 00:25:24 00:29:01, 00:34:40, 00:42:15
 * IF Function 01:35:40
   
 * LEFT Function 00:56:56
 * LOOKUP 01:16:07, 01:19:19, 01:24:37
 * LOWER 01:01:12
 * MID Function 01:08:15
 * PROPER 01:01:14
 * RIGHT Function 00:59:40
 * SUM 00:48:46, 00:50:25
 * Table 01:18:46, 01:20:03
 * Table Array 01:20:45
 * Text to Columns Wizard 01:05:56
 * UPPER 01:01:11
 * VLOOKUP 01:16:23, 01:19:54, 01:25:01
 * Worksheet01:24:25
 * XLOOKUP 01:29:14

AVERAGE : Returns the average (arithmetic mean) of the arguments.

Absolute Reference : Absolute references in Excel are a direct link to a
specific cell or range of cells that remain fixed if you copy or drag the
formula. Absolute references are represented by $ symbols. A $ before a column
letter freezes the column, while a $ before the row number freezes the row
number. You can freeze the column letter and/or row number when needed.

Cell: In spreadsheet applications, a cell is a box in which you can enter a
single piece of data. The data is usually text, a numeric value, or a formula.
The entire spreadsheet is composed of rows and columns of cells.

Column: A column is a vertical series of cells in a chart, table, or spreadsheet
in Excel.

Formula: A formula is an expression which calculates the value of a cell.

Function: Functions are predefined formulas and are already available in Excel.

IF Function: Use the IF function, one of the logical functions, to return one
value if a condition is true and another value if it's false. So an IF statement
can have two results. The first result is if your comparison is True, the second
if your comparison is False.

LEFT Function: The Microsoft Excel LEFT function is a function which allows you
to extract a substring from a string and starts from the leftmost character.
This is a built-in function in excel which has been categorized as a String/Text
Function.

LOOKUP: The Microsoft Excel LOOKUP function returns a value from a range (one
row or one column) or from an array. The LOOKUP function is a built-in function
in Excel that is categorized as a Lookup/Reference Function. It can be used as a
worksheet function (WS) in Excel.

LOWER : =LOWER The Microsoft Excel LOWER function converts all letters in the
specified string to lowercase. If there are characters in the string that are
not letters, they are unaffected by this function. The LOWER function is a
built-in function in Excel that is categorized as a String/Text Function.

MID Function: The Excel MID function extracts a given number of characters from
the middle of a supplied text string. For example, =MID("apple",2,3) returns
"ppl". Extract text from inside a string. The characters extracted. =MID (text,
start_num, num_chars)

PROPER: =PROPER The Microsoft Excel PROPER function sets the first character in
each word to uppercase and the rest to lowercase. The PROPER function is a
built-in function in Excel that is categorized as a String/Text Function. It can
be used as a worksheet function (WS) in Excel.

RIGHT Function : The Excel RIGHT function extracts a given number of characters
from the right side of a supplied text string.

SUM: Microsoft Excel defines SUM as a formula that “Adds all the numbers in a
range of cells”. This definition clearly points that Sum function has a job to
add numbers and the arguments can be supplied using combinations of both numbers
and range of cells. =SUM The SUM function is a built-in function in Excel that
is categorized as a Math/Trig Function. It can be used as a worksheet function
(WS) in Excel. As a worksheet function, the SUM function can be entered as part
of a formula in a cell of a worksheet

Table: A table is an arrangement of data in rows and columns, or possibly in a
more complex structure. Tables are widely used in communication, research, and
data analysis. Tables appear in print media, handwritten notes, computer
software, architectural ornamentation, traffic signs, and many other places.

Table Array: A table array is one of the arguments used in Excel's lookup
functions, such as VLOOKUP and HLOOKUP. For VLOOKUP (vertical lookup), the
table_array must contain at least two columns of data. For HLOOKUP (horizontal
lookup), the table_array must contain at least two rows of data.

Text to Columns Wizard: An Excel feature which allows users to separate data
from a single column within an Excel spreadsheet into two or more columns, or to
remove unnecessary data from within a column.

UPPER: =UPPER The Microsoft Excel UPPER function allows you to convert text to
all uppercase. The UPPER function is a built-in function in Excel that is
categorized as a String/Text Function. It can be used as a worksheet function
(WS) in Excel.

VLOOKUP: An Excel worksheet function that allows you to look up data from a list
by specifying criteria, cell coordinates for the list, column number from which
to return data, and an indication as to whether you want an exact or approximate
match.

Worksheets: A worksheet is a collection of cells where you keep and manipulate
the data. Each Excel workbook can contain multiple worksheets.

XLOOKUP: The XLOOKUP function searches a range or an array, and returns an item
corresponding to the first match it finds. If a match doesn't exist, then
XLOOKUP can return the closest (approximate) match. Where a valid match is not
found, return the [if_not_found] text you supply.

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


GUEST SPEAKER

 * DAVID H. RINGSTROM, CPA
   
   
   David H. Ringstrom, CPA, is an author and nationally recognized instructor
   who teaches scores of webinars each year. His Excel courses are based on over
   25 years of consulting and teaching experience. David’s mantra is “E [...]
   
   View Full Profile



USING AI IN AND WITH MICROSOFT EXCEL

×

LIVE WEBINAR + RECORDING


$298.00

Both Live and Recorded Webinar Attendees: No Attendee 1 Attendees - $298.00 2
Attendees - $377.00 3 Attendees - $456.00 4 Attendees - $535.00 5 Attendees -
$614.00 6 Attendees - $693.00 7 Attendees - $772.00 8 Attendees - $851.00 9
Attendees - $930.00 10 Attendees - $1,009.00 11 Attendees - $1,088.00 12
Attendees - $1,167.00 13 Attendees - $1,246.00 14 Attendees - $1,325.00 15
Attendees - $1,404.00

LIVE WEBINAR ONLY


$219.00

Live Webinar Attendees: No Attendee 1 Attendees - $219.00 2 Attendees - $298.00
3 Attendees - $377.00 4 Attendees - $456.00 5 Attendees - $535.00 6 Attendees -
$614.00 7 Attendees - $693.00 8 Attendees - $772.00 9 Attendees - $851.00 10
Attendees - $930.00 11 Attendees - $1,009.00 12 Attendees - $1,088.00 13
Attendees - $1,167.00 14 Attendees - $1,246.00 15 Attendees - $1,325.00

RECORDED WEBINAR ONLY


$219.00

Record Webinar Attendees: No Attendee 1 Attendees - $219.00 2 Attendees -
$298.00 3 Attendees - $377.00 4 Attendees - $456.00 5 Attendees - $535.00 6
Attendees - $614.00 7 Attendees - $693.00 8 Attendees - $772.00 9 Attendees -
$851.00 10 Attendees - $930.00 11 Attendees - $1,009.00 12 Attendees - $1,088.00
13 Attendees - $1,167.00 14 Attendees - $1,246.00 15 Attendees - $1,325.00
or

ALL ACCESS MEMBERSHIP

The Aurora All Access Membership is designed to provide you with the training
that you want when you want it. You will have 100% access to every live webinar,
on demand webinar, professional alert, and podcast that Aurora Training
Advantage offers with no additional cost.

YEARLY SUBSCRIPTION


$599.00

Membership Attendees: No Attendee 1 Attendee - $599.00
Add to Cart
Get in Touch

SHOWCASE YOUR EXPERTISE

If you are an expert in your field and you would like additional information on
how you can speak at a webinar please contact us via email

CONTACT US

 * Address: 520 W Lake Mary Blvd Suite 200, Sanford FL 32773
 * Email: support@auroratrainingadvantage.com

Aurora Training Advantage
© Copyright 2014-2024. All Rights Reserved. - Terms and Conditions
 * Linkedin
 * Facebook
 * Twitter
 * YouTube