【國立臺灣大學 109學年度畢業典禮 貴賓致詞】
Commencement Address, National Taiwan University Commencement 2021
.
巨大集團 羅祥安前執行長
Giant Group Former CEO Anthony Lo
管校長,羅副校長,各位貴賓,畢業生的家長跟朋友們,還有今天最重要的2021年臺大的畢業生,大家早安、大家好!
首先恭喜你們,今天從全世界最優秀大學之一的臺灣大學畢業了!
在過去幾年,在管校長,以「大學教改」和「國際化」的理念,率領全體師生的努力之下,臺大在全世界的能見度,和各項排名,都有顯著的進步,也讓身為校友的我們倍感光榮。
是不是我們大家一起鼓掌,給自己鼓勵一下好不好!
你們今天剛剛畢業,但是你們已經創造了臺大一項新的紀錄:第一次,沒有傳統畢業典禮的畢業生。這將是你們人生一個非常特別的回憶,也預表了你們未來將會有與眾不同的表現,和非凡的成就。
現在的世界,局勢是在東方跟西方的勢力,彼此對抗而動盪不安。而全世界的經濟活動,也因為科技的突破性創新,而受到很大的影響。不盡理想的、不盡公平的全球化,也將逐漸地變成 全球在地化。而COVID-19肆虐全球的結果,使得臺灣跟全世界,大家的生活型態、社會的結構、經濟活動的節奏都被打亂了,而必須要加以全面的整理跟重新的架構。這當然是一個危機,但是更是一個絕好的機會。所以,將你們迎面而來的,是無數的創新的機會,以及冒險卻令人興奮的全新挑戰。
因為臺灣,這是第一次跟全世界各個國家,同步的站在一個嶄新的共同起跑點上面。所以我要恭喜你們,你們躬逢其會,將要進入一個充滿希望、嶄新的時代。
我是1969年從臺大畢業的,所以我想今天就以我畢業之後的50多年,人生的一些學習和體會,來跟諸位分享,給諸位作個參考。
當我大學畢業的時候,我滿懷抱負,迫不及待地想要大展身手,我當時進入臺灣最大的貿易公司工作,但是我發現我所學的很多東西,只有一些國際貿易的實務跟英文有用,至於其他我所學習到的經營管理的很多知識,恐怕都要等到10年、20年之後,如果我有幸當上高級主管才能派上用場。
更諷刺的是,我是商學系畢業的,但是工作兩年後,我發現我真的不喜歡做商人,我也不喜歡做生意,我有興趣的是做事業。
後來,幸好我有聆聽我心裡面的微弱的聲音,決定踏進自行車業,放棄掉台北最好的貿易公司的金飯碗,而去參加在大甲一個只有38個人的小公司,來追求我的夢想。
那時候許多人認為我腦筋有問題,頭殼壞去,但現在回顧回來,我當時是做了人生一個非常好的決定。
創業的過程飽受艱辛,但是我也學到了很多寶貴的經驗:我首先學到的,是在做事之前,必須要先學做人。
人必須要誠信踏實,不能自私自利,而要利他共好。
要隨時心存感恩,尊重、關切別人。要熱愛這個世界,並且要了解到一個人的能力是有限的,而必須要去建立互信、互助的人際關係;要融入群體、要發揮團隊的精神。
在做事方面,一定要以正面積極的態度,認真努力去工作。 而且不要怕失敗,要勇於接受新的挑戰。因為如果有失敗了,那只是代表說你又更靠近成功一步了。要作中學,學中作,要虛心好奇的終身學習,開拓挑戰、追求卓越。
在這裡,我想要送給大家一個很特別的畢業禮物,就是兩個「成功的錦囊」。
第一個錦囊:不管你做什麼工作,不論你職務的高低,永遠都要站在顧客的立場,來為他們設想,還能做什麼,讓他們能夠得到更多的創新價值。
第二個錦囊:無論作什麼工作,不管你職務的高低,永遠都要站在經營者的角度來為公司設想,要做什麼,才能讓公司更健康,永續經營跟發展。
既使你們把我後面講的很多東西都忘記了,沒關係,但是這個畢業禮物你們一定要記得帶回去,因為這些「同理心」的兩個錦囊,在未來會給你們帶來意想不到的祝福!
其次我體會到,名跟利都是副產品。正產品是你成為什麼樣的人,成就什麼樣的事。當正產品是對的時候,名跟利都自然會來。
所以我鼓勵大家在找工作的時候,不要太計較開始的薪水和待遇。因為事實上,一個新人,在前面三年是很難有大的貢獻的,反過來只是公司發薪水來給你培訓而已。所以選擇一個有意義的行業,找一家你可以學習進步的好公司,這才是重要的。
第三,我學習到 知識不等於智慧。諸位都學有專精,有很多寶貴的知識,但這些知識必須要實際去做才能夠產生經驗,而累積的時候會有不同經驗的反省、學習、跟體會,尤其是從那些失敗的經 驗,才能夠漸漸地凝結成有用的智慧。
我的成長過程分成三段,開始我是一個「I」型的人,我擁有一些經營管理的基本的能力。後來因為工作的需要和我的好奇心,我漸漸地學習到技術開發、製造生產、品牌推廣、全球經營、以及行銷、服務等等寶貴的經驗,這樣漸漸地,我就形成一個「T」型的一個跨界的人才。但是到了我真正找到公司未來的使命跟方向,並且把它跟我的人生目標結合在一起,熱情的、積極去推動的時候,那時候我終於成為一個「十字架」型的一個領導者。
當公司發展得比較穩定之後,我就面臨要如何來替公司規劃願景、使命、定位,跟長期策略。在這個階段,我有一些新的體會:首先,你必須要能夠畫出一個「黃金正三角形」,正三角形是最穩定的,上面是戰略,中間是戰術,下面是戰鬥。先要有正確的戰略,才能衍伸出有效的戰術,再根據這個戰術去貫徹戰鬥的執行。換言之,戰略就是做對的事情,戰術就是對的方法,戰鬥就是用對的方法去把事情做對做好,並且不斷地去持續改善。
想要能夠思考出長期的戰略,就必須要有洞察力。
我很喜歡看地球儀,就是那種在一個架子上面,有一個可以轉動的地球模型。當你把地球轉動的時候,你看到上面每一個地方、每一個國家,它的地理位置、它的自然生態,以及你思考它的歷史的演變跟它的發展,這樣子你就能夠得出一個整體的,跟全方位的一個概念。
在思考長期戰略的時候,很不容易得出一個有突破性的一個創見,它的原因往往是因為「當局者迷」的關係。
所以當我考慮長期戰略的時候,我會把自己設想,好像從一個人造衛星上面,來觀看一個轉動的地球。以宇宙格局的高度,以全球視野的廣度,以歷史演進的長度,這樣子你就能夠以一個「旁觀者清」的姿態和角度,來正面、反面深入思考,這樣子你就可能得到一個突破性的一個解答。「世界的捷安特」跟「全球在地化」的品牌經營—這樣子的策略、願景就是這樣產生的。
另外一種洞察力,是如何推出給人們有創新價值的產品跟服務。這就要時時地站在人文跟科技的十字路口,仔細觀察它們的變化,然後活用科技的進步,為人文潛在的需求,適時地提供最佳的解決方案。捷安特的Cycling世界,就是用這種方法,不斷的推出創新價值的產品。
我們在經營上也有發展出一個特別的理念,那就是「不求第一,要作惟一」。全世界的人這麼多,但沒有兩個人的指紋是一樣的, 所以每一個人都是獨一無二、都是惟一的。可見當上帝造每一個人的時候,祂都有衪特別的計劃,而且也把成功所需要的能力跟要素,已經放在你的心中,等待你取用。所以每一個人不應該只是模仿別人,或者是按照別人的期望來生活,而應該要找出並且發揮自己的天賦,真正做自己,成為惟一,才能夠活出精采的生命。
企業也是一樣,不能隨波逐流,必須要找出什麼才是對的,什麼是合適你的,什麼才是有意義、對這個世界有貢獻的,這個才是惟一。當你精益求精,努力的想要成為惟一的時侯,你才能夠找到真正正確的目標,以及永續生存的價值。如果事事都想為第一,那麼你可能去追求很多不切實際的目標,而被你無法承受的巨大壓力所摧毀。或者,因為不擇手段,最後走上一些錯誤的道路。
在長期追求惟一的過程當中,我也得到兩個重要的體會:當你決心做一件對的事情,而且不屈不撓,勇敢堅持奮鬥的時候,全宇宙的力量都會起來幫助你。另外,把一件有意義的事情,用生命的力量把它作好,你就有可能改變這個世界!
我鼓勵你們,聆聽你們內心深處的微小的聲音,讓它引導你們,去尋找到你們的天賦,了解你們的命定。
不求第一,要作惟一。做你真正的自己,成為惟一。活出你精彩的生命,享受你幸福的人生!
很多人說,生長在臺灣的人,一輩子裡面一定要完成三項挑戰:登玉山、泳渡日月潭、還有騎自行車環島。我覺得這非常有道理。所以我建議大家在畢業以後,在去當兵、就業之前,不妨參加一個自行車環島的旅行團,用九天的時間,仔細的去體會、欣賞寶島臺灣的美好,用自行車的輪胎去親吻,這塊生你長你的美麗大地,就當作是送給你自己的一個畢業禮物吧!
那教授們跟家長們,可能會想說,啊!太可惜了,我畢業的時候沒有騎自行車環島,我現在已經五六十歲了。沒關係,你這個年紀正好來從事人生的壯遊。
我們臺大的校長-管校長,在今年的一月份,就勇敢的完成他夢寐以求的自行車環島的壯遊。我們給管爺一個掌聲好不好?
有人認為臺灣很小、沒有前途,真的是這樣嗎?世界經濟論壇每年都要把全世界的國家的實力做一個調查跟排名。讓我們來看一下臺灣的排名。全世界有235個國家,就面積來講,我們排名第137;就人口來講,第57;就經濟體來講,第21;就整體競爭力來講,排名第11;而創新力,臺灣排名第4。沒錯,臺灣的確不大,但是我們很強,我們可以很有前途!
可預見的,未來的世界將會成為美、歐、亞三區鼎力的這個新局面。就像三個圓圈,各自都以自己的利益為優先,並且彼此長期的競爭、對抗和抵制,但是同時又不得不相互的維持一些必要的連結。而在每一個圈裡面,它將持續的有很多劇烈的改變,就像一個暴風圈一樣。而這三個暴風圈連結在一起,就形成一個所謂完全風暴PERFECT STORM。
最近經濟學人雜誌,把臺灣當作封面,稱臺灣為地球上最危險的地方,但同時又是科技業最關鍵的地方。我個人倒認為,未來臺灣可能是處在一個最有利的地位,就在那三個暴風圈中間的那個颱風眼,也就是這三個圈圈彼此連結交會的中心點。這個地方看起來好像危險,其實是最安全、最有利、又是最關鍵的地方。
當三個暴風圈無可避免的,參與在一個長期的競爭、對抗、跟抵制-這樣一個零和的賽局裡面。那臺灣並不屬於任何一個圈圈,也不需要去參與這些競爭、對抗跟抵制。而可以去想說,我可以在這個關鍵的中心點,替這個世界來提供什麼樣子的創新價值的貢獻。
臺灣過去50年的努力累積了很多技術開發、製造管理、金融資本,社會資源,以及民主法治體制,這些稀有而寶貴的實力。而且如果以全世界作為舞台,那麼,能夠精通中文跟英文、能夠深切的了解東方西方的文化;有專業,又能跨界,謙卑而不自卑,自信而不自大的臺灣人,可能是全世界最優秀的人才。
未來無法被預測,但是可以被創造!30年前,有誰能夠預測到說臺灣會產生世界級的台積電跟捷安特?
台積電秉持著作惟一的理念,以全球晶圓代工的戰略,厚植實力,打造了優質高效的供應鏈,把臺灣變成一個科技島。以臺灣為核心,轉動引領全世界的半導體市場。
捷安特也秉持著作惟一的理念,以世界的捷安特,全球在地化的品牌戰略,帶領A-Team把臺灣變成全世界高級車的中心,又積極的推動Cycling的新文化,把臺灣發展成一個自行車島,以臺灣為核心,轉動引領全世界自行車的市場。
在這裡我也期許我們臺大,也能夠以作惟一這樣子的理念,轉動引領世界,變成全世界最優秀人才培養的最佳搖籃。
未來的50年,臺灣將迎來前所未有最大的機運!所以臺灣是不是應該要脫離過去單純競爭的心態,而來積極的謀求長期的未來生存之道,或者更進一步要問自己:臺灣可以為世界貢獻些什麼?臺灣不應該只是消極的「根留臺灣」,而應該更主動積極的「放眼全球、立足亞太、深根臺灣」。
臺灣過去的50年,那是一個非常艱辛跟特別的階段。很慶幸的,臺灣在那個階段裡面,是屬於勝利的這一組。
現在是應該到了必須要了解過去、深入現在、策劃未來,這個重要關鍵的時刻。要如何的以宇宙格局的高度、以全球視野的廣度、以及歷史演進的長度,衡外情,量己力,來為臺灣重新的定位,重新畫一個正確的戰略、戰術、戰鬥的黃金三角形。讓臺灣能夠真正發揮自己的長處,能夠打造創新價值的優勢,成為惟一、做Only One!要能夠創造一個更安全、更廣闊、更興盛-全新的藍海。臺灣必須要成為世界的好公民,繼續的為全世界做更多、更好的貢獻!
2021的畢業生們,在你們當中有未來國家的領導人、有全球企業的創造者、有在社會各行各業、方方面面的核心人才,所以臺灣未來50年的未來,就掌握在你們手中了。
最後,我想用一位著名科學家的名言來作結尾: Life is like riding a bicycle. To keep your balance, you must keep moving. 人生就像騎自行車,要保持你平衡最好的方法,就是繼續不斷地向前進。
你知道這是誰的名言嗎? 沒錯,就是愛因斯坦!
2021的畢業生們,請你騎上你人生的自行車,勇敢的向前邁進,去開創你獨一無二、精彩無比的新生命跟未來。再一次,恭喜你們,並且祝福你們每一位,將來都能夠有健康、幸福、精彩跟有意義的人生!
謝謝!
.
==============================
.
President Kuan, Executive Vice President Luo, Distinguished guests, family, friends, and most importantly, the graduating class of 2021, good morning!
First of all, congratulations! Today, you are graduating from one of the best universities in the world – National Taiwan University!
Over the last few years, President Kuan led the university forward with his vision of “educational reform” and internationalization”. Together with all the faculty and students, NTU has made significant progress in both ranking and global visibility, making us, alumni, extremely proud.
I think we deserve to give ourselves a round of applause!
You are the graduating class of 2021 and already, you have set a new record for NTU: For the first time, there will not be a traditional graduation ceremony. Let this be a very special memory of your life and a sign of the difference you will make in your future with extraordinary achievements.
The world is now in a volatile state where the East and the West are confronting each other. The world’s economic activities are also greatly affected by the breakthrough and innovations in technology. The less-than-ideal and less-than fair globalization will gradually become global localization. And as a result of COVID-19, Taiwan and the rest of the world’s lifestyle, social structure, and economy have been disrupted, and must be comprehensively reorganized and restructured. This is certainly a crisis, but in the midst of every crisis, lies great opportunity. So, what lies before you are countless opportunities for innovation, and exciting new challenges.
Because, for the first time, Taiwan is standing with the rest of the world on a new race-track. Therefore, I would like to congratulate you, you are entering a new era full of hope.
I graduated from NTU in 1969. It has been more than 50 years and today, I would like to share some of my life experiences and insights.
When I graduated from college, I was filled with ambition. I couldn’t wait to make my mark. I joined one of the largest trading companies in Taiwan, where I quickly realized the only materials I learned in school that came in handy are a little bit of international trade practices and English. Much of what I had learned about business management would only be relevant 10 or 20 years down the road, if I was lucky enough to become a senior executive.
What’s even more ironic is that I graduated with a degree in business, but after working for 2 years, I realize I really don’t like being a businessman, and I don’t like doing business. What I am actually interested in is building an enterprise.
Fortunately, I chose to listen to the faint voice in my heart and decided to enter the bicycle industry. I left my position at the best trading company in Taipei to join a small company with only 38 employees in Dajia to pursue my dream.
At the time, many people thought I must’ve broken my skull and gone crazy, but looking back, I have made a great decision in my life.
The process of starting my own enterprise has been very difficult, but I have learned many valuable lessons. The first thing I learned is that before you can do anything else, you have to learn to be a person of good character.
We must be honest, down to earth, selfless, self-serving, and altruistic for the common good.
Be grateful, respectful and caring at all times. To love the world and to understand that one person’s ability is limited and that is necessary to build interpersonal relationships of mutual trust and support; to be part of a group and to play as a team.
When it comes to work, you must work hard with a positive attitude. And don’t be afraid to fail, be brave enough to accept new challenges. Because every time you fail, it just means you are one step closer to success. Learning is an active process. We learn by doing. We must stay open-minded and curious, aspiring to lifelong learning; to explore challenges and pursue excellence.
Here I would like to give everyone a special graduation gift, which are my two tips for success:
First, always put yourself in the customer’s shoes, regardless of what you’re doing or what kind of job title you hold. Think for them, think about what else you can do to create more value for the customers.
Second, regardless of what you’re doing or what kind of job title you hold, always think about the company from the proprietor’s point of view; what can we do to build a healthier company that’s sustainable.
Even if you are going to forget everything I say later, that’ ok. Just remember to take your graduation gift at heart, because these two tips on “empathy “are sure to bring you unexpected blessings in the future!
Later on, I realized that fame and money are merely byproducts. The real product is you, what kind of person you have become and what have you achieved. When the real product is identified, fame and money will come naturally.
So I encourage you, when you look for a job, don’t be too concerned about the starting salary and benefits. Because as a matter of fact, as a newcomer, it is very difficult to make a big contribution in the first three years, so really the company is paying to give you training instead. So choose a meaningful industry and find a good company where you can improve and grow, that’s what’s important.
Thirdly, I learned that knowledge is not the same as wisdom. All of you have learned a lot and have a lot of valuable knowledge, but this knowledge must be practiced in order to produce experience, and in the process of accumulation, there will be different experiences of reflection, learning and empathy, especially from failure, slowly and surely all these experiences will be condensed into useful wisdom.
My personal development can be divided into three stages. I began as a I-shaped person with some basic skills in business management. Later on, due to my job and curiosity, I gained respected experience in technology development, manufacturing, branding, global marketing, and service and thus gradually becoming a T-shape multidisciplinary professional.
However, when I combined the future mission and direction of the company with my life goals, promoting it enthusiastically and actively, that is when I finally became a X-shape transdisciplinary leader.
Once the company became more stable, I was faced with the challenge of planning the vision, mission, positioning, and long-term strategy for the company. At this stage, I had some new insights.
First, you must be able to draw a “golden triangle”, an equilateral triangle is the most stable shape with strategy on top, tactics in the middle, and operations at the bottom. In other words, the strategy is to do the right thing, the tactics is the using the right methods, and operations is using the right methods to excel on doing the right things while constantly improving them.
To develop long-term strategies, it is necessary to have insight.
I enjoy looking at the globe, yes, the spherical model of Earth that sits on a stand and can be rotated. When you rotate the globe, you can see every place and country on it, its geographical location, its natural ecology, and you can think about its historical evolution and development, so that you can come up with an overall comprehensive concept.
When thinking about long-term strategy, it is not easy to come up with a groundbreaking idea, because “men are often blind in their own cause”
Therefore, when I think about long-term strategy, I imagine myself as if I were looking at a rotating Earth from a man-made satellite. With the height of the universe, the breadth of global vision and the length of historical evolution, you will be able think about it from the perspective of an observer, and then you may have a breakthrough. This is how the strategy and vision of “GIANT for the World” and “glocalization” brand management came about.
Another kind of insight is how to introduce the products and services to create additional value to people. This requires standing at the crossroads of humanity and technology, observing their changes carefully, and then using technological advances to provide the best solutions for the potential needs of humanity in a timely manner. This is how GIANT’s Cycling World continues to introduce innovative values to its products.
We have also developed a special philosophy in our business, which is “don’t be the first one, be the only one”. There are so many people in the world, but no two people share the same fingerprints, making each person unique and one of a kind. God created each person with purpose and has gifted us with the abilities and elements needed for success. All of which is in your heart, waiting for you to take them. Therefore, we should not just follow each other’s footstep or live under the expectations of someone else. Instead, we should find and give reigns to our talents, to truly be ourselves, to become the only one and live a brilliant life.
The same applies to businesses, you can’t just go with the flow, we must find what is right and suitable and what is meaningful and contributive to the world, this is what it means to be the only one. When you strive for excellence and strive to be the only one, you will find the right goals and the value of sustainability. If you try to be first in everything, you may pursue many unrealistic goals and either be destroyed by unbearable pressure or resort to doing whatever it takes, and end up on the wrong path.
I have learned two important lessons in my long quest to be the “only one”. When you are determined to do the right thing and you are unyielding and persistent in your struggle, the power of the universe will rise up and help you. In addition, if you do something meaningful and do it well with the power of life, you may change the world.
I urge you to listen to the small voice deep within you and let it guide you to find your talents and understand your destiny.
Do not seek to be the first but to be the only. Be true to yourself and be the only one. Live your life to the fullest and enjoy your life to the fullest!
Many people say that growing up in Taiwan, you must complete three challenges in your lifetime: climb to the top of Jade Mountain, swim across Sun Moon Lake, and ride a bike around the island. I think this is very true. Therefore, I suggest that after graduation, before you go to the military or get a job, you might as well join a bicycle tour around the island and spend nine days to carefully experience and appreciate the beauty of Taiwan. As a graduation gift to yourself, let the tires kiss the beautiful land where you were born and raised.
All the professors and parents must be thinking in regret, “Ah! Too bad! I didn’t ride my bike around the island when I graduated and now I’m already in my 50s and 60s…” But that’s okay! You are actually at the perfect age to start your adventurous life.
Our President of NTU, President Kuan bravely completed his dream bike tour around the island in January this year. Let’s give President Kuan a round of applause!
Some people think that Taiwan is small and has no future. Every year, the World Economic Forum conducts a survey and ranking of the strength of countries around the world. Let’s take a look at Taiwan’s ranking. There are 235 countries in the world and we rank 137th in terms of landmass, 57th in terms of population, 21st in terms of economy, 11th in terms of overall competitiveness, and 4th in terms of innovation. It’s true that Taiwan is not big, but we are strong and we have a promising future.
In the foreseeable future there will become a new situation in which the United States, Europe and Asia will be the three focal regions. Just like three circles, each of which prioritizes its own interests and is in long-term competition, confrontation and resistance, but at the same time has to maintain some necessary links with each other. And in each circle, drastic changes will be endless, just like a storm circle. These three storm circles are linked together to form a so-called PERFECT STORM.
The Economist magazine recently featured Taiwan on its cover, calling it the most dangerous place on earth, but at the same time the most critical place for the technology industry. Personally, I think that Taiwan may be in the most favorable position in the future, right in the middle of the three storm circles, the eye of the typhoon, which is the center point where these three circles are connected. This place seems dangerous, but in fact it is the safest, most favorable, and most critical place.
When the three storm circles are inevitably involved in a long-term competition, confrontation, and boycott - a zero-sum game. Taiwan does not belong to any of these circles, nor does it need to participate in these competitions, confrontations, and boycotts. Instead, situated in this critical position, I should begin to think about what kind of innovative value I can provide to the world.
Taiwan's efforts over the past 50 years have accumulated many rare and valuable strengths in technology development, manufacturing management, financial capital, social resources, and the democratic rule of law system. If the world is our stage, Taiwanese people who are proficient in Chinese and English, who have a deep understanding of Eastern and Western cultures, who are professional, who can cross borders, who are humble but not inferior, and who are confident but not arrogant, may be the best talents in the world.
The future cannot be predicted, but it can be created! 30 years ago, who could have predicted that Taiwan would produce globally renowned TSMC and GIANT?
TSMC is committed to the concept of being the only one, and has built up its strengths with its global foundry strategy, creating a high-quality and efficient supply chain and turning Taiwan into a technology island. With Taiwan as the core, TSMC is leading the worldwide semiconductor market.
GIANT also upholds the concept of "Be the only one" and leads the A-Team to turn Taiwan into the center of the world's premium bikes with the brand strategy of globalization and localization, and actively promotes the new culture of cycling, developing Taiwan into a cycling island and leading the world's cycling market with Taiwan as the core.
Here I also hope that we, NTU, can also lead the world with the concept of being the only one, and become the best cradle for the cultivation of the best talents in the world.
In the next 50 years, Taiwan will have the greatest opportunity ever! Therefore, Taiwan should get rid of the simple competitive mentality of the past and actively seek the long-term survival of the future, or go even further and ask itself: What can Taiwan contribute to the world? Taiwan should not just "secure Taiwan" in a conservative way, but should be more proactive with global outlook and establish a foothold in the Asia Pacific.
The last 50 years, for Taiwan, has been very difficult and significant. Fortunately, Taiwan pulled through and came out as one of the winners.
Now is the crucial moment to understand the past, delve into the present, and plan for the future. We must take the height of the universe, the breadth of our global vision, and the length of historical evolution, weigh the external situation, and measure our own strengths to reposition Taiwan and draw the golden triangle of strategy, tactics, and operations. Taiwan should be able to give full play to its strengths, create innovative value, and become the only one! Taiwan must become a good citizen of the world and continue to make more and better contributions to the world!
Graduates of 2021, among you are the future leaders of the country, the creators of global enterprises, and the core talents in all walks of life, the future is in your hands.
Finally, I would like to conclude with a quote from a famous scientist: Life is like riding a bicycle. To keep your balance, you must keep moving.
Do you know who this quote belongs to? That's right, Einstein!
Graduates of 2021, please get ready for your life adventure, get on your bikes and peddle courageously forward to create your own unique and exciting future. Again, congratulations and best wishes to each and every one of you for a healthy, happy, and meaningful life!
Thank you!
詳見:
https://www.facebook.com/NTUCommencement/posts/2718162161807541
.
#臺灣大學 #畢業典禮 #NTUCommencement2021 #貴賓致詞 #羅祥安
同時也有6部Youtube影片,追蹤數超過4萬的網紅吳老師教學部落格,也在其Youtube影片中提到,東吳EXCEL VBA與資料庫(進階92)第2單元_按ENTER自動輸入&防止為輸入資料與輸入非數字錯誤&保護VBA專案與建立資料庫&ACCESS中執行SQL指令&用ADO傳送SQL給資料庫執行&用ADO新增全部與查詢全部資料 上課內容: 01_上星期重點回顧與按ENTER自動輸入 02_防止為輸...
「excel value解決」的推薦目錄:
- 關於excel value解決 在 國立臺灣大學 National Taiwan University Facebook 的最讚貼文
- 關於excel value解決 在 會計人的Excel小教室 Facebook 的最佳解答
- 關於excel value解決 在 王宇婕 Margaret Wang Facebook 的精選貼文
- 關於excel value解決 在 吳老師教學部落格 Youtube 的精選貼文
- 關於excel value解決 在 吳老師教學部落格 Youtube 的精選貼文
- 關於excel value解決 在 吳老師教學部落格 Youtube 的最讚貼文
- 關於excel value解決 在 【Excel教學】複製公式為什麼相同內容會出現#Value錯誤 的評價
- 關於excel value解決 在 EXCEL出現#VALUE的問題 - Mobile01 的評價
- 關於excel value解決 在 Newest Questions - Stack Overflow 的評價
excel value解決 在 會計人的Excel小教室 Facebook 的最佳解答
今日練習題:【Excel TEXT函數】銀行日記帳的日期格式不對?你需要TEXT、CONCATENATE、VALUE神救援
小新很認真把股票買賣紀錄在Excel,想分析時卻發現沒辦法依照日期篩選,請參考影片幫忙解決。
加入臉書社團或Telegram群組有測驗檔案喔!
https://www.facebook.com/groups/acctexcel/
excel value解決 在 王宇婕 Margaret Wang Facebook 的精選貼文
我哥之前因為陪朋友去考街頭藝人證照看到一些評審對街頭藝人的態度發聲 而上了新聞。我覺得他很勇敢的去做了一件對的事。
希望政府不會時間過了就不關心這些事情。希望我們都可以更客觀的去看藝術,尊重不一樣藝術和藝術家。我覺得以下我哥說的非常好,想跟大家分享。
想知道之前的事可看新聞連結:
http://www.storm.mg/article/270611
親愛的大家:
我想感謝所有支持我、以及給予我鼓勵意見的每個人;同時也要感謝熱情關注此事、協助揭露街頭表演者們應試處境問題的許多媒體與記者們。我很抱歉這些日子我保持著沉默—僅有一個原因:我並不希望這件事情,在台北市文化局正式給予溝通管道之前就發展到無法控制的程度;我很抱歉遲至今日我才發表這篇文章,但我確實需要一些時間來沉澱彙整我心中的感受和想法,而我也需要時間及一些協助使這篇文章能夠以中文來呈現。
在我採取更進一步的行動之前,我其實未曾預料到這件事情在媒體與社交媒體上的感染力如此龐大;我受寵若驚的感動能夠聽見發自你們每個人內心的聲音,而我也著實感到抱歉,面對著如潮水般湧來的各種訊息,似乎超過我所能負荷。請原諒我未能夠逐ㄧ去回應每個人的訊息,但我真的想讓你們知道,你們每ㄧ個人都讓我感到不可思議、帶給我深深的感動及感謝。
我不認為自己是一個勇敢的人,我也自知自己並非街頭藝人的代表或者發言人。但我是一個藝術創作者,一個表演藝術家,一個教育者,而最重要的,我身為一個 "人"。我的家人、朋友及師長們,總是教導我應該為正確的事情挺身而出。
我明白事情有時候總是不像我們所期待的永遠是非分明。但發生在5月21日星期天的街頭藝人評審事件,是對藝術群體的一種「極不尊重」。不論反面評論者所提出的藉口、理由或是文化差異等緣由,這些應試的表演者們,很顯然是被視為次等公民,或者(經驗與技能不夠成熟?)的學生等級。而與此同時,同樣非常清晰的是,街頭藝人評審制度或許是立意良善,但其審查過程的執行層面,卻是嚴重缺失連連。
藝術並非一種特權的這件事情如今已完全被遺忘。台北市文化局本應提倡所有具有文化及藝術可能性的事情,但它並未做到這ㄧ點。很顯然的,一個「對表演者的基本尊重」並不存在 — 許多表演者都如此感覺,有些人則深感受傷。
就算是得到全世界所有理應被如此對待的原因及理由,他們仍然感受到自己的不被尊重;因為這就是事實。
再一次的我想強調我並不是認定台北市文化局與該評審是一個「壞人」,我想強調的只是這個評審街頭藝人表演的執行環節,究竟有多麼的不妥當與糟糕。
我試著回應一個反面評論者所提到的觀點:若街頭藝人證照是ㄧ場「考試」、考試就會有考試的規則。評審無需與應試者惺惺相惜,掉頭就走是因為模擬街頭現場環境以及時間到了。再一次的,在我描述現場狀況的前ㄧ篇文章中,大家或許還記憶猶新:許多表演者根本沒有完整的短至一分半鐘的時間可以好好表演,遑論是超過2-5分鐘的時間限制了。
而這樣的回應是否也指出了另一個值得我們去思考的問題: 為什麼我們會將它視為一種「考試」,而不是ㄧ個表演者的「試鏡」呢?
首先,這些表演者們並不是學生。事實上,許多人更可能是一個專業的音樂家、舞者、或者正從事著表演藝術的人。當然,我不否認也可能會有些正在學習中的族群。但,最重要的是,當他們「在屬於他們應得的演出時間與機會裡 (而且還是付費才有的),他們就是ㄧ個真正的表演者。」
他們不應該被看待成一個不成熟的學生或者次等的公民。而就算一個人擁有著學生的身分,這個身分也不應該影響或侷限他或她,作為一個藝術創作者的身分及所有可能性。「藝術家」並非是透過一個人的職業身分或者社會地位來定義的。
所謂「考試」的這個字眼指涉著ㄧ個學術教育機構,而我們都知道台北市文化局所應該扮演的角色與作用,並非一個學術性的教育機構,也並非是用來教育藝術創作者們該知道些什麼?該怎麼表現?藝術教育及審美的養成也從來不是在追求填鴨式教育裡的ㄧ個標準答案。將街頭藝人的徵選視為「考試」的視角,或許本身就有待商榷。
評審的場所是在一個公共場合,許多居民與遊客都會圍觀欣賞著表演,其中有些人或許不了解藝術;因而這些人也許會將在場的評審們,視做為某種藝術的衡量標準;試問,當這些人看到評審對待表演藝術家的行為與態度,當他們看到評審總是任意打斷演出,並且掉頭就走不帶ㄧ句回應時,人們日後還能懂得尊重街頭表演藝術家嗎?
沒錯,我們都知道這是一場「考試」,我們也很清楚這些手上拿著計分表的人們就是評審;因此,事實上評審們根本無需「模擬」街頭現場那些會隨時走掉的陌生人們。
這些評審以及相關單位的人員,理應提倡藝術,並且作為ㄧ種示範與典範,讓普羅大眾都能夠看到該如何去欣賞ㄧ場演出。一個表演者並不會因為他選擇在街頭表演,就因此比不上一個在大舞台演出的藝術家。我自己就曾在世界各地超過百個不同的絢麗舞台演出過,但我仍然汗顏自己可能也不比這些街頭藝術家們來的優秀。
我曾擔任過ㄧ些國際比賽的評審,我也曾舉辦過專業的試鏡;我從來沒有聽過關於尊敬一個人的這件簡單事情,會需要在時間充裕的前提下才能夠發生。
如果一點表情會洩漏出評審成績的好惡,其實也真的可以不用笑或是無需在表演結束時說一聲謝謝。而評審也真的「不需要」與考證照的街頭藝人感覺惺惺相惜,因為這些都不是我想討論的重點。
我在意的是,表演者所需要的,只不過就是一個對人與對一個演出者的「基本尊重」而已。這樣的尊重存在與否,如人飲水冷暖自知,在人與人的接觸中就能直接感受的到,著實無需仰賴規則或語言的贅述。
我作為一個藝術創作者和教育者,穿梭各地工作超過15年的職業生涯經驗,或許會因此被視為一個外國人,但我的身分就是一個台灣公民。身為一個39歲的成年人,我可以分辨何謂尊重,而表達尊重甚至不需要浪費到任何一秒鐘。如果一個人會需要至少五分鐘以上的充足時間才有可能表達出對另外一個個體的尊重的話,那他可能需要重新再思考一下,尊重對他而言意謂著什麼?
再度回應一位也曾擔任過街頭藝人評審的老師所提出來「中途要求更換曲目或要求表演者改唱另ㄧ種語言的歌」的理由,是因為評審們不會希望一個街頭藝人一整年下來只會唱同一種語言、甚至是只唱同ㄧ首歌。
我所思考的是當一個街頭藝人遵守規定,付費且努力準備去應試時,他ㄧ定會準備了符合完整時間長度的、同時也是自己最擅長、最喜歡或者是最期待能被看見的那些內容;表演一首歌曲或者ㄧ種風格並不代表他就只會唱那ㄧ首歌;而且就算是當做他只會唱ㄧ種語言、ㄧ首歌,如果他能把這首歌反覆演繹的淋漓盡致時, 又有什麼不好呢?
難道我們不曾注意到百老匯的音樂劇就是同樣的那幾部,而獅子王也已經在舞台上展演了20年了嗎?許多同樣內容重複的音樂劇票房始終歷久不衰,持續帶給觀眾們心靈的滿足。而人氣歌手愛黛兒從頭到尾也只會用英文唱歌,而且幾乎都是類似的曲風,我們可曾在乎過她有沒有能力去唱中文歌呢?
ㄧ部舞蹈作品光在荷蘭本土就能有至少五十場大大小小的演出機會。但在台灣,ㄧ部作品如果能有五個場次的演出,可能已經算是很長壽了。這樣的環境迫使藝術創作者們必須不斷快速的「生產新作」,而將舊有積累的作品與經驗拋在腦後。就所有對於藝術的挹注與投資(不僅僅是金錢)來說,這樣的情況對藝術的生產是ㄧ種過度消耗與浪費,也並未真正教育到民眾如何去看待藝術的價值。
而最終,這樣的評審過程與態度並不僅僅是對街頭表演藝術者的不尊重,同時也是對於藝術的不尊重。
台北市文化局星期ㄧ曾經聯絡過我,親切向我表示將與我進一步聯絡並討論這件事情;他們要求我先將評審的照片拿掉—我答應取下照片,但前提是他們必須確實誠意的允諾一個面對面的溝通。這幾天我也暫時迴避了一些報導媒體的詢問(還請大家見諒)只因我衷心希望能先與台北市文化局及該評審當面談一談。我ㄧ直等待,但我也持續的看到了相關機構或人員回應給媒體的諸多理由與藉口; 自從將照片從網路上取下之後,直到今日都沒有人再跟我連繫過。慢慢的我突然明白星期一的那通電話,或許純粹只是ㄧ個希望我能將照片取下的操作手法,而並非真的試圖去了解整個經過以及解決問題。我對這個本應提倡藝術與文化的機構感到無比失望。
我知道我並非一個公眾人物,而我也不能代表所有想要考取街頭藝人執照的表演者們;自從我的臉書網頁訊息爆炸之後,我就不斷的在思考這件事情,我反覆思考自己是否該繼續爭執此事,這似乎並非與我切身相關的事情,然而,身為一個藝術教育者,我卻又感受到深切的責任。
經過反覆的思考以及與朋友們的討論,我意識到不論我們的展演形式如何不同,我們同樣都是表演藝術群體中的一分子。台北市文化局最後很可能將持續充耳不聞,而這位被我所抱怨的評審也可能繼續做他這些年來ㄧ直在做的事—用他ㄧ貫的態度。除非他們願意傾聽與改變,否則我無法改變任何人。
我真心相信有些事情值得改善,也可以改善。我必須強調我並不是想要攻擊或羞辱任何人。我只希望能有機會去討論如何讓審查的過程變的更適當。我看到台灣有許多優秀的藝術家,但環境對藝術和藝術家的不尊重不但打擊同時也限制了他們的發展;更遺憾的是,這一切可能是在許多疏忽之中造就出來的環境。
許多評審過程如果能夠在尊重藝術的前提之下思考和進行,事情或許會截然不同。
只要有一點點可能去拋開面子的問題,或許也就有機會明嘹我們所期待的結果其實是一樣的。
事實上我之所以說了這麼冗長的話語,並非是要不尊敬所謂的評審或師長,而正是因為我對藝術的尊敬,使我更深切的關注身為一個教育者所代表的意義。今天我看到了街頭表演藝術家是如何被不當的對待,而很顯然的我也不會是唯一的目擊者。某個程度上我的聲音似乎被放大了,但我也知道我的聲音並不是唯一的一個,我是許許多多的聲音中的ㄧ份子。
William
---------
Dear All,
I would like to thank you for all the encouraging messages and supportive comments. I would also like to thank all the journalists and reporters who are passionate about this issue and are so willing to expose the problem that was faced by these street performers. I am sorry that I have been quiet but with a reason: I don’t want it to get much bigger than it already was until I talked to the Taipei Cultural Affair. I apologize that it took me a while, but I needed some time to gather my thoughts and help to translate my writing into Chinese.
Before I go on any further, I never expected my story would go viral on the media and the social media. I am humbled and touched to hear from many of you. All the messages I’ve received have been overwhelming. I am not able to reply to all of them, but I’d like you to know that I am honored, thankful, and touched by every single one of them.
I do not consider myself as a brave person, nor do I consider myself a representative for the street performers. BUT I am an artist, a performer, educator, and most of all I am a human being.I have always been taught to stand for what’s right by my family, friends and mentors.
I understand things are not as black and white as we all wish sometimes. However, what happened on Sunday 21st of May was a disgrace to the art community. Regardless of all the excuses that were given or cultural differences, it was very obvious these performers were treated like lower-class citizens; if not, students. It was also very clear that the intention might be well, but the execution of the busker’s exam was done horribly.
Somehow the idea that ART is NOT a privilege had been forgotten. Taipei Cultural Affair is supposed to be advocating for all things cultural and artistic but it was not conveyed that day. It was very clear the respect was not there. Many felt it and some got their feelings hurt. Even with all the excuses there are in the world, many experienced the disrespect. That was the truth. Again I have to emphasize that I believe Taipei Department of Cultural Affair and its adjudicators are good people, but the execution of the exam was poor.
It brings to the question…. why is it called an exam? Shouldn’t it be an audition?
These performers were not students when they took the exam. Some of them were actually professional musicians, dancers, or performers. Just because one is a student, it doesn’t make him or her less of an artist. Artists are not defined by their social status or occupation.
The term exam suggests an educational institution, but we know Taipei Department of Cultural Affair is not an educational institution. They do not decide what these artists need to know. These performers were not given any materials to study, thus the term exam is very misleading.
The exam took place in a public space. Many tourists and residents were there to enjoy the event. Many do not understand arts. So they may look up to these adjudicators as role models who are experienced in the arts. When they saw how this exam was being done, do you think they would have any respect for these performers afterwards? They saw these adjudicators interrupting the performers and left without saying a “thank you.” We all knew it was an exam, we all knew these people were adjudicators. They did not need to pretend to be street spectators who just walk away. They all carried their score boards in their hands.
Just because a performer performs on the street, it doesn’t make that performer any less of a performer than someone who is performing on big stages. I myself have performed over hundreds of stages around the world and I do not dare to think myself better than these performers.
I have judged a handful of international competitions. I have also held professional auditions. I have never heard an excuse that respect can’t be shown when time is limited. You do not need to smile to simply say “thank you.” Since when, a smile means “I favor you.” What a performer need is respect. Over the 15 year span of my professional career as an educator and artist, and 39 years of being a human being, I know what respect looks like. It doesn’t take more than a second to show it. If it takes longer than 5 minutes to show what respect is, I think you may need to rethink what respect means to you.
Another excuse that was presented was that they don’t want a street artist performs only one kind of songs or genre throughout the year. Don’t they know broadway musicals? Lion King has been performed over 20 years. They’ve been doing the same musical numbers for years to sold out audiences. Adele has been singing the same genre of music and always in English. Does it matter that she doesn’t sing in other genre or sing in Chinese?
One dance production in the Netherlands can be performed up to 50 performances within the Netherlands itself. In Taiwan, a dance work only performed 5 times the most. They are forced to constantly create new works and leave the old works behind. That is a waste of arts funding and it doesn’t educate the public on the value of the arts. These performers is old enough to decide what they want to show these judges with their limited time.
In the end it wasn’t just disrespectful to the performers, but also to the arts.
I was contacted by the Taipei Cultural Affair on Monday, the representative spoke nicely promising that they would discuss further with me. He asked me to take the adjudicator’s picture down, I agreed with the condition of meeting in person to further discuss what could be done better. I have refused to talk to reporters for the last few days. I have been waiting but I then heard the excuses given to the media. Since I’ve taken down the picture of the head adjudicator, they haven’t made any attempt to contact me. I came into a realization that when they made the call, it wasn’t to address the problem but simply to manipulate me to take down his picture. I’m disappointed at this institution that was supposed to promote the arts and culture.
I realized I am not a public figure, nor am I responsible for the well being of all artists who want to get a busker license. After my Facebook post went viral, I’ve been thinking so much about this issue. I kept going back and forth questioning whether I should keep fighting for this. It doesn’t feel like my fight, but at the same time I feel responsible as an art educator.
I truly believe this can be fixed. I need to emphasize, I am not attacking anyone. And I don’t want to shame anyone. I want to start a discussion how to make it better. Taipei has some of the best performers I’ve seen, yet the lack of respect for the arts and artists has suppressed their ability to excel. And ironically, it’s often done unintentionally.
If the exam is done based on respect for the arts itself, things might have come out differently. And just maybe if we all let go the “face” culture, we could possibly see further to realize that we are all wanting the same thing.
I saw mistreatments towards performers that day. It was very obvious I wasn’t the only one witnessing it. It was not that I don’t respect these adjudicators/teachers, but because I respect the arts and the meaning of a teacher that is why I had to speak up. Somehow my voice had been amplified this week. But my voice wasn’t and isn’t singular. I am simply a voice amongst many.
Sincerely,
William Lü
Taipei National University of the Arts 國立台北藝術大學
寶藏巖國際藝術村 Treasure Hill Artist Village
Taipei National University of the Arts
臺北表演藝術中心 Taipei Performing Arts Center
National Theater and Concert Hall, Taipei
中正紀念堂 Chiang Kai-shek Memorial Hall
National Taiwan University of Arts
Department of Cultural Affairs, Taipei City Government
excel value解決 在 吳老師教學部落格 Youtube 的精選貼文
東吳EXCEL VBA與資料庫(進階92)第2單元_按ENTER自動輸入&防止為輸入資料與輸入非數字錯誤&保護VBA專案與建立資料庫&ACCESS中執行SQL指令&用ADO傳送SQL給資料庫執行&用ADO新增全部與查詢全部資料
上課內容:
01_上星期重點回顧與按ENTER自動輸入
02_防止為輸入資料與輸入非數字錯誤
03_保護VBA專案與建立資料庫
04_如何在ACCESS中執行SQL指令
05_在EXCEL中用ADO傳送SQL給資料庫執行
06_用ADO新增全部與查詢全部資料
完整影音
https://www.youtube.com/playlist?list=PLgzs-Q3byiYO4XHenpJ8DFSvy0486-9kb
教學論壇:
https://groups.google.com/forum/#!forum/scu_excel_vba2_92
與前幾期的課程雖然用的是相同的範例,但最大的不同在:
1.除了解說建函數公式,並將之轉成自訂函數,把複雜的公式變簡單。
2.如何將複雜的公式變成簡單的按鈕,按下按鈕就自動完成工作。
內容主要分成:
第1單元_大數據輸入自動化與R語言的比較說明
第2單元_大數據表單與資料庫
第3單元_大數據工作表合併與匯出資料庫
第4單元_EXCEL當資料庫與查詢系統建立
第5單元_批次查詢與雲端與網路下載資料
第6單元_工作表排序(大到小、筆畫、清單)
第7單元_工作表處理(顯示、顏色、複製與刪除)、活頁簿與檔案處理(工作表分割與合併活頁簿)
第8單元_表格與圖表處理(自動繪製圖表)、圖案處理(快速匯入圖片到EXCEL)
有講義與範例和完成的畫面公式與程式碼,
只要按照每周的順序學習,學會EXCEL VBA自動化絕非難事,
優點:
1.可非線性學習:可按照自己最不熟的部分多次學習。
2.可反覆學習:有疑問可以多次聽講,保證學的會。
3.可攜帶學習:只要有瀏覽器就可以播放SWF檔,MAC電腦也沒問題。
上課參考用書:
看!就是比你早下班-50個ExcelVBA高手問題解決法
作者:楊玉文 出版社:松崗
Excel VBA一點都不難:一鍵搞定所有報表
作者:?Excel Home
出版社:博碩
課程理念:
1.以循序漸進的方式, 透過詳細的說明和實用的Excel VBA範例, 逐步了解整個 VBA 的架構與輪廓,進而學習 VBA 變數、函式及邏輯的觀念, 即使沒有任何程式設計基礎, 也能自己親手撰寫 VBA 程序來提昇工作效率, 晉身職場 Excel 高手! 2.進而解說EXCEL與資料庫的結合,將EXCEL當成資料庫來使用,結合函數、VBA等更深入的功能,讓資料處理和分析的應用更上層樓。 3.將結合GOOGLE雲端試算表,教您如何將EXCEL函數雲端化與網路化。
更多EXCEL VBA連結:
01_EXCEL函數與VBA http://terry28853669.pixnet.net/blog/category/list/1384521
02_EXCEL VBA自動化教學 http://terry28853669.pixnet.net/blog/category/list/1384524
吳老師 2016/3/9
EXCEL,VBA,函數東吳進修推廣部,EXCEL,VBA,函數,程式設計,線上教學,excel,vba,教學,excel,vba指令教學,vba範例教學excel,,excel,vba教學視頻,excel函數教學,excel函數說明,excel函數應用
excel value解決 在 吳老師教學部落格 Youtube 的精選貼文
東吳EXCEL VBA辦公自動化第2次上課(87)
網路的學習方式非常彈性,隨時隨地都可以學習,因此許多非大台北地區的學生會這樣學習。以下為完整教學影音DVD申請說明網址:http://terry55wu.blogspot.tw/p/dvd.html
上課內容:
01_雲端資源與如何建立資料庫與SQL語言
02_如何啟動表單與密碼保護VBA程序
03_如何建立資料庫與匯入EXCEL工作表
04_如何在ACCESS中執行SQL語法
05_如何在表單中新增一筆資料到資料庫
06_如何新增全部資料到資料庫並刪除舊資料
07_如何設定網芳共用功能與分享資料庫
08_如何修改資料庫路徑與執行
09_如何增加進度列顯示新增狀況
完整影音教學論壇(請自行申請加入,以後影音不郵寄):
https://groups.google.com/forum/#!forum/scu_excel_vba2_87
與前幾期的課程雖然用的是相同的範例,但最大的不同在:
1.除了解說建函數公式,並將之轉成自訂函數,把複雜的公式變簡單。
2.如何將複雜的公式變成簡單的按鈕,按下按鈕就自動完成工作。
內容主要分成:
1.常用函數
2.進階函數應用
3.從函數到VBA設計
4.如何自訂函數
5.VBA程式設計入門
6.如何錄製巨集與修改
7.如何將大量資料轉存到資料庫
8.如何讀取資料庫資料
詳細目錄:http://goo.gl/eQptxx
有講義與範例和完成的畫面公式與程式碼,
只要按照每周的順序學習,學會EXCEL VBA自動化絕非難事,
優點:
1.可非線性學習:可按照自己最不熟的部分多次學習。
2.可反覆學習:有疑問可以多次聽講,保證學的會。
3.可攜帶學習:只要有瀏覽器就可以播放SWF檔,MAC電腦也沒問題。
上課參考用書:
看!就是比你早下班-50個ExcelVBA高手問題解決法
作者:楊玉文 出版社:松崗
出版日期:2011年02月15日 定價:550元
課程理念:
1.以循序漸進的方式, 透過詳細的說明和實用的Excel VBA範例, 逐步了解整個 VBA 的架構與輪廓,進而學習 VBA 變數、函式及邏輯的觀念, 即使沒有任何程式設計基礎, 也能自己親手撰寫 VBA 程序來提昇工作效率, 晉身職場 Excel 高手! 2.進而解說EXCEL與資料庫的結合,將EXCEL當成資料庫來使用,結合函數、VBA等更深入的功能,讓資料處理和分析的應用更上層樓。 3.將結合GOOGLE雲端試算表,教您如何將EXCEL函數雲端化與網路化。
更多EXCEL VBA連結:
01_EXCEL函數與VBA http://terry28853669.pixnet.net/blog/category/list/1384521
02_EXCEL VBA自動化教學 http://terry28853669.pixnet.net/blog/category/list/1384524
吳老師 2014/12/9
EXCEL,VBA,函數東吳進修推廣部,EXCEL,VBA,函數,程式設計,線上教學,excel,vba,教學,excel,vba指令教學,vba範例教學excel,,excel,vba教學視頻,excel函數教學,excel函數說明,excel函數應用
excel value解決 在 吳老師教學部落格 Youtube 的最讚貼文
東吳EXCEL VBA辦公自動化第2次上課(87)
網路的學習方式非常彈性,隨時隨地都可以學習,因此許多非大台北地區的學生會這樣學習。以下為完整教學影音DVD申請說明網址:http://terry55wu.blogspot.tw/p/dvd.html
上課內容:
01_雲端資源與如何建立資料庫與SQL語言
02_如何啟動表單與密碼保護VBA程序
03_如何建立資料庫與匯入EXCEL工作表
04_如何在ACCESS中執行SQL語法
05_如何在表單中新增一筆資料到資料庫
06_如何新增全部資料到資料庫並刪除舊資料
07_如何設定網芳共用功能與分享資料庫
08_如何修改資料庫路徑與執行
09_如何增加進度列顯示新增狀況
完整影音教學論壇(請自行申請加入,以後影音不郵寄):
https://groups.google.com/forum/#!forum/scu_excel_vba2_87
與前幾期的課程雖然用的是相同的範例,但最大的不同在:
1.除了解說建函數公式,並將之轉成自訂函數,把複雜的公式變簡單。
2.如何將複雜的公式變成簡單的按鈕,按下按鈕就自動完成工作。
內容主要分成:
1.常用函數
2.進階函數應用
3.從函數到VBA設計
4.如何自訂函數
5.VBA程式設計入門
6.如何錄製巨集與修改
7.如何將大量資料轉存到資料庫
8.如何讀取資料庫資料
詳細目錄:http://goo.gl/eQptxx
有講義與範例和完成的畫面公式與程式碼,
只要按照每周的順序學習,學會EXCEL VBA自動化絕非難事,
優點:
1.可非線性學習:可按照自己最不熟的部分多次學習。
2.可反覆學習:有疑問可以多次聽講,保證學的會。
3.可攜帶學習:只要有瀏覽器就可以播放SWF檔,MAC電腦也沒問題。
上課參考用書:
看!就是比你早下班-50個ExcelVBA高手問題解決法
作者:楊玉文 出版社:松崗
出版日期:2011年02月15日 定價:550元
課程理念:
1.以循序漸進的方式, 透過詳細的說明和實用的Excel VBA範例, 逐步了解整個 VBA 的架構與輪廓,進而學習 VBA 變數、函式及邏輯的觀念, 即使沒有任何程式設計基礎, 也能自己親手撰寫 VBA 程序來提昇工作效率, 晉身職場 Excel 高手! 2.進而解說EXCEL與資料庫的結合,將EXCEL當成資料庫來使用,結合函數、VBA等更深入的功能,讓資料處理和分析的應用更上層樓。 3.將結合GOOGLE雲端試算表,教您如何將EXCEL函數雲端化與網路化。
更多EXCEL VBA連結:
01_EXCEL函數與VBA http://terry28853669.pixnet.net/blog/category/list/1384521
02_EXCEL VBA自動化教學 http://terry28853669.pixnet.net/blog/category/list/1384524
吳老師 2014/12/9
EXCEL,VBA,函數東吳進修推廣部,EXCEL,VBA,函數,程式設計,線上教學,excel,vba,教學,excel,vba指令教學,vba範例教學excel,,excel,vba教學視頻,excel函數教學,excel函數說明,excel函數應用
excel value解決 在 EXCEL出現#VALUE的問題 - Mobile01 的推薦與評價
我在B4的輸入公式如下=CHOOSE(MATCH(A4,$C$72:$C$78,0),$D$72,$D$73,$D$74,$D$75,$D$76,$D$77,$D$78)但如果A4是空白的話就會出現#VALUE請問要怎麼解決這個問題呢? ... <看更多>
excel value解決 在 【Excel教學】複製公式為什麼相同內容會出現#Value錯誤 的推薦與評價
這是網友問的問題,他說為什麼一樣的公式有些欄位會出現# Value 錯誤,幫他看了原始資料,發現是空白字串造成的,空字串在計算過程會自動轉換成0, ... ... <看更多>