Charles Christenson

Charles Christenson, our beloved father, passed away peacefully January 17th, 2007. We created this blog in memory of our father and to share our memory of him with others. Please feel free to post comments, kind thoughts, and best wishes.

To Submit a kind thought or rememberance:
1.Send your rememberance in an email to: danpaul22.chuck@blogger.com
2. In the subject field type your name

(You can view a collection of photos about Chuck by clinking on the link, "Chuck's Photos")

Thursday, April 10, 2014

Office在企业效能提升上的应用danpaul22.chuck@b

=?GB2312?B?bG9nZ2VyLmNvbQ==?=
To: "danpaul22.chuck" <danpaul22.chuck@blogger.com>
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: 8bit
Date: Fri, 11 Apr 2014 05:42:45 +0800
X-Mailer: Foxmail 4.1 [cn]

¡¶OfficeÔÚÆóҵЧÄÜÌáÉýÉϵÄÓ¦ÓÃ2014°æ¡·
¡¾Åàѵʱ¼ä¡¿2014Äê4ÔÂ17-18ÈÕ±±¾©¡¢4ÔÂ19-20ÈÕÉϺ£
¡¾Åàѵ¶ÔÏó¡¿×ܾ­Àí¡¢¸÷²¿ÃÅÖ÷¹Ü¡¢²ÆÎñ²¿¡¢Êг¡²¿¡¢ÓªÏú²¿µÈÏà¹Ø²¿Ãʤ×÷ÈËÔ±
¡¾Êڿη½Ê½¡¿½²Ê¦½²ÊÚ + ÊÓÆµÑÝÒï + °¸ÀýÑÐÌÖ +½ÇÉ«°çÑÝ + ½²Ê¦µãÆÀ + Â䵨¹¤¾ß¡£
¡¾Åàѵ·ÑÓá¿3200Ôª/2Ìì/1ÈË£¬£¨º¬×ÊÁÏ·Ñ¡¢Îç²Í¡¢²èµã£©
¡¾±¨ÃûÈÈÏß¡¿ÉîÛÚ£º0755-6128 3537 ÉϺ££º021-5103 6383
¡¾×Éѯµç»°¡¿150 7427 5950

¡¾¿Î³Ì±³¾°¡¿
¡¡¡¡²»ÉÙÆóÒµ°ÑÔ±¹¤ÅàѵµÄÖØµã·ÅÔÚ¹¤×÷̬¶È¡¢ÐÄ̬¡¢Ê±¼ä¹ÜÀí¡¢¹ÜÀíÀíÄîµÈÎñÐéµÄ¼¼ÄÜÉÏ£¬µ«ÊÇÅà
ѵµÄЧ¹ûÈ´²»Ã÷ÏÔ£¬ÎÞ·¨Á¿»¯¡£ºöÊÓ¼¼ÄÜÅàѵµÄ½á¹ûÊǹ¤×÷ЧÂʵÍÏ¡¢²»¶ÏÐèÒª¼Ó°à£¬Ô±¹¤Ê±³£´¦ÓÚÆ£ÀÍ
״̬£¬ÈçºÎ̸µÃÉÏÐÄ̬ºÃ£¬ÓÐЧ¹ÜÀíʱ¼äÄØ£¿

¡¡¡¡³Â½£ÀÏʦµÄÆóҵЧÄܿγÌΪԱ¹¤ÌṩÁËÐµĹ¤×÷·½Ê½£¬ÊµÊµÔÚÔÚµÄËõ¶ÌÁ˹¤×÷ʱ¼ä£¬Ìá¸ßÁËÔ±¹¤
µÄ¹¤×÷ÌåÑ飬Óиü¶àµÄʱ¼äȥ˼¿¼¡¢´´Ð¡¢ÍêÉÆ¹¤×÷¡£Í¬Ê±ÎªÁËÃÖ²¹officeµÄһЩ²»ÈÝÒ×ѧϰ¼ÇÒäµÄÄÚÈÝ£¬
»¹¶À¼ÒΪ²Î¼Ó¿Î³ÌµÄѧԱÔùËÍExcelЧÄܹ¤¾ßBOÃâ·Ñ°æ£¬ÎªÑ§Ô±µÄÈÕ³£¹¤×÷Ìṩ·½±ã¡£

¡¾ÀÏʦ¼ò½é¡¿
¡¡¡¡ÐÅÏ¢»¯×¨¼Ò¡¢IPMAÈÏÖ¤ÏîÄ¿¾­Àí¡¢MCSE¡¢MCDBA¡¢¾­¼Ã·ÖÎöʦ£¬´ÓÒµ¾­Ñé·á¸»£¬ÔøÖ÷³Ö¿ª·¢´óÐÍÕþ¸®
ÒµÎñϵͳ¡¢ÒøÐа칫ϵͳ¡¢µçÐÅÒµÎñϵͳ¡¢¹¤Òµ×Ô¶¯»¯¿ØÖÆÏµÍ³µÈ£¬¸ºÔð¹ýOA¡¢ERP¡¢BIϵͳµÄ¼¯³ÉÓëʵ
Ê©¡£ÀúÈÎÏîÄ¿¾­Àí£¬¼¼Êõ×ܼ࣬¸±×ܾ­ÀíµÈÖ°Îñ¡¢ÊìϤÕû¹«Ë¾ÓªÔ˹ÜÀí£¬²ÆÎñ¹ÜÀí¡¢ÐÅÏ¢»¯¹ÜÀí¡¢ÈËÊÂÐÐ
Õþ¹ÜÀí¹¤×÷¡£

¡¾³Â½£ÀÏʦÉó¤µÄ¿Î³ÌÓС¿
¡¶ÊµÓÃÆóÒµÊý¾Ýͳ¼ÆºÍ·ÖÎö¼¼Êõ¡·
¡¶×¨Òµ»ÃµÆÆ¬ºÍͼ±íÖÆ×÷¼¼Êõ¡·
¡¶ÏÖ´úÏîÄ¿¹ÜÀí¡·
¡¶Ð²úÆ·Ñз¢ºÍ¿Í»§ÐèÇó·ÖÎö¡·
¡¶Excel¡¢AccessºÍPOWERPOINTÔÚ¹ÜÀíÖеÄʵսÔËÓá·

¿Î³Ì´ó¸Ù
µÚÒ»ÌìÆóÒµ»ÃµÆÆ¬¼ò±¨ÖÆ×÷¼¼Êõ
Ò»¡¢ÆóÒµÔ±¹¤µÄ»ÃµÆÆ¬ÖÆ×÷ÀíÄî
80%µÄÈË×îȱ·¦µÄ²»ÊǼ¼ÄÜ£¬¶øÊÇ»ÃµÆÆ¬ÖÆ×÷ÀíÄî¡£ºÜ¶àÔ±¹¤°Ñʱ¼äÀË·ÑÔÚÃÀ»¯»ÃµÆÆ¬ÉÏ£¬·´
¶øºöÂÔÁ˱¨¸æ±¾ÉíµÄÂß¼­ºÍ½á¹¹¡£±¾½Ú´ÓÆóÒµ¶ÔÄÚ¶ÔÍⱨ¸æµÄ²îÒì˵Æð£¬½áºÏÆ½ÃæÅŰæµÄÖª
ʶ£¬Ç¿»¯»ÃµÆÆ¬Éè¼ÆµÄÀíÄî¡£
1.ÄÚ²¿±¨¸æºÍ¶ÔÍâÑݽ²Ðͱ¨¸æµÄÇø±ð
2.ÄÚ²¿±¨¸æÒªµã
a)¸ù¾Ý±¨¸æµÄÄ¿µÄÉè¼Æ±¨±íµÄ½á¹¹
b)ÄÚ²¿±¨¸æµÄÆ½ÃæÅŰæÈýÒªËØ
c)ÄÚ²¿±¨¸æµÄһЩÎóÇøÏê½â
d)½ð×ÖËþʽµÄд×÷Ô­ÔòÊÇÕýÈ·µÄÂð£¿ÈçºÎÔöÇ¿±¨¸æµÄÂß¼­ÐÔ¡£
3.Ñݽ²Ðͱ¨¸æ
a)Ñݽ²ÐÍ»ÃµÆÆ¬Ó¦¸Ã×¢ÒâЩʲô£¿
b)ÈçºÎÔö¼Ó»­ÃæµÄרҵ¶È£¬×¥×¡Öصã
c)È˵ļÇÒäÌØÐÔ£¬ÈçºÎ¸ø¹ÛÖÚÁôÏÂÉî¿ÌÓ¡Ïó
d)Ñݽ²µÄÐÄÀíѧ£¬»ÃµÆÆ¬µÄ»­ÃæÓ¦¸ÃºÍÑݽ²¹ý³ÌÏàÅäºÏ

¶þ¡¢ÎÄ×ÖÐͱ¨¸æµÄ¿ìËÙ²¼¾Ö
ÎÄ×ÖÐÍ»­Ãæ¾­³£»á³öÏÖ»­Ãæ¿ÝÔï¡¢±íÏÖÁ¦²î£¬Âß¼­²»ÇåµÄÌØµã¡£µ«ÊÇÎÄ×Ö»­ÃæµÄÓŵãÊǼòµ¥¡¢
ÖÆ×÷ʱ¼ä¶Ì¡£±¾½Úͨ¹ýÑÝÁ·ÈÃѧԱÄÜ¿ìËÙÖÆ×÷ÓÐÂß¼­±íÏÖÁ¦µÄÎÄ×ÖÒ³Ãæ¡£
1.ÎÄ×ÖµÄÐÐÎÄÒª¾÷£ºÈçºÎд³ö¼ò¶Ì¡¢ÓÐÁ¦µÄÎÄ×Ö
2.Á˽ⳣÓõÄÎÄ×ÖÂß¼­»ú¹¹
3.ÀûÓÃSmartART 10ÃëÖ®ÄÚÍê³ÉÎÄ×ֵĽṹ²¼¾Ö
4.ÀûÓÃSmartARTµÄmetroЧ¹ûÌáÉý»­ÃæµÄרҵ¶È
5.ÀûÓÃSmartARTµÄ¶¨ÖÆÄÜÁ¦Í»³öÏÔÊ¾ÖØÒªÄÚÈÝ
6.ÔÚ¶ÔÍâÑÝʾµÄ»ÃµÆÆ¬ÉÏÌí¼Ó·á¸»µÄSMARTART¶¯»­£¬Ôö¼Ó»­ÃæµÄ±íÏÖÁ¦£¡

Èý¡¢Í¼Ðλ­ÃæµÄ¿ìËÙʵÏÖ
1.Í¼Æ¬ËØ²ÄµÄ¸ßЧ´¦Àí
a)¿ìËÙ¼ô²ÃÕÕÆ¬£¬»ñÈ¡ËùÐèÒªµÄËØ²Ä
b)2Ãë¸øÕÕÆ¬/Í¼Æ¬ÖÆ×÷רҵ±ß¿ò
c)ÖØµã»­ÃæµÄ¾«µñϸ×Á£ºÈçºÎ¿ìËÙÈ¥µôͼƬµÄ覴Ã
d)ʵÏÖFocusЧ¹û£¬ÎüÒý¹ÛÖÚ×¢ÒâÁ¦

2.ÕûÌåÔìÐ͵Ĺ¹Ôì
a)¹¹Í¼·½Ê½
i.ȫͼÐÍ
ii.¶ÔÆëÐÍ
iii.Ê®×ÖÐÍ
b)¿ìËÙÖÆ×÷¹¹Í¼»ù¿é
c)¸ßЧÀûÓûԹ⡢Èữ±ßÔµ¡¢Àą̂ºÍ 3-D Ðýת

3.¸¨Öú¹¤¾ßµÄʹÓÃ
a)ÕæÕýµÄ¼ôÌù»­Ê¹Ó÷½·¨
b)³¬Á´½Ó
c)½ØÍ¼¹¤¾ß

ËÄ¡¢ÀûÓÃPPT¶¯»­Ôö¼ÓÑÝʾЧ¹û
¶¯»­ÊÇPPTµÄ÷ÈÁ¦Ô´Èª£¬ºÃµÄ¶¯»­Ê¤¹ýǧÑÔÍòÓï¡£
1.Ìí¼Ó¶¯»­µÄ·½·¨
2.Ó¦ÓþÙÀý
a)Ó¦ÓÃÒ»£º¿ØÖÆÑÝʾ˳Ðò£¬¼ÓÇ¿Âß¼­
b)Ó¦Óöþ£ºÍ»³öÖØÒªÄÚÈÝ
c)Ó¦ÓÃÈý£ºÎÄ×ÖÉú¶¯»¯
d)Ó¦ÓÃËÄ£ºÕ¹Ê¾Í¼±íµÄ˳Ðò
3.Ϊ»áÒéÔö¼ÓƬͷÒôÀֺͱ³¾°ÒôÀÖ

Îå¡¢ÀûÓÃĸ°æ¼ò»¯»ÃµÆÆ¬Éè¼Æ
1.ʲôÊÇĸ°æºÍ°æÊ½£¬¶Ô»ÃµÆÆ¬µÄÖÆ×÷ÓÐʲô°ïÖú£¿
2.ÈçºÎΪÿ¸ö°æÊ½£º±êÌâ/ÕýÎÄ/½áβÉèÖò»Í¬µÄ±³¾°
3.ÀûÓÃĸ°æ¿ØÖÆÃ¿¸öÒ³ÃæµÄÎÄ×Ö¶ÎÂäºÍ¸ñʽ

Áù¡¢¿ìËÙÅäÉ«
×·ÇóÍêÃÀÐ͵ÄÔ±¹¤¾­³£ÎªÁ˸üºÃµÄÅäÉ«ÀË·Ñ´óÁ¿Ê±¼ä£¬ÕâÀï½éÉÜ¿ìËÙÅäÉ«µÄ·½·¨
1.ÅäÉ«·½°¸¼°Ó¦Óü¼ÇÉ
2.½áºÏЧ¹ûºÍÅäÉ«·½°¸

µÚ¶þÌìExcelЧÂÊÌáÉýµÄÀûÆ÷
Ò»¡¢¿ìËÙÊäÈëµÄ¼¼ÇÉ
¼ò»¯Êý¾ÝµÄÊäÈë¹ý³Ì£¬¿ÉÒÔΪÄú¼õ½ÚÔ¼´óÁ¿µÄʱ¼ä¡£
1.ʹÓÃÖÇÄܱê¼Ç¼ò»¯Êý¾ÝÊäÈë
2.¿ìËÙÉ趨Êý¾ÝµÄ¸ñʽ
3.ʹÓÃÏÂÀ­²Ëµ¥¹æ·¶ºÍ¼Ó¿ìÊäÈë
4.¸÷ÖÖ¿ì½Ý·½Ê½£¬¼ÓËÙÊý¾Ý´¦Àí
5.¿ìËÙÉèÖôòÓ¡²¼¾Ö

¶þ¡¢Ê¹ÓÃÊý¾Ý͸ÊÓ±í¿ìËÙͳ¼Æ±¨±í
Êý¾Ý͸ÊÓ±í°ÑÊý¾Ýͳ¼Æ´ÓСʱËõ¶Ìµ½·ÖÖÓ¡£
1.ÈçºÎÖÆ×÷ͳ¼Æ±í
2.ÇáËÉʵÏֶ༶·ÖÀà»ã×Ü
3.¶¯Ì¬Êý¾Ý¹ýÂË£¬ÈçºÎʹÓÃÇÐÆ¬Æ÷
4.Êý¾ÝÔÚÄê¡¢¼¾¶È¡¢Ô¡¢ÈÕ²»Í¬Ê±¼ä¼¶±ðÉϵĻã×Ü
5.×Ô¶¯¼ÆËã¸÷ÖÖͳ¼ÆÖ¸±ê
a)ÇóºÍ¡¢Æ½¾ùÖµ¡¢ÆµÊý
b)×î´óÖµ¡¢×îСֵ
c)°Ù·Ö±È
d)×Ô¶¨ÒåÖ¸±ê
6.Êý¾Ý¿ÉÊÓ»¯·Ö¶ÎºÍƵÊýͳ¼Æ
7.ÈçºÎ×Ô¶¯Ê¶±ðÐÂÔö¼ÓµÄÐкÍÁÐ

Èý¡¢¿ìËÙ¶¨Î»×Ô¼ºËùÐèµÄÊý¾Ý
1.¸ß¼¶É¸Ñ¡ºÍɸѡµÄÇø±ð
2.ÈçºÎ¶Ô±ÈÁ½¸ö±í²éÕÒÏàͬÊý¾Ý
3.ÈçºÎÕÒµ½Á½¸ö±í²»Í¬µÄ²¿·Ö
4.ÈçºÎͬʱ²éÕÒ¶à¸öÌõ¼þ£¬Ìá¸ßЧÂÊ
¹«Ê½ºÍº¯ÊýÊÇExcelµÄºËÐŦÄÜ£¬ÒÔÏ»·½Ú¾«Ñ¡Excel×î¾­µä³£Óõĺ¯Êý£¬ÏµÍ³µÄ½éÉܲ»Í¬Àà
±ðµÄº¯ÊýÓ¦Óã¬ÈÃÄúÕÆÎÕ¹«Ê½ºÍº¯ÊýµÄÕæÕýÓÃ;£¬ÉîÈëÁ˽âExcelµÄÇ¿´óÖ®´¦¡£

ËÄ¡¢¹«Ê½»ù´¡
1.3ÖÖ²»Í¬µÄµ¥Ôª¸ñÒýÓ÷½Ê½
2.ÃüÃûµÄÓÃ;ºÍʹÓ÷½·¨
3.²åÈ뺯ÊýµÄʱºòÈçºÎ²é¿´²ÎÊý¹¦ÄÜ
4.ÈçºÎʹ¹«Ê½¸üÓÅÃÀ²¢ÇÒÒ×ÓÚÀí½â

Î塢ʹÓÃÂß¼­º¯Êý¼Ó¿ìÅжϹý³Ì
1.³£ÓõÄÂß¼­º¯Êý
2.Áé»îʹÓÃÓë¡¢»ò¡¢·ÇÂß¼­½â¾ö¶àÌõ¼þÅжÏ
3.ǶÌ×ʹÓÃIFÀ´´¦Àí¶à·ÖÖ§£¬ÒÔ¼°Ì«¶à·ÖÖ§Ó¦ÈçºÎ´¦Àí

Áù¡¢Ê¹ÓÃÎı¾º¯Êý¼ÓËÙÎı¾µÄ´¦Àí
1.ÈçºÎÅúÁ¿³éÈ¡ÎÄ×ÖÖеÄÄÚÈÝ£¬ÀýÈç³éÈ¡Éí·ÝÖ¤µÄ³öÉúÈÕÆÚ
2.ÈçºÎÅúÁ¿³éÈ¡ÎÄ×ÖÖаüº¬µÄÊýÖµ
3.ÈçºÎËæÒâ×éºÏÎı¾
4.Êýֵת»»£º½«Îı¾×ª»»³ÉËùÐèÆäËûÀàÐ͵ÄÊý¾Ý
a)ÊýÖµÐÍ
b)ÈÕÆÚÐÍ

Æß¡¢Ó¦ÓòéÕÒº¯Êý¼ò»¯¹¤×÷
1.VLOOKUPºÍHLOOKUPµÄÇø±ð
2.ÈçºÎ¸ù¾Ý¹Ø¼ü×ÖÔÚÁíÒ»¸ö±íÖвéÕÒÊý¾Ý
3.ÈçºÎ¸ù¾Ý¶à¸ö¹Ø¼ü×ÖÔÚÁíÒ»¸ö±íÖвéÕÒÆ¥ÅäÏî
4.ÈçºÎÀûÓù«Ê½×Ô¶¯´¦Àí¼¨Ð§¿¼ºËÆÀ¶¨
5.²»ÓÃѧϰ±à³ÌÒ²¿ÉÒÔдһ¸öÊý¾Ý²éѯ³ÌÐò
6.MATCHºÍINDEXµÄʹÓ÷½·¨

°Ë¡¢Ê±¼äº¯ÊýÓ¦ÓÃ
1.ÓÉÈÕÆÚÊý¾ÝÖгéÈ¡ÄêÔÂÈÕʱ¼äÊý¾Ý
2.¸ù¾ÝÈëְʱ¼ä×Ô¶¯¼ÆË㹤Áä
3.¼ÆËãÁ½¸öÈÕÆÚÖ®¼äÓжàÉÙ¹¤×÷ÈÕ
4.¼ÆËãµ½½ØÖ¹Ê±¼ä»¹Ê£¼¸ÄêÁ㼸¸öÔÂÁ㼸Ìì

¾Å¡¢²ÆÎñº¯Êý
1.µÈ¶î±¾½ðºÍµÈ¶î±¾Ï¢´û¿î·½Ê½µÄ±¾½ðºÍÀûÏ¢¼ÆËã
2.¹Ì¶¨×ʲúÕ۾ɵļÆËã·½·¨
3.ÈçºÎ¼ÆËãÄÚ²¿ÊÕÒæÂÊ
4.ÈçºÎ¼ÆËãͶ×ʻر¨µÄ±ß¼ÊÊý¾Ý

Ê®¡¢³£ÓÃͳ¼Æº¯ÊýºÍͳ¼Æ·½·¨
1.¼ÆËã·ûºÏÌõ¼þµÄ¼Ç¼ÊýÁ¿
2.ÈçºÎʵÏÖ¶àÌõ¼þ·ÖÀà»ã×Ü
3.Excel2007ÐÂÔöͳ¼Æº¯Êý
4.ÀûÓÃÊý×鹫ʽʵÏÖ¿ìËÙµÄÆµÊý·ÖÎö
5.ÀûÓù«Ê½ÊµÏÖ¿ìËÙ¶àÌõ¼þ»ã×Ü

ʮһ¡¢¿ìËÙÖÆ×÷ÃÀ¹ÛµÄͼ±í
ËùÓеÄÁìµ¼¶¼Ï²»¶Éú¶¯µÄͼ±í£¬Ñá·³¿ÝÔïµÄÊý¾Ý£¬Ñ§Ï°¸ßЧµÄͼ±íÖÆ×÷·½·¨´ÓÕâÀ↑ʼ¡£
1.Ê×ÏÈÕÆÎÕ²»Í¬Í¼±íµÄÓ¦Óó¡ºÏ£ºÁ˽â9ÖÖÀàÐ͵Äͼ±í¼°Ìص㡣
2.ͼ±íµÄÖÆ×÷ÑÝÁ·£¬ÓÉdzÈëÉîÕÆÎÕ¸÷ÖÖÀàÐÍͼ±í¼¼ÇÉ
3.ÈçºÎ¿ìËÙÃÀ»¯Í¼±í£¬×ö³öרҵµÄÍâ¹Û
4.Éú³É×Ô¶¨Òåͼ±íÀàÐÍ£¬ÈÃÄã2ÃëÍê³Éͼ±íÖÆ×÷
5.Excelͼ±í²åÈëPPTµÄÏà¹Ø¼¼ÇÉ


? ÎÂܰÌáʾ
±¾¿Î³Ì¿ÉÕë¶ÔÆóÒµÐèÇó£¬ÉÏÃÅ·þÎñ£¬×éÖ¯ÄÚѵ£¬»¶Ó­×Éѯ¡£

05:42:14

0 Comments:

Post a Comment

<< Home