Excel Automation with Power Query Course - 02 December 2021

Adrian Miric Adrian Miric

Adrian Miric

Owner, AuditExcel.co.za & Excel-Skills-Assessment.com

发布日期: 2021年11月18日
+ 关注
No alt text provided for this image

If you spend hours getting data and then cleaning it up (every month) then this course is for you. It will teach you how to perform various complex data cleansing activities using Power Query and save you hours of time re-doing manual work.

要查看或添加评论，请登录

Adrian Miric的更多文章

  • Spell Check Excel Documents
    2021年8月17日

    Spell Check Excel Documents

    You can spell check Excel documents but there are a couple of tips and tricks you need to use to make it act more like…

  • Start Of Month Formula in Excel
    2021年7月27日

    Start Of Month Formula in Excel

    Surprisingly, there is no start of month formula in Excel. There is an end of month formula (EOMONTH) but no formula…

  • Stop Users From Inserting/ Deleting Rows - 2 Ways
    2021年7月15日

    Stop Users From Inserting/ Deleting Rows - 2 Ways

    A common requirement is how to stop Excel users from inserting or deleting rows. Typically a template is set up and the…

  • IF Function Not Working With Numbers
    2021年7月7日

    IF Function Not Working With Numbers

    Your IF function not working with numbers? A recent question from a client, it is important to understand what a number…

  • Improve Dashboards with Stock Images
    2021年6月29日

    Improve Dashboards with Stock Images

    With a recent addition in Excel , it is now possible to access and include stock images into your Excel spreadsheet…

  • Sum All Negative Numbers
    2021年6月1日

    Sum All Negative Numbers

    If you need to sum all the negative numbers in Excel, a good function to know is the SUMIFS function. It has multiple…

  • Average Excluding Outliers in Excel
    2021年5月18日

    Average Excluding Outliers in Excel

    Your average not making sense? Perhaps you need to average excluding outliers in MS Excel to get a more realistic…

  • Change the name of items in a Pivot
    2021年5月11日

    Change the name of items in a Pivot

    Do you need to change the name of items directly in the Pivot Table? When working in Pivot Tables you sometimes get…

  • Add Happy Face Emoji
    2021年5月4日

    Add Happy Face Emoji

    If you want to, you can add the happy face emoji into Excel. There is an easy way to do it 2 simple steps.

  • Line break within a cell as the delimiter
    2021年4月20日

    Line break within a cell as the delimiter

    You may come across situations where you need to use a line break as the delimiter in Text to Columns in Excel. A line…

社区洞察

其他会员也浏览了