Formatting Numbers – I am sure, that you don’t know Everything …
3月 9, 2021 | 6:00 - 8:00 下午 (UTC) 國際標準時間
準備好開始使用 AI 和最新技術嗎? Microsoft Reactor 提供活動、訓練和社群資源,協助開發人員、企業家和初創公司建置 AI 技術等等。 加入我們!
Formatting Numbers – I am sure, that you don’t know Everything …
3月 9, 2021 | 6:00 - 8:00 下午 (UTC) 國際標準時間
準備好開始使用 AI 和最新技術嗎? Microsoft Reactor 提供活動、訓練和社群資源,協助開發人員、企業家和初創公司建置 AI 技術等等。 加入我們!
Formatting Numbers – I am sure, that you don’t know Everything …
3月 9, 2021 | 6:00 - 8:00 下午 (UTC) 國際標準時間
主題: DevSecOps 和開發人員工具
語言: 英文
Come along to this London Excel Meetup with René Martin as he presents on Formatting Numbers in Excel.
Be Warned! You will learn lots.
You know how to change the format of numbers to currency, date and percentage. But: do you know:
- the limits of the numbers? What is a number in Excel? 20:30? 200:30? 2000:30? 20000:30?
- what are the differences between currency and accounting? I found nine differences.
- how to format 1,400,000 to "1.4 MM GBP"?
- that Excel does not only know the conditional formatting [black], [red], [blue], … but 56 more. And? Who needs that?
- where to use ;;;?
- how to create a calendar in different languages?
- the bug “mm”?
- how to generate lists with “@”?
- Some database-systems push text “under” the numbers. How to get rid of it? I found seven ways.
René organises the Excel Stammtisch events in Munich (https://www.compurem.de/excelstammtisch/). These events are organised around Germany and have been going for many years.
These events are part of my inspiration for creating the London Excel Meetup in 2020. I found out about these through Andreas Thehos, who some of you will know from the group.
I met René in Bulgaria last year at an Excel conference. He is extremely knowledgeable (unlike me), but like me, he wrote a book last year;
- Excel Gimmicks (https://www.hugendubel.de/de/buch_kartoniert/rene_martin-excel_gimmicks_i-40162180-produkt-details.html)
It will be great to see you there.
This is an online event and it will start at 18:00 UK time.