MSOffice_using_AI_Tools

All that i have learned from this 1 day workshop

MS Excel

1. OCR Feature

Open MS Excel

Goto Insert -> Upload Picture -> From File

If you upload any image based excel photo, it will automatically map it for you . If will ask for confirmation for the entries which it is not sure of. After Confirming all the datas , the data will get uploaded in excel sheet

2. Latest Analyze Data Feature

Usually when we have data populated in excel sheet and we want to get some insights like generating bar graphs and pie charts, we generally use Pivot chart and pivot table. But with the latest feature of MS Office 365, we can do it directly using prompts, such as

• Are there any data trends?
• Are there any product insights?
• What is the revenue per retail store?

3. Using Formula Dog

Dont remember any excel formula but need to get your work done?

Use Formula Dog

Goto Formula.dog , use Formula tab, write your use case, you will get the formula

4. Use Explain Tab on Formula Dog

if you want to know what exactly the excel formula is doing and you want an explanation, type the formula you want to search . Then press enter. You will get a detailed explanation

MS Powerpoint

For any Powerpoint presentation we have to follow this flowchart

1. Research
2. Outline
3. Design

For Research and Outline of the presentation, you can use ChatGPT. Goto ChatGPT.OpenAI. For Design use Microsoft Powerpoint's latest Designer Function, and use whatever we get from outline one by one in powerpoint.

5. Use Gamma App

This is a faster process compared to previous one. It will geerate PPT within few seconds. Use Gamma.app

6. Your personal speech coach Yoodle.ai

Use Yoodle.ai. This app is going to record your speeches and correct you based on which volcabularies you are using.

Sending bulk emails

7. Use ChatGPT to enhance macro enabled MS Excel.

Search in ChatGPT about sending bulk emails in MS Excel.

    Dim OutApp As Object
    Dim OutMail As Object
    Dim cell As Range

    Set OutApp = CreateObject("Outlook.Application")

    On Error GoTo cleanup
    For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
        If cell.Value Like "?*@?*.?*" And _
           LCase(Cells(cell.Row, "C").Value) = "yes" Then

            Set OutMail = OutApp.CreateItem(0)
            With OutMail
                .To = cell.Value
                .Subject = "Subject of the email"
                .Body = "Body of the email"
                ' .Attachments.Add "Path to attachment"
                .Send
            End With

            Set OutMail = Nothing
        End If
    Next cell

    cleanup:
        Set OutApp = Nothing
    End Sub```