Microsoft Office Specialist: Excel 2003 Study Guide
by Linda F. Johnson
from Sybex
Validate your expertise and get the attention of employers with Microsoft Office Specialist certification. This comprehensive guide is what you need to prepare for certification in Excel 2003, both the Specialist and Expert levels.
Carefully planned by a seasoned Microsoft Office Specialist instructor, this invaluable study guide uses real-world scenarios to teach the full range of Excel 2003 skills you need-not only to prepare for the certification exams, but also to increase your ability and productivity in the workplace. Covering twenty-four Specialist exam objectives and thirty-three Expert exam objectives, the book progresses through the functions and features of Excel software. Even entry-level Excel users can rapidly build their skills.
Excel 2003 Specialist Certification Skill Sets
* Creating Data and Content
* Analyzing Data
* Formatting Data and Content
* Collaborating
* Managing Workbooks
Excel 2003 Expert Certification Skill Sets
* Organizing and Analyzing Data
* Formatting Data and Content
* Collaborating
* Managing Data and Workbooks
* Customizing Excel
Plus, you'll find additional career preparation tools, including:
* Solutions for real-world scenarios
* Structured learning for quick productivity
* Full glossary of terms
Go to www.sybex.com/go/mosexcel2003 for downloadable sample files from the exercises in the book. Practice what you've learned on your own.
Visit www.sybex.com for all of your professional certification needs.
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
by Sara Morgan
from Microsoft Press
This 2-in-1 training kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It also delivers in-depth preparation, plus practice for 70-442, an exam for the MCITP Database Developer certification. Ace your exam prepand build real-world job skillswith lessons, labs, practice tests, and more. Then assess yourself using 200+ practice questions on the CD, featuring multiple, customizable testing options designed to meet your specific needs. You also get an evaluation version of Microsoft SQL Server 2005 software and an exam discount vouchermaking this kit an exceptional value and a great career investment.
Excel 2000 for Windows for Dummies
by Greg, PhD Harvey
from For Dummies
You may not be a dummy, but that doesn't mean you were born knowing how to use spreadsheets. Excel 2000 for Windows for Dummies will bring you up to speed on Microsoft's premillennial package, even if you've never used anything like it before.
A great reference for the beginner and the pressed-for-time, this book is organized as a series of chapters that build from the basics of pointing and clicking and figuring out the different parts of the spreadsheet to more advanced topics like Web-based data entry and macros. Visual learners will find much to love as well--there are screen shots galore and plenty of icons to point you to the most salient items quickly.
Written in characteristic Dummies-style--laid-back and humorous--the text is as nonthreatening as can be; even the most diehard computer-phobes will find themselves chuckling as they (gulp) learn how to enter data. The techno-geeks down the hall might snicker at the bright yellow book on your desk, but you can snicker right back because you know you have better weekends. --Rob Lightner
Just because electronic spreadsheets like Excel 2000 have become almost as commonplace on today’s personal computers as word processors and games doesn’t mean that they’re either well understood or well used. Excel is a great organizer for all types of data, be they numeric, textual, or otherwise.
Excel 2000 For Windows For Dummies covers all the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In addition to showing you around the worksheet, this fun and friendly book exposes you to the basics of charting, creating databases, and converting spreadsheets into Web pages. Expect to pick up invaluable tips and tricks on
- Creating a spreadsheet from the get-go
- Dressing up the look of your cells
- Printing your spreadsheet masterpiece
- Facing a database
- Making sense of multiple worksheets
- Editing your worksheet Web pages
Keeping things simple, this book cuts to the chase by telling you in plain terms just what it is that you need to do to accomplish a task using Excel. With spreadsheets as the focus, Excel 2000 For Windows For Dummies shows you how to
- Launch Excel from a toolbar or browser
- Mess around with the menu bar
- Fabricate fabulous formulas
- Tamper with how text wraps
- Add hyperlinks to a worksheet
- Work with WordArt
- Customize and design your own toolbars
- Explore top features of Excel 2000
One look at the Excel 2000 screen (with all the boxes, buttons, and tabs), and you realize that there's a whole lot of stuff going on. With this book as your expert companion, you can tame your anxiety over the tech stuff and cell-abrate success with all the computing, text-editing, and formatting potential in this powerhouse program.
Juniper(r) Networks Secure Access SSL VPN Configuration Guide
by Rob Cameron
from Syngress
Juniper Networks Secure Access SSL VPN appliances provide a complete range of remote access appliances for the smallest companies up to the largest service providers. As a system administrator or security professional, this comprehensive configuration guide will allow you to configure these appliances to allow remote and mobile access for employees. If you manage and secure a larger enterprise, this book will help you to provide remote and/or extranet access, for employees, partners, and customers from a single platform.
* Complete coverage of the Juniper Networks Secure Access SSL VPN line including the 700, 2000, 4000, 6000, and 6000 SP.
* Learn to scale your appliances to meet the demands of remote workers and offices.
* Use the NEW coordinated threat control with Juniper Networks IDP to manage the security of your entire enterprise.
Keyboarding & Word Processing, Lessons 1-60: Certified Approach (College Keyboarding)
by Susie H. VanHuss
from South-Western Educational Pub
Focus on the keyboarding and formatting skills most important for career success! KEYBOARDING AND WORD PROCESSING 17E, LESSONS 1-60, uses proven techniques to guide users from the basics of new-key learning to business documents using the commands of Microsoft® Word 2007. Lessons are clearly focuses on needs with skill building, communication skills, proofreading activities, and document formatting. Lessons 1-25 concentrate on developing keyboarding skill by learning the alphabetic keyboarding, top-row numbers, symbols, and the numeric keypad. Lessons 26-60 teach the basics of document and word processing formats including block and modified block letters, memos, e-mails, tables, review and edit documents, and graphics and newsletters.
Windows Server 2008 Networking and Network Access Protection (NAP)
by Joseph Davies
from Microsoft Press
Get the official resource for deploying, administering, and troubleshooting Windows Server 2008 networking and Network Access Protection (NAP) technologies, direct from the experts who know the technologies best. This definitive resource from award-winning Microsoft® networking author Joseph Davies and Microsoft Most Valuable Professional (MVP) author Tony Northrup also offers expert insights direct from the Windows Server Networking team at Microsoft. You get detailed information about all major networking and network security services, including the all-new Network Access Protection (NAP), authentication infrastructure, IPv4 and IPv6, remote access, virtual private networks, IP security, quality of service, scalable networking, wireless infrastructure and security, DNS, DHCP, Windows® Firewall, and more. You also get a companion DVD with a fully searchable eBook version of the book, plus eBook samples from Understanding IPv6 2nd Edition, Windows Server 2008 TCP/IP Protocols and Services, and TCP/IP Fundamentals. This official Microsoft resource delivers what every Windows administrator needs to master Windows Server 2008 networking.
Key Book Benefits
Delivers in-depth technical guidance for administering, Windows Server 2008 networking and NAP technologies
Features definitive product information from the experts, with additional insights from the Windows Server team at Microsoft and field consultants
Provides the detailed information that every Windows administrator needs about NAP, IPv4 and IPv6, remote access, virtual private networks, IP security, DNS, DHCP, Windows Firewall, and more
Includes a DVD with a fully searchable eBook of all seven volumes, plus bonus eBook samples from three additional networking books
Accessing the WAN, CCNA Exploration Companion Guide
by Bob Vachon
from Cisco Press
Accessing the WAN
CCNA Exploration Companion Guide
Bob Vachon
Rick Graziani
Accessing the WAN, CCNA Exploration Companion Guide is the official supplemental textbook for the Accessing the WAN course in the Cisco Networking Academy CCNA Exploration curriculum version 4. This course discusses the WAN technologies and network services required by converged applications in enterprise networks. The Companion Guide, written and edited by Networking Academy instructors, is designed as a portable desk reference to use anytime, anywhere. The book’s features reinforce the material in the course to help you focus on important concepts and organize your study time for exams.
New and improved features help you study and succeed in this course:
- Chapter objectives: Review core concepts by answering the focus questions listed at the beginning of each chapter.
- Key terms: Refer to the updated lists of networking vocabulary introduced and turn to the highlighted terms in context in each chapter.
- Glossary: Consult the all-new comprehensive glossary with more than 250 terms.
- Check Your Understanding questions and answer key: Evaluate your readiness with the updated end-of-chapter questions that match the style of questions you see on the online course quizzes. The answer key explains each answer.
- Challenge questions and activities: Strive to ace more challenging review questions and activities designed to prepare you for the complex styles of questions you might see on the CCNA exam. The answer key explains each answer.
Bob Vachon is the coordinator of the Computer Systems Technology program and teaches networking infrastructure courses at Cambrian College in Sudbury, Ontario, Canada. Bob has worked and taught in the computer networking and information technology field for 25 years and is a scholar graduate of Cambrian College.
Rick Graziani teaches computer science and computer networking courses at Cabrillo College in Aptos, California. Rick has worked and taught in the computer networking and information technology field for 30 years.
How To: Look for this icon to study the steps that you need to learn to perform certain tasks.
Packet Tracer Activities: Explore networking concepts in activities interspersed throughout some chapters using
Packet Tracer v4.1 developed by Cisco. The files for these activities are on the accompanying CD-ROM.
Also available for the Accessing the WAN Course
Accessing the WAN,
CCNA Exploration
Labs and Study Guide
ISBN-10: 1-58713-201-X
ISBN-13: 978-1-58713-201-8
Companion CD-ROM
The CD-ROM provides many useful tools and information to support your education:
Packet Tracer Activity exercise files
- A Guide to Using a Networker’s Journal booklet
- Taking Notes: A .txt file of the chapter objectives
- More IT Career Information
- Tips on Lifelong Learning in Networking
This book is part of the Cisco Networking Academy Series from Cisco Press. The products in this series support and complement the Cisco Networking Academy online curriculum.
Cisco NAC Appliance: Enforcing Host Security with Clean Access (Networking Technology: Security)
by Chad Sullivan
from Cisco Press
Cisco NAC Appliance
Enforcing Host Security with Clean Access
Authenticate, inspect, remediate, and authorize end-point devices using Cisco NAC Appliance
Jamey Heary, CCIE® No. 7680
Contributing authors: Jerry Lin, CCIE No. 6469,
Chad Sullivan, CCIE No. 6493, and Alok Agrawal
With today's security challenges and threats growing more sophisticated, perimeter defense alone is no longer sufficient. Few organizations are closed entities with well-defined security perimeters, which has led to the creation of perimeterless networks with ubiquitous access. Organizations need to have internal security systems that are more comprehensive, pervasive, and tightly integrated than in the past.
Cisco® Network Admission Control (NAC) Appliance, formerly known as Cisco Clean Access, provides a powerful host security policy inspection, enforcement, and remediation solution that is designed to meet these new challenges. Cisco NAC Appliance allows you to enforce host security policies on all hosts (managed and unmanaged) as they enter the interior of the network, regardless of their access method, ownership, device type, application set, or operating system. Cisco NAC Appliance provides proactive protection at the network entry point.
Cisco NAC Appliance provides you with all the information needed to understand, design, configure, deploy, and troubleshoot the Cisco NAC Appliance solution. You will learn about all aspects of the NAC Appliance solution including configuration and best practices for design, implementation, troubleshooting, and creating a host security policy.
Jamey Heary, CCIE® No. 7680, is a security consulting systems engineer at Cisco, where he works with its largest customers in the northwest United States. Jamey joined Cisco in 2000 and currently leads its Western Security Asset team and is a field advisor for its U.S. Security Virtual team. His areas of expertise include network and host security design and implementation, security regulatory compliance, and routing and switching. His other certifications include CISSP, CCSP®, and Microsoft MCSE. He is also a Certified HIPAA Security Professional. He has been working in the IT field for 13 years and in IT security for 9 years.
- Understand why network attacks and intellectual property losses can originate from internal network hosts
- Examine different NAC Appliance design options
- Build host security policies and assign the appropriate network access privileges for various user roles
- Streamline the enforcement of existing security policies with the concrete measures NAC Appliance can provide
- Set up and configure the NAC Appliance solution
- Learn best practices for the deployment of NAC Appliance
- Monitor, maintain, and troubleshoot the Cisco NAC Appliance solution
This security book is part of the Cisco Press® Networking Technology Series. Security titles from Cisco Press help networking professionals secure critical data and resources, prevent and mitigate network attacks, and build end-to-end self-defending networks.
Category: Cisco Press–Security
Covers: End-Point Security
SSL Remote Access VPNs (Network Security) (Networking Technology: Security)
by Qiang Huang
from Cisco Press
SSL Remote Access VPNs
An introduction to designing and configuring SSL virtual private networks
Jazib Frahim, CCIE® No. 5459
Qiang Huang, CCIE No. 4937
Cisco® SSL VPN solutions (formerly known as Cisco WebVPN solutions) give you a flexible and secure way to extend networking resources to virtually any remote user with access to the Internet and a web browser. Remote access based on SSL VPN delivers secure access to network resources by establishing an encrypted tunnel across the Internet using a broadband (cable or DSL) or ISP dialup connection.
SSL Remote Access VPNs provides you with a basic working knowledge of SSL virtual private networks on Cisco SSL VPN-capable devices. Design guidance is provided to assist you in implementing SSL VPN in existing network infrastructures. This includes examining existing hardware and software to determine whether they are SSL VPN capable, providing design recommendations, and guiding you on setting up the Cisco SSL VPN devices. Common deployment scenarios are covered to assist you in deploying an SSL VPN in your network.
SSL Remote Access VPNs gives you everything you need to know to understand, design, install, configure, and troubleshoot all the components that make up an effective, secure SSL VPN solution.
Jazib Frahim, CCIE® No. 5459, is currently working as a technical leader in the Worldwide Security Services Practice of the Cisco Advanced Services for Network Security. He is responsible for guiding customers in the design and implementation of their networks, with a focus on network security. He holds two CCIEs, one in routing and switching and the other in security.
Qiang Huang, CCIE No. 4937, is a product manager in the Cisco Campus Switch System Technology Group, focusing on driving the security and intelligent services roadmap for market-leading modular Ethernet switching platforms. During his time at Cisco, Qiang has played an important role in a number of technology groups, including the Cisco TAC security and VPN team, where he was responsible for trouble-shooting complicated customer deployments in security and VPN solutions. Qiang has extensive knowledge of security and VPN technologies and experience in real-life customer deployments. Qiang holds CCIE certifications in routing and switching, security, and
ISP Dial.
- Understand remote access VPN technologies, such as Point-to-Point Tunneling Protocol (PPTP), Internet Protocol Security (IPsec), Layer 2 Forwarding (L2F), Layer 2 Tunneling (L2TP) over IPsec, and SSL VPN
- Learn about the building blocks of SSL VPN, including cryptographic algorithms and SSL and Transport Layer Security (TLS)
- Evaluate common design best practices for planning and designing an SSL VPN solution
- Gain insight into SSL VPN functionality on Cisco Adaptive Security Appliance (ASA) and Cisco IOS® routers
- Install and configure SSL VPNs on Cisco ASA and Cisco IOS routers
- Manage your SSL VPN deployment using Cisco Security Manager
This security book is part of the Cisco Press® Networking Technology Series. Security titles from Cisco Press help networking professionals secure critical data and resources, prevent and mitigate network attacks, and build end-to-end self-defending networks.
Category: Networking: Security
Covers: SSL VPNs
Mastering Excel Made Easy v. 2007 through 97 Training Tutorial - Learn how to use Microsoft Excel e Book Manual Guide
from TeachUcomp, Inc.
Over 12 hours of full-motion, animated instruction with crystal-clear audio in Microsoft Excel. 230 individual lessons in Excel 2007 through 97. The best Excel tutorial available. Designed by software training professionals. Learn at your office or home - at your own pace. Includes all of the topics covered in a comprehensive classroom training. Deluxe Training includes three printable instruction manuals (in PDF), along with practice exercises & keyboard shortcuts! Customize your training with the easy-to-use menu. Clear, easy-to-follow, step-by-step instruction. Watch the training sessions as many times as you want while you practice in Excel. No messy set-up, no internet connections needed. The best way to learn Excel on your own.
+++
