Showing posts with label MS Excel. Show all posts
Showing posts with label MS Excel. Show all posts

Sunday, 15 July 2012

Excel 2010 Simplified

Paul McFedries - Excel 2010 Simplified
Publisher: Visuаl | 2010-04-26 | ISBN: 0470577630 | PDF | 256 pages | 19.94 MB
 Get going with Excel 2010 quickly and easily with this Simplified guide
Excel can be a complex program, and Excel 2010 includes new features and functionalities that require users of older versions to re-learn the application. Whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide provides information you can use right away. With an easy-to-read design, numbered steps illustrated with full-color screen shots, concise information, and helpful tips, Excel 2010 Simplified makes learning faster and easier than ever before. Excel is the world's leading spreadsheet and data analysis tool; Excel 2010 includes numerous new features, a redesigned interface, a new focus on collaboration and application servers, and much more Its complexity makes Excel a perfect subject for the step-by-step visual instruction in this guide. Numbered steps illustrated with full-color screen shots teach dozens of Excel 2010 tasks.

Covers Excel basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data, communicating results with charts and PivotTables, and much more.A quick and easy way to get up to speed on Excel 2010 for both novice users and those upgrading from an earlier version
Excel 2010 Simplified tames this complicated application and gives you the skills to start using Excel with confidence.


Friday, 17 February 2012

Excel VBA and Macros with MrExcel

Livelessons - Excel VBA and Macros - Bill Jelen
English | h264 yuv420p 1024x768 20.00 fps | aac 22050 Hz mono | 1.63 GB
Genre: Video Training

In Excel VBA and Macros with MrExcel, renowned Excel instructor and author Bill Jelen (MrExcel) teaches all the skills youпїЅll need to automate virtually any routine task with Excel and build powerful Excel macros! This package brings together nearly eight hours hours of personalized, expert video training: 50 quick, practical video lessons that demonstrate all the skills youпїЅll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development environment. LiveLessons are video courses on DVD with a book supplement, that are organized into bite-sized, self-contained sessions пїЅ youпїЅll learn key skills in as little as fifteen minutes. YouпїЅll learn one step at a time, at your own pace пїЅ using hands-on examples that reflect realistic challenges and showcase ExcelпїЅs remarkable capabilities. Along the way, Jelen will take you from the absolute basics through PivotTables and data filtering.
Delivers the power of the best classroom training!

Excel VBA and Macros with MrExcel delivers the power of the best classroom training at a small fraction of the cost. If you donпїЅt have time to read a huge book on Excel macros and scripting, this is exactly what youпїЅve been searching for! Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. Follow along as your trainer shows you how to make the most of ExcelпїЅs macro recorder and its powerful VBA development environment!

Download link:

Extabit:

Uploaded.to:

LetItBit:


Monday, 13 February 2012

Numerical Analysis Using MATLAB and Excel, 3rd Edition

Steven T. Karris, "Numerical Analysis Using MATLAB and Excel, 3rd Edition" 
Or,..rd P-tions | 2007 | ISBN: 1934404039 | 627 pages | PDF | 4,4 MB


This text includes the following chapters and appendices: Introduction to MATLAB, Root approximations, Sinusoids and complex numbers, Matrices and determinants, Review of differential equations, Fourier, Taylor, and Maclaurin series, Finite differences and interpolation, Linear and parabolic regression, Solution of differential equations by numerical methods, Integration by numerical methods, Difference equations, Partial fraction expansion, The Gamma and Beta Functions and distributions, Orthogonal functions and matrix factorizations, Bessel, Legendre, and Chebyshev polynomials, Optimization methods, Difference Equations in Discrete-Time systems, Introduction to Simulink, Ill-Conditioned Matrices. Each chapter contains numerous practical applications supplemented with detailed instructions for using MATLAB and/or Excel to obtain quick solutions.



Monday, 23 January 2012

VBA and Macros: Microsoft Excel 2010 + Exercise Files

VBA and Macros: Microsoft Excel 2010 + Exercise Files
Publisher: Que 2010 | 656 Pages | ISBN: 0789743140 | PDF | 38 MB

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it.


Data Analysis with Microsoft Excel: Updated for Office 2007

Data Analysis with Microsoft Excel: Updated for Office 2007
Duxbury | 2009 | ISBN: 0495391786 | 596 pages | PDF | 10,5 MB

This popular best-selling book shows students and professionals how to do data analysis with Microsoft Excel. DATA ANALYSIS WITH MICROSOFT EXCEL teaches the fundamental concepts of statistics and how to use Microsoft Excel to solve the kind of data-intensive problems that arise in business and elsewhere. 


Simply Excel 2010

Simply Excel 2010
John Wiley & Sons | 2010-07-16 | ISBN: 0470711310 | 224 pages | PDF | 18 MB

If you are serious about getting up to speed with Excel 2010, this clear, concise guide is the ideal companion for fast and efficient learning. The author illustrates the main functions of Excel 2010, explaining everything you need to know in plain, jargon-free English with full-colour screen shots and numbered, step-by-step instructions.


Saturday, 14 January 2012

Professional Excel Development


“As Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. Professional Excel Development is a book for developers who want to build powerful, state-of-the-art Excel applications using the latest Microsoft technologies.” 

–Gabhan Berry, Program Manager, Excel Programmability, Microsoft 

  

“The first edition of Professional Excel Development is my most-consulted and most-recommended book on Office development. The second edition expands both the depth and range. It shines because it takes every issue one step further than you expect. The book relies on the authors’ current, real-world experience to cover not only how a feature works, but also the practical implications of using it in professional work.” 

–Shauna Kelly, Director, Thendara Green 

  

“This book illustrates techniques that will result in well-designed, robust, and maintainable Excel-based applications. The authors’ advice comes from decades of solid experience of designing and building applications. The practicality of the methods is well illustrated by the example timesheet application that is developed step-by-step through the book. Every serious Excel developer should read this and learn from it. I did.” 

–Bill Manville, Application Developer, Bill Manville Associates 

  

The Start-to-Finish Guide to Building State-of-the-Art Solutions with Excel 2007 

  

In this book, four world-class Microsoft® Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors—three of whom have been honored by Microsoft as Excel Most Valuable Professionals (MVPs)—show how to consistently make the right design decisions and make the most of Excel’s most powerful new features. Using their techniques,you can reduce development costs, time to market, and hassle—and build more effective, successful solutions.  

  

Fully updated for Excel 2007, this book starts where other books on Excel programming leave off. Through a hands-on case study project, you’ll discover best practices for planning, architecting, and building Excel applications that are robust, secure, easy to maintain, and highly usable. If you’re a working developer, no other book on Excel programming offers you this much depth, insight, or value.  

  

•    Design worksheets that will be more useful and reliable 

•    Leverage built-in and application-specific add-ins 

•    Construct applications that behave like independent Windows programs 

•    Make the most of the new Ribbon user interface 

•    Create cross-version applications that work with legacy versions of Excel 

•    Utilize XML within Excel applications 

•    Understand and use Windows API calls 

•    Master VBA error handling, debugging, and performance optimization 

•    Develop applications based on data stored in Access, SQL Server, and other databases 

•    Build powerful visualization solutions with Excel charting engine  

•    Learn how to work with VB.NET and leverage its IDE 

•    Automate Microsoft Excel with VB.NET 

•    Create managed COM add-ins for Microsoft Excel with VB.NET 

•    Develop Excel solutions with Visual Studio Tools for Office (VSTO) 

•    Integrate Excel with Web Services 

•    Deploy applications more securely and efficiently



Saturday, 26 November 2011

Excel 2007: Data Analysis and Business Modeling


Excel 2007: Data Analysis and Business Modeling
Microsoft Press | ISBN: 0735623961 | edition 2007 | CHM | 624 pages | 39,7mb

Master the techniques that business analysts at leading companies use to transform data into bottom-line results.


For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Office Excel for data analysis, modeling, and decision making.


Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide–updated and expanded for Excel 2007.



Monday, 31 October 2011

Teach Yourself VISUALLY Excel 2010


Visual | 2010 | ISBN: 0470577649 | Pages: 352 | PDF | 88,77 MB

See your way to super spreadsheets with Excel 2010 and this visual guide!

If you're always hearing about the cool things that Excel can do, here's your chance to see how to do them! With pages of full-color, step-by-step instructions and crystal-clear screen shots, this guide shows you how to get the most out of Excel 2010. The book covers all the basics as well as Excel 2010's new features and functions, including a new interface and better collaboration tools. Crunch and chart your data over a network, over the Web, or at home-helpful tips on every page will get you there even faster!
Provides a clear look at Excel 2010, the newest version of the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
Demonstrates how to create spreadsheets and charts, filter and sort data, work with PivotTable, and present your data-on a network, on the Web, or on your laptop
Explores all features and functions in full-color pages packed with screen shots and other visual graphics that clearly show you how to accomplish tasks
Includes practical examples, tips, and advice on how to use all the tools more effectively

Get the very most out of Excel 2010 with this easy-to-follow guide!


Saturday, 29 October 2011

Easy Microsoft Excel 2010


Que | 2010 | ISBN-10: 078974287X | 216 Pages | PDF | 22 mb

This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master Excel 2010's new features - and, with Easy Microsoft Excel 2010, you'll find exactly what you're looking for. This full-color, utterly simple, step-by-step book has been carefully crafted to provide instant access to the 100+ tasks you'll find most useful and valuable. As with all books in the Easy series, it's designed to teach visually: you never have to work your way through lengthy text explanations.