Tom Fragale Microsoft Certified Trainer Microsoft Certified Office Master Available for Onsite Training, Private Webinars, Consulting, and Custom Software (215)280-1073 [email protected]
To get the sample file from these videos, send an email to [email protected]
Top 20 Most popular videos
Create Mailing Labels from Your Excel 2010 data using Mail Merge in Word 2010 Christmas holiday 2016 https://youtu.be/-dh1KutksMY Using Excel Macros and VBA - Complete - Excel VBA 2010 2013 2007 2016 Tutorial Macros & Visual Basic https://youtu.be/mRCx7x4Tyfg Using An Excel If Function Formula With Multiple Conditions - Excel 2010 Tutorial Examples 2013 2016 https://youtu.be/BoGQD35gAUc How To Compare 2 Sheets Using The Excel Vlookup Function Formula 2007, 2010 , 2013, 2016 Tutorial https://youtu.be/nVxGFPDp53g Excel Pivot Table Tutorial - Create A Monthly, quarterly, Yearly Summary Report Excel 2013 2016 2010 https://youtu.be/9k1KKbOwCEM Creating a workflow in Sharepoint 2013 - How to create a workflow in Microsoft Sharepoint 2013 2016 https://youtu.be/lPnxHWNtL7w How to compare 2 tables in Access - Create a Find Unmatched Query in Access 2007 2010 2013 2016 https://youtu.be/TkZdfptGxu8 Access switchboard manager - creating a main menu in Access 2010 Tutorial Access 2013 2007 2016 https://youtu.be/zVm5W8h7HFk Linking Sheets - Linking Data from Different Excel Sheets and Workbooks - 2010 Tutorial 2013 2016 https://youtu.be/OIL6V2jzDRI Installing an odbc driver in Windows 10 - SQL Server ODBC Driver Excel 2013 2016 Microsoft Access #chatgpt#excel#vlookup#sumif#countif
expense types so let's see if chat gbt
can help us with that so now I'm going
to
say I have a
sheet in
Excel
with a list of
expenses is there a way to get a
list of the different
so let's say your boss gives you this
sheet that has many many expenses so
your boss
says can you give me a count for each
expense type and a sum and an
average now if you had to do that
manually it would really take a long
time but uh let's see how how chat TBT
is going to help us with
this first I have to get a list of all
the different expense types so so let's
say your boss gives you this sheet it
has many many expenses so your boss
says can you give me a count for each
expense type and a sum and an
average now if you had to do that
manually it would really take a long
time but uh let's see how how chat TBT
is going to help us with
this first I have to get a list of all
the different expense types so let's see
if chat gbt can help us with that so now
I'm going to
say I have a
sheet in
Excel
with a list of
expenses is there a way to get a
list of the different
expense
types that are in column
F right so I'm trying to be a specific
as possible in describing my
data so it's giving me some ways to find
the unique items it says I can remove
the
duplicates I can use a pivot table and
it shows you exactly how to do these
things and then it gives me a formula
let's see if this formula is any good
now when you get this kind of window you
can either highlight it and copy it the
traditional way or I'm going to come
over here and I'll pick on copy
code then we're going to go back into
Excel I'm going to paste that formula in
the cell
i1 and it really
worked
so chat gbt just gave me a very
efficient way to get all the different
expense types you can see it's using the
the unique formula now if you have an
older version of excel that formula is
not going to work for you um but if you
have you know a more recent version of
excel that's going to work and I told it
that it was column F right so those are
all the different expense types that are
in column F that was very
helpful now I want to get a count and a
sum and an average of those different
expense types well again to do that
manually it would take a really long
time well we're going to ask chat TBT if
there's a better way so I'm back in chat
TBT I'm going to say well I'm going to
say okay that
worked my
first expense
type is in cell
I2 is there a
way to get a count of each expense type
and let's see what it gives us so let's
say your boss gives you this sheet it
has many many expenses so your boss
says can you give me a count for each
expense type and a sum and an
average now if you had to do that
manually it would really take a long
time but uh let's see how how chat TBT
is going to