Search Results for "learn-excel-2011-for-mac"

Learn Excel 2011 for Mac

Learn Excel 2011 for Mac

  • Author: Guy Hart-Davis
  • Publisher: Apress
  • ISBN: 1430235217
  • Category: Computers
  • Page: 488
  • View: 6551
DOWNLOAD NOW »
Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks. What you’ll learn The secrets of the Excel for Mac interface! How to create effective workbooks and templates How to quickly format worksheets How to perform custom calculations and formulas What kind of creative and persuasive charts How to illustrate your worksheets with SmartArt, pictures, and more What business problem solving can be done with Excel How to analyze data with pivot tables How to automate tasks with Visual Basic for Applications (VBA) Who this book is for Beginning and intermediate users looking to get up to speed quickly with the Excel 2011 application and use it productively, both online and offline. Table of Contents Learning the Secrets of the Excel:Mac Interface Configuring Excel:Mac to Suit the Way You Work Creating Effective Workbooks and Templates Formatting Your Worksheets Quickly and Efficiently Performing Custom Calculations with Formulas Using Excel’s Built-In Functions Creating Clear and Persuasive Charts Using Data Bars, Color Scales, Icon Sets, and Sparklines Illustrating Your Worksheets with SmartArt, Pictures, and More Creating Databases Using Tables Solving Business Questions with What-If Analysis, Goal Seek, and Solver Analyzing Data with PivotTables Collaborating and Sharing with Macs and Windows Automating Tasks with Macros and VBA

Learn Excel 2011 for Mac

Learn Excel 2011 for Mac

  • Author: Guy Hart-Davis
  • Publisher: Apress
  • ISBN: 1430235225
  • Category: Computers
  • Page: 488
  • View: 6163
DOWNLOAD NOW »
Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks.

Excel 2010 For Dummies

Excel 2010 For Dummies

  • Author: Greg Harvey
  • Publisher: John Wiley & Sons
  • ISBN: 1118430018
  • Category: Computers
  • Page: 176
  • View: 2244
DOWNLOAD NOW »
Dig into formulas, functions, and more to build your Excel skills Whether you're a beginner or an Excel veteran, this friendly guide provides the fundamental techniques to help you create, edit, format, and print your own spreadsheets. You'll start from scratch and quickly progress to manipulating data with formulas and using Excel's extensive formatting options to present your information in the most powerful way. Open the book and find: Ways to navigate Excel's Ribbon interface Data entry tips to start your spreadsheet How to build formulas and edit workbooks Formatting steps to follow Printing basics to present your data

Microsoft Office 2011 for Mac

Microsoft Office 2011 for Mac

Visual QuickStart

  • Author: Steve Schwartz
  • Publisher: Pearson Education
  • ISBN: 0132735156
  • Category: Computers
  • Page: 544
  • View: 2571
DOWNLOAD NOW »
Visual QuickStart Guides, designed in an attractive tutorial and reference format, are the quickest, easiest, and most thorough way to learn applications, tasks, and technologies. The Visual QuickStart Guides are a smart choice and guide the learner in a friendly and respectful tone. Visually presented with copious screenshots, the focused discussions by topic and tasks make learning a breeze and quickly take you to exactly what you want to learn. Microsoft Office 2011 for Macintosh: Visual QuickStart Guide, written by best-selling author Steve Schwartz, has been extensively rewritten to provide expanded coverage of the core Office applications: Word, Excel, PowerPoint, and Outlook, provides in-depth instructions on many of the new features and changes introduced in Office 2011, and offers a thorough introduction to the Office Web Apps. Coverage of each application is jam-packed with information and tips that not only explain HOW to perform a task, but WHY you need this procedure and WHEN it's best to use it. Table of Contents PART I: GETTING STARTED Chapter 1: Introducing Office 2011 Chapter 2: Office Basics Chapter 3: Working with Graphics PART II: MICROSOFT WORD Chapter 4: Introducing Word 2011 Chapter 5: Document Formatting Chapter 6: Text Formatting Chapter 7: Creating Tables Chapter 8: Working in Other Views Chapter 9: Other Word Features PART III: MICROSOFT EXCEL Chapter 10: Spreadsheet Essentials Chapter 11: Modifying Worksheets Chapter 12: Formulas and Functions Chapter 13: Working with Tables Chapter 14: Charts and Graphs Chapter 15: Database Techniques Chapter 16: Sharing Workbooks PART IV: MICROSOFT POWERPOINT Chapter 17: Creating a Presentation Chapter 18: Charts and Tables Chapter 19: Wrapping up a Presentation PART V: MICROSOFT OUTLOOK Chapter 20: Introducing Outlook Chapter 21: Email Chapter 22: Contacts Chapter 23: Calendar Chapter 24: Tasks Chapter 25: Notes Chapter 26: My Day Part VI: ADVANCED TOPICS Chapter 27: Combining Office Data Chapter 28: Office 2011 and the Internet Chapter 29: The Office Web Apps Index

Office 2011 for Mac All-in-One For Dummies

Office 2011 for Mac All-in-One For Dummies

  • Author: Geetesh Bajaj,James Gordon
  • Publisher: John Wiley & Sons
  • ISBN: 9781118028452
  • Category: Computers
  • Page: 840
  • View: 3310
DOWNLOAD NOW »
Get up to speed on the revolutionary changes in Office for the Mac The 2011 version of the Microsoft Office productivity suite for the Mac sports major changes from what Mac users are accustomed to. This soup-to-nuts guide gets the Mac crowd up to date quickly and easily. Individual minibooks thoroughly cover the Project Gallery, Word, Excel, PowerPoint, Outlook (new for Mac), and the Project Center. You’ll learn how the new Office integrates with the Windows version, how to use and customize the new Ribbon interface, and much more. Office for Mac is the most popular office productivity suite for the Mac, used by 1.5 to 2 million people The new version includes new features such as the Ribbon interface, Outlook (which replaces Entourage), and greater integration with the Windows version Covers everything you’ll want to know about the Project Gallery, Word, Excel, PowerPoint, Outlook, and the Project Center With Office 2011 for Mac All-in-One For Dummies, you’ll be ready to use the newest version of Office like a pro.

Office 2011 for Mac For Dummies

Office 2011 for Mac For Dummies

  • Author: Bob LeVitus
  • Publisher: John Wiley & Sons
  • ISBN: 1118048628
  • Category: Computers
  • Page: 436
  • View: 3613
DOWNLOAD NOW »

Office 2011 for Macintosh: The Missing Manual

Office 2011 for Macintosh: The Missing Manual

  • Author: Chris Grover
  • Publisher: "O'Reilly Media, Inc."
  • ISBN: 9781449302719
  • Category: Computers
  • Page: 816
  • View: 340
DOWNLOAD NOW »
Office 2011 for Mac is easy to use, but to unleash its full power, you need to go beyond the basics. This entertaining guide not only gets you started with Word, Excel, PowerPoint, and the new Outlook for Mac, it also reveals useful lots of things you didn't know the software could do. Get crystal-clear explanations on the features you use most -- and plenty of power-user tips when you're ready for more. Take advantage of new tools. Navigate with the Ribbon, use SmartArt graphics, and work online with Office Web Apps. Create professional-looking documents. Use Word to craft beautiful reports, newsletters, brochures, and posters. Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and other features. Use the programs together. Discover how to be more productive and creative by drawing directly in Word documents, adding spreadsheets to your slides, and more.

Excel Basics In 30 Minutes (2nd Edition)

Excel Basics In 30 Minutes (2nd Edition)

The beginner’s guide to Microsoft Excel and Google Sheets

  • Author: Ian Lamont
  • Publisher: i30 Media Corporation
  • ISBN: 1939924642
  • Category: Computers
  • Page: 88
  • View: 9820
DOWNLOAD NOW »
Do you want to learn how to use Microsoft Excel, for a career boost or to better handle numbers, lists, and other data? The revised and expanded second edition of Excel Basics In 30 Minutes will quickly get you up to speed with basic spreadsheet concepts, tips, and tricks! Excel Basics In 30 Minutes, 2nd Edition is written in plain English, with lots of step-by-step instructions, screenshots, and examples that demonstrate exactly what to do. Instructions apply to recent versions of Excel, including Excel 2013, Excel for Office 365, and Excel Online. For users who don't own Excel, the guide explains how to use a free online spreadsheets program called Google Sheets.

Microsoft Word 2016 for Mac: Any Easy Beginner's Guide

Microsoft Word 2016 for Mac: Any Easy Beginner's Guide

  • Author: Philip Tranton
  • Publisher: Conceptual Kings
  • ISBN: N.A
  • Category:
  • Page: 40
  • View: 5836
DOWNLOAD NOW »
The latest version of Microsoft Word was released along with the updated versions of Outlook, PowerPoint and Excel. The four programs together make the Office 2016 suite, which was released to the public between July and September of 2015. The new Microsoft Word 2016 has been outfitted with a collaboration feature; created to enable up to ten users to work in and make adjustments to the same document, all at the same time. This collaboration is made possible with the use of the cobalt syncing technology. Users may view the names of the authors as well as the changes being made by each. Cobalt will prevent conflict where saving and modification of the data is concerned. Word 2016 proudly boasts enhanced reviewing, editing and sharing tools. It is also designed to include a new tab for timely and convenient access to editing tools such as colors, fonts and layout. The new task pane for formatting will allow users the opportunity to modify captured images, effects and shapes in the program.

Office for Mac 2011 Portable Genius

Office for Mac 2011 Portable Genius

  • Author: Dwight Spivey
  • Publisher: John Wiley & Sons
  • ISBN: 9781118005330
  • Category: Computers
  • Page: 352
  • View: 378
DOWNLOAD NOW »
A savvy guide to Office 2011 for Mac users Mac users, you don’t have to give up one ounce of cool to use Office 2011 on your Mac. Here’s the hip guide you need to get the most out of Word, Excel, PowerPoint, and Outlook. Get started with Office 2011, find out what features are shared between apps, and start creating stylish Word docs, lively PowerPoint presentations, awesome Excel reports, and totally organized Outlook lists and calendars. And you’ll love the portable size—just perfect for keeping this guide on hand while you work. Features facts, tips, and secrets to help you get the most of out of Office 2011 for Mac Provides the key tools and shortcuts you need to accomplish tasks, without bogging you down in too much detail Covers how to get started with Office, an overview of shared features, and how to use each application in the Office 2011 suite Helps you create smart Word docs, organize your calendar and contacts with Outlook, build compelling PowerPoint presentations, and use Excel formulas and functions to generate reports and analyze data Zero in on the Office 2011 features you use most on your Mac, with Office 2011 for Mac Portable Genius.

Next Generation Excel

Next Generation Excel

Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)

  • Author: Isaac Gottlieb
  • Publisher: John Wiley & Sons
  • ISBN: 1118469089
  • Category: Business & Economics
  • Page: 256
  • View: 906
DOWNLOAD NOW »
Take Excel to the next level in accounting and financial modeling In this new Second Edition of Next Generation Excel, Isaac Gottlieb shows financial analysts how to harness the full power of Excel to move forward into the new world of accounting and finance. Companies of all sizes use financial models to analyze their finances and plan business operations, as well as to create financial accounting reports like balance sheets, income statements, and statements of cash flows. While many businesspeople are quite familiar with the reports created with financial models, most are not as familiar with the creation of the models themselves. This book shows them how to build an accurate and effective financial model using the solid functionality and easy usability of Excel. Fully updated and revised to include support for Apple users Written by a professor of management and statistics who has taught the discipline for fifteen years Appropriate for professional financial analysts, as well as MBA students For professionals and students whose responsibilities or studies include a full understanding of financial modeling, Next Generation Excel, Second Edition offers comprehensive training.

MacBook For Dummies

MacBook For Dummies

  • Author: Mark L. Chambers
  • Publisher: John Wiley & Sons
  • ISBN: 1119417260
  • Category: Computers
  • Page: 432
  • View: 3466
DOWNLOAD NOW »
Get the most out of your MacBook Your new MacBook is sleek and powerful, and this down-to-earth guide makes it easier than ever to navigate, personalize, and maximize what it can help you accomplish. From taking it out of the box and turning it on for the first time to file storage and security, to downloading apps and working with iCloud, MacBook For Dummies helps you discover—all in one place—everything your laptop can do. Ultra-light, ultra-fast, and ultra-powerful, the MacBook is the coolest laptop around, and longtime Mac guru Mark L. Chambers is just the guy you want showing you the ropes. Inside, he shows you how to navigate the Mac desktop, customize your settings, surf the web and set up email, hook into a network, transfer your important documents from another PC or Mac, and troubleshoot with ease. You'll also get the inside scoop on the fun stuff like FaceTime video calling, Messages, Reminders, photos, videos, music, the Mac App Store, and more. Explore the new OS X Be productive with Keynote and Pages Get creative with Photos and iMovie Find tips for maintenance and security Whether you're a PC convert or a seasoned Apple enthusiast, this book helps you get the most of your magnificent MacBook!

Slaying Excel Dragons

Slaying Excel Dragons

A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun

  • Author: Mike Girvin
  • Publisher: Tickling Keys, Inc.
  • ISBN: 1615473025
  • Category: Computers
  • Page: 532
  • View: 8270
DOWNLOAD NOW »
This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that come with using the program for the first time. This manual offers strategies for avoiding problems and streamlining efficiency and assists readers from start to finish, turning Excel 2010 novices into experts.

Office for IPad and Mac For Dummies

Office for IPad and Mac For Dummies

  • Author: Peter Weverka
  • Publisher: John Wiley & Sons
  • ISBN: 1119010179
  • Category: Computers
  • Page: 384
  • View: 9023
DOWNLOAD NOW »
Get up and running with Office on your iPad or Mac! Weverka walks you through every facet, from installing the software to working with the programs. You'll get tips for making the most of your iPad, and learn how to make great PowerPoint presentations, or share content and collaborate online.

Learn Excel 2016 Essential Skills with the Smart Method

Learn Excel 2016 Essential Skills with the Smart Method

Courseware Tutorial for Self-Instruction to Beginner and Intermediate Level

  • Author: Mike Smart
  • Publisher: N.A
  • ISBN: 9781909253100
  • Category: Computers
  • Page: 160
  • View: 3557
DOWNLOAD NOW »
This book is suitable for both Excel beginners and seasoned experts. In this Excel 2016 book you'll learn how to use and apply advanced Excel skills to construct a robust Excel business application that would be well beyond the powers of most advanced Excel users. Even if you only have very basic Excel skills, the book is designed in such a way that you'll be able to construct a complex, polished professional Excel 2016 application. In constructing this project you'll discover new and interesting ways to use many of Excel 2016's more powerful and complex features. This book will teach you best-practice when applying your Excel skills to large real-world projects. This book won't only teach you Excel skills. You'll also learn a best-practice design and development methodology that will stand you in good stead when working on future Excel projects. What you will learn Most Excel tutorials and reference books teach how to use individual Excel features but don't show how you can combine them into a robust and complex Excel application. In this book you will combine 80 key Excel skills to produce a single advanced Excel application. Here are just a few of the skills you'll use: Create a custom color set. Use custom formats. Use Spin Button and Check Box form controls. Define named ranges and named cells. Use the Name Manager to view, delete and edit range names. Create a drop-down list using a list validation. Use and understand the practical use of over 20 Excel functions including VLOOKUP, COUNTIF, DAY, MONTH, DATE, IFERROR, CHAR, IF, IFERROR, LEN, MOD, ROW, TEXT and WEEKDAY. Understand date serial numbers. Understand precedence rules. Format date serial numbers using a custom format. Create a formula-driven conditional format. Use the conditional format Rules Manager. Calculate the correct date (in any year) for Martin Luther King Day, President's Day, Labor Day, Columbus Day, Thanksgiving Day, New Year's Day, Independence Day, Christmas Day and Veterans Day, Easter Sunday and Memorial Day. Use structured table references. Concatenate text. Calculate the phases of the moon using Synodic Months and the MOD function. Create user-friendly validation error messages. Use Smart Tags. Lock cells, hide columns, hide entire worksheets and protect worksheets to prevent users from making unwanted changes. Companies who have taken Smart Method courses include: AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, The British Museum, The National Gallery, Pokerstars, Marks & Spencer, Virgin, O2, BMW... and many, many others.

Excel 2013 For Dummies

Excel 2013 For Dummies

  • Author: Greg Harvey
  • Publisher: John Wiley & Sons
  • ISBN: 1118559703
  • Category: Computers
  • Page: 64
  • View: 7399
DOWNLOAD NOW »
Learn to create, edit, and print Excel worksheets Need to get going with Excel 2013 in a hurry? Here are the basic techniques you need to know to work with Excel spreadsheets on your desktop or Windows tablet. Nothing fancy — just what's necessary to open and navigate Excel 2013, enter and edit data, format cells, add a header and footer, and print your worksheet. It's easy! Open the book and find: Where to find things in the program window Tips for using Excel on a touchscreen device How to use AutoFill and Flash Fill Advice on entering formulas Steps for printing cool-looking reports

Excel Hacks

Excel Hacks

Tips & Tools for Streamlining Your Spreadsheets

  • Author: David Hawley,Raina Hawley
  • Publisher: "O'Reilly Media, Inc."
  • ISBN: 9780596555283
  • Category: Computers
  • Page: 412
  • View: 2898
DOWNLOAD NOW »
Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to: Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption. Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform. Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet. Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them. Create customized charts -- tweak and combine Excel's built-in charting capabilities. Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time. Make the most of macros -- including ways to manage them and use them to extend other features. Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook. You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Microsoft Office 2011 for Macintosh, Illustrated Fundamentals

Microsoft Office 2011 for Macintosh, Illustrated Fundamentals

  • Author: Kelley Shaffer
  • Publisher: Cengage Learning
  • ISBN: 1111824312
  • Category: Computers
  • Page: 416
  • View: 9695
DOWNLOAD NOW »
Designed to meet the needs of users across all experience levels, MICROSOFT OFFICE 2011 FOR MAC ILLUSTRATED FUNDAMENTALS equips your students with Microsoft Office 2011 skills, starting with the basics. As part of the Illustrated Series, this text is written in a user-friendly format, employing the Illustrated Series hallmark two-page spread design. The left page contains concise, step-by-step instruction; the right page presents large, full-color screenshots to illustrate exactly what readers should see on their screen. The visual approach is easy to follow and absorb, helping students transfer their skills to life outside of the classroom. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Using Excel for Business Analysis

Using Excel for Business Analysis

A Guide to Financial Modelling Fundamentals

  • Author: Danielle Stein Fairhurst
  • Publisher: John Wiley & Sons
  • ISBN: 1119062462
  • Category: Business & Economics
  • Page: 464
  • View: 3896
DOWNLOAD NOW »
While there are many hundreds of tools, features and functions in Excel, this book focusses only on the ones it is critical for the Finance Business user to know. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. It is invaluable for anyone using Excel for Finance, as it helps them to do their jobs faster, more efficiently and with fewer errors. The book is organized into twelve chapters, arranged in order based on different aspects of Excel modelling. This book includes: -step-by-step instructions for how to use each feature that are detailed in a practical example -live models for readers to build it on their own accompanying excel worksheets downloadable via the website

Excel for Windows

Excel for Windows

  • Author: SparkNotes
  • Publisher: Sparknotes
  • ISBN: 9781586638993
  • Category: Study Aids
  • Page: 6
  • View: 9930
DOWNLOAD NOW »
This SparkChart outlines and summarizes key points on use of the Microsoft Excel for Windows.