Train Signal Microsoft Excel

Train Signal Microsoft Excel :4 z\Q]  
by:   
8<0P Ssx  
U!Zj%H1XQ0  
WY>$.e  
Excel 2007 Training Course Outline H;_Ce'oU(  
Video 1 IntroductionMeet your instructor, Bill Kulterman and become familiar with the features of this course and the scenario that will guide you through your learning experience. Q\IViM  
~a3u['B  
Video 2 Welcome to ExcelA thorough explanation of the new interface of Excel 2007, focusing especially on The Ribbon, and navigation. Q_fgpjEh/t  
5tkKd4VfL
 
The Ribbon <X{w^ cT_Q  
Navigation, getting around in Excel E=,b;S-  
Video 3 Entering and Editing DataLearn tricks to enter data lists quicker and easier. Wk3-J&QbS  
.H M3s  
How to enter data @}Ry7H0O  
Working With Ranges of Data Go:(R {P  
Auto Fill, or Fill Series j3%Wrt  
Video 4 CalculationsLearn about basic arithmetic operations, and the syntax for writing Excel formulas. Discover many ways to perform the same function and learn about the new file formats of Excel. NTZ3Np`  
E<! L^A M`  
Understanding the Order of Operations Bi;a~qE  
Using Basic Formulas, E <j=5|0t  
Understanding Functions PX^k;  
What is Absolute Reference? rxol7"2l  
Save and Save As 2uT6M%OC  
Video 5 Multiple WorksheetsUnderstand the difference between a workbook and a worksheet. Learn to add, move, and copy worksheets in an existing workbook or a new one. Learn to calculate data from several worksheets. mh[,E8'd  
3}phg  
What is a Worksheet? 0e#PN@  
Add a new Worksheet `$JZJ!,A  
Using 3D Reference to calculate across several worksheets u=s,bt,"5  
Working With Worksheets qHe H/e%`V  
Video 6 Basic FormattingLearn about fonts, text size, color, cell options, fill, merge and center, borders, and alignment. p`7d9MV^  
D5Sbs(  
Format Numbers &I)tI^P}  
Working with Text C_ d|2C6  
Cell options lU=VCuW!  
Video 7 Organize your Excel dataFreeze Panes to make it easier to work with lots of data. Sort data into groups for better organization. Learn to filter out unwanted data. MW+DqT.h  
*Uy>F[%@  
Freeze Panes OPq|4xu  
Sorting your data *UW 8|\;  
Filtering out unwanted data ^9hc`.5N&?  
Format Data as a Table 't8!.k  
Video 8 Advanced FormattingLearn about the new Styles options and Smart Art in Excel 2007, as well as mastering the drawing tools to create shapes and text boxes. All of this is meant to help give a nice finished appearance to your Excel workbooks. ' ZTRl+  
p}!)4EI=  
Using Excel Table Styles n2AoEbd  
Adding Shapes to your Excel workbooks ?RG;q  
Graphics in Excel DH_~,tK9  
Using the new Smart Art tools {P?DkUO}  
Video 9 Advanced Formulas PART 1Get exposed to some of the most commonly used functions and formulas in Excel. Gain a basic understanding of the types of things you can do with Excel by exposing the user to the different functions available. $(0<T<\  
cC$YD]XdIA  
Naming Ranges of data q
0>9T  
Lookup and Reference functions 1z2v[S&pk  
Logical Test functions g]44|9x(W  
Financial functions ZT/
f  
Using Database Functions |mWSS'7fI  
Text functions +N,Fq/x  
Video 10 Auditing features in ExcelHelp people find errors in their worksheets, make sure the right type of data is being used, and keep an eye on changes as they happen. LHOt(5VY  
!}U3{L-  
Identifying Errors f`>\bdz  
Using Validation \&V[<]  
Watch Your Data 8aRmHy"9l  
Video 11 Create Charts and diagrams in ExcelLearn to present data visually in easily understood charts and graphs. hTby:$aCg  
]moBVRd  
What Is a Chart? CP"5E?dcK  
Create Charts with Excel MxGQM>  
Format Charts with Excel PPpaH!(D  
Video 12 Working with Multiple WorkbooksExpose people to the concept of linking multiple workbooks together with formulas and summarizing information from a group of workbooks. *qL2=2  
K]>4*)A:  
Linking Workbooks 9,Dw;|A]  
Consolidation workbook data MGwXZ7?E  
Video 13 Use and Create a Template in Excel 2007Streamline the process of creating the same worksheet repeatedly. Jq>5:"jZ0  
g0/R\  
What is a template? 'i3-mZ/|8  
Creating our own templates 4TU\SP8sM  
Video 14 Working with Pivot TablesThe goal here is to simply learn the best way to analyze large amounts of data in Excel. C$at9=(E6  
mpD
xJk!   
What are Pivot Tables? [!KsAsmk  
Creating a Pivot Table 5c%Fb:BW=  
What else can I do with Pivot Tables? ,T 3M  
Formatting a Pivot Table  d
*([!!i  
Create a Pivot Chart }L{GwiDMDl  
Video 15 Collaboration in ExcelLearn ways to track several people on the same worksheet and merge them together into a finished document; again, another time saver. 1#>uqUxah  
#
gf0*:p  
Protect and share a workbook (l2n%LL]*  
Tracking Changes in Excel c(3idO*R)  
Merging Documents <Z~Nz>'r  
Insert Comments and Hyperlinks in Excel Z>1yLt@ls  
Video 16 Use and create Macros in ExcelRecord a series of commands performed frequentl .. z'>b)w
Y](  
yg|yoL'g  

未注册仅能浏览部分内容，查看全部内容及附件请先 登录 或 注册

木有人啊