Converting Endnotes to Footnotes and Vice Versa. Why Are We Here? A Decision-Making Tool. An Overview of Excel. Ribbon, Tabs, and Icons. The File Menu. Excel File Format. Right Click and Control Keys. Settings and Status Bar. Excel Help. Data Entry. Auto Fill. Adjusting Columns and Rows. Hiding Columns and Rows. Copy and Paste. Sorting Data Single Level. Sorting Data Multiple Levels. Data Formats. Data Alignment. Number Formats.
Borders Line Formats. Cell Color Fill Color. Editing Data in a Cell. Moving Data. Deleting Columns and Rows. Deleting Worksheets. Inserting Columns and Rows. Inserting, Moving, and Renaming Worksheet Tabs. Page Setup. Printing a Worksheet. Basic Formulas. Complex Formulas. Auditing Formulas. Basic Statistical Functions. The Future Value Function. The Payment Function. The Function Library.
IF Function. Nested IF Functions. AND Function. OR Function. VLookup Function. HLookup Function. Column Charts Data Comparisons. Line Charts Trends Over Time. Pie Charts Percent to Total. Titles and Legends. Plot Area and Data Series. X- and Y-Axes Labels. Adding Annotations and Objects. Defining the X-and Y-Axes Manually. The Scatter Plot Chart. Pasting Charts into PowerPoint and Word. Financial Assumptions.
Freeze Panes. Financial Data. Trial Balance and Work Sheets. Business Decisions and Databases. Navigation Pane and Access Objects. File Formats and Other Access Settings. Access Help. Using versus Creating Databases. Creating a New Table. Indexing and Primary Keys. Entering and Formatting Data. Adjusting and Hiding Columns and Rows. Copying and Pasting Data. Sorting and Filtering Data. Changing Data Types and Field Properties. Changing the Sequence of Fields. Editing Data and Field Names.
Inserting Fields. Deleting Fields and Records. Importing Data. Linking Data. Printing Tables. Getting Started. Single Field Primary Key Tables. Multiple Field Primary Key Tables.
Creating a New Query. Adding Fields and Adjusting Columns. Query Name and Properties. Formatting and Sorting Data. Editing Queries. Exploring Queries to Excel. Grouping Data. Mathematical Summaries Aggregate Functions. Nested Queries. Advanced Queries. Crosstab Queries. Custom Fields. Calculated Fields. The Expression Builder. Basic IIF Function. Nested IIF Function. Future Value. Payment Function. Help with Functions.
Creating a New Report. Setting the Dimensions of a Report. Report Header. Page Footer. Report Footer. Sorting Data. Conditional Formatting. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
The smart way to learn Microsoft Office—one step at a time! The second edition of this popular book features new and expanded content. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to learn the fundamentals of working with the Microsoft Office system, including how to navigate the new user interface.
Learn how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. And discover how to get your Web site up and running, take notes electronically, and manage your e-mail communications and workday. The companion CD includes skill-building practice files, eBooks, and more.
Either way, you drive the instruction—building and practicing the skills you need, just when you need them! If you find an error, you can report it to us through our Submit errata page.
Sign in. Your cart. This eBook includes the following formats, accessible from your Account page after purchase: EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
0コメント