|
|
|
|
|
|
|
|
|
|
Course Criteria
Add courses to your favorites to save, share, and find your best transfer school.
-
0.00 Credits
The Microsoft certified Database Administrator (MCDBA) certification is internationally recognized and is the designation awarded to professionals who design, implement, and administer Microsoft SQL Server databases. The MCDBA certification may lead to career opportunities as Database Administrators, Technical Support Specialists, Network Technicians, and Technical Consultants.
-
0.00 Credits
This course focuses on hands-on learning where you will get a real-world look at the program and work on the tasks for yourself. We'll show you how to install and manage Exchange Server 2007 in a networked environment. The certified instructor will explain the critical new features and show you how to manage multiple Exchange servers in various roles. For example, you will learn about Mailbox Roles, Client Access Roles, and Hub Transport. Another important part of this course goes over how to integrate Exchange Server 2007 into existing Exchange environments such as into an Exchange Server 2000 or an Exchange Server 2003 environment. Your migration to Exchange Server 2007 will be seamless with the experience you will get in the Microsoft Exchange Server 2007 training class.
-
0.00 Credits
Microsoft Excel is the standard spreadsheet program for today's working world. You will begin by reviewing the new Office Ribbon interface. By the end of this class you'll possess the skills to enter and edit data, select cells and ranges, print worksheets, create formulas and functions, and format cell contents.
-
0.00 Credits
Do you work with numbers? Then you need to master Microsoft Excel 2010¿and this is the place to do it. Even ¿non-techie¿ beginners will find it easy to learn Excel in this fun, step-by-step online course. These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This is not a tutorial, but an in-depth class where you¿ll get training, help, and personal support from an experienced instructor as you¿re learning Excel basics step-by-step. By the time you¿re done, you¿ll be using this vital Office 2010 tool like a pro.
-
0.00 Credits
Design and format more effective worksheets. Save time with your regular tasks by creating efficient workbooks with links between worksheets and files. You will learn how to format, use Office templates and create custom templates, worksheet protection, and use linked formulas. You will also create hyperlinks to areas within the workbook and to other documents. Textbook is included.
-
0.00 Credits
The primary objective of this course is to broaden a user's knowledge of Microsoft Office Excel 2007. Key skills learned in this course will be performing advanced tasks, such as creating nested functions, working with data tables, exporting and importing data, performing what-if analysis, and recording macros.
-
0.00 Credits
Introduction to Excel focuses on basis concepts. You will create and edit spreadsheets by entering data, formatting the data, and using formulas to do automatic calculations. You will also learn to enhance your spreadsheets with charting tools to present the data in line graphs, pie charts, bar charts, and more. The workshop assumes participants understand how to use a mouse and drop-down menus, save files to some type of storage media, and perform other basic skills required to run Windows programs.
-
0.00 Credits
Our Intermediate Excel workshop goes well beyond the basics of the plain spreadsheet. Participants will manage large workbooks and use tools to find solutions to financial questions. Next, you will learn how to use templates and graphics, sort and filter data, and perform calculations using special database functions. The course culminates by using analysis tools to include PivotTables and outlines and creating worksheet consistency with style formatting.
-
0.00 Credits
Any proficient Microsoft Excel user will agree that Excel is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use every Excel tool at your disposal? In this course, you'll learn how to maximize Excel's analytical and functional capabilities. Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more of a value to your organization. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead to better decision-making. In this practical and information-packed course, you'll learn how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced pivot table techniques, like creating calculated fields and calculated items. You'll become adept at consolidating and importing data, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. And you'll become proficient at nesting functions within other functions to accomplish just about anything Microsoft Excel has to offer.
-
0.00 Credits
This course covers how Excel¿s functions work and explores how to use them through hands-on practice using Microsoft Excel 2003®.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Privacy Statement
|
Terms of Use
|
Institutional Membership Information
|
About AcademyOne
Copyright 2006 - 2024 AcademyOne, Inc.
|
|
|