Excel University

Microsoft Excel Training for Cpas and Accounting Professionals

Author: Jeff Lenning,Jeff Lenning Cpa

Publisher: Createspace Independent Publishing Platform

ISBN: 9781534620100

Category:

Page: 206

View: 9658

DOWNLOAD NOW »
During live CPE training sessions, and through Excel articles featured in magazines such as the Journal of Accountancy and California CPA Magazine, Jeff Lenning, founder of Excel University, Inc., has shown thousands of CPAs and accounting professionals across the country how to use Excel more effectively. Drawing on his experience as an auditor, a financial analyst in industry, an accounting manager at a public company, and a consultant, he has demonstrated how to leverage Excel in order to improve efficiency by reducing the time it takes to complete job tasks. Written to reach those he won't have the opportunity to meet in one of his CPE sessions, Lenning's series, Excel University: Microsoft Excel Training for CPAs and Accounting Professionals, offers a comprehensive collection of the features, functions, and techniques that are of direct benefit to accountants working in industry, public practice, consulting, or not-for-profit. Concentrating on Excel for Windows, his books offer a hands-on approach to learning and include narrative, screenshots, video content, Excel practice files, and exercises that demonstrate the practical application of the items presented in each chapter. Visit http: //www.excel-university.com to access the Excel University video library and to download the practice files. Features, functions and techniques are presented in a sequential and progressive manner, so the books are best read in order. In Volume 1, the author presents material and information that will prove useful to every accountant, regardless of the type of work they do. Blown away by the power of Excel, readers are sure to find this series relevant, enlightening, and extremely easy-to-follow.

Excel University Volume 4 - Featuring Excel 2016 for Windows

Microsoft Excel Training for CPAs and Accounting Professionals

Author: Jeff Lenning,Jeff Lenning Cpa

Publisher: Createspace Independent Publishing Platform

ISBN: 9781539933083

Category:

Page: 338

View: 1581

DOWNLOAD NOW »
The fourth installment in the Excel University series covers the Excel features, functions, and techniques that will help you build reliable workpapers. The first part of this volume explores a variety of useful features, including outlines and protection. We discover that formatting choices impact productivity and learn how to use accounting underlines and custom number formats. We also use hyperlinks to help organize our digital files. The second part examines numerous functions that help make our workbooks efficient to maintain and update each period. Our examination includes lookup functions, text functions, date functions, and alternatives to the IF function. The third part discusses several techniques that combine multiple features and functions. We revisit topics presented in prior volumes in more depth, including conditional formatting, names, wildcards, and tables. The fourth part applies what we know to common accounting and finance tasks. We streamline our journal entries, budgets, and a variety of other common workpapers. The items covered in this volume will help improve your productivity so you can get your work done faster!

Advanced Excel Reporting for Management Accountants

Author: Neale Blackwood

Publisher: John Wiley & Sons

ISBN: 1118658183

Category: Business & Economics

Page: 448

View: 6922

DOWNLOAD NOW »
The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants. Explore the structures that simplify the report creation process and make the reports more maintainable Learn techniques to "cleanse" data so that it is ready for use in Pivot Tables and formula-based reports Find out the tips and tricks that can make the creation process quicker and easier Discover all you need to know about Excel's summing functions and how versatile they can be Written in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process.

Excel for Accountants

Author: Conrad Carlberg

Publisher: CPA911 Publishing

ISBN: 9781932925012

Category: Business & Economics

Page: 274

View: 4627

DOWNLOAD NOW »
Accounting professionals learn how to get the information they need fast with this guide to Excel features that manipulate and sort financial data. Comprehensive but concise chapters explain how to automate the entry of common business formulas; how to use pivot tables to extract details; how to develop inventory, depreciation, and financial summaries; and how to set up other standard financial calculations.

Pivot Table Data Crunching

Microsoft Excel 2010

Author: Bill Jelen,Michael Alexander

Publisher: Pearson Education

ISBN: 0789746689

Category: Computers

Page: 384

View: 4875

DOWNLOAD NOW »
PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen

Excel 2013: The Missing Manual

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449359515

Category: Computers

Page: 1020

View: 2944

DOWNLOAD NOW »
The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You’ll be using new features like PowerPivot and Flash Fill in no time. The important stuff you need to know: Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results. Illustrate trends. Discover the clearest way to present your data using Excel’s new Quick Analysis feature. Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives. Import data. Pull data from a variety of sources, including website data feeds and corporate databases. Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App. Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn. Master the new data model. Use PowerPivot to work with millions of rows of data. Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.

VBA and Macros

Microsoft Excel 2010

Author: Bill Jelen,Tracy Syrstad

Publisher: Pearson Education

ISBN: 0789743140

Category: Computers

Page: 630

View: 3638

DOWNLOAD NOW »
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. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010's most powerful new features Learning advanced Excel scripting has never been easier You'll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

Accounting Using Excel for Success

Author: James Reeve,Carl Warren,Jonathan Duchac

Publisher: Cengage Learning

ISBN: 1111535213

Category: Business & Economics

Page: 1368

View: 3922

DOWNLOAD NOW »
ACCOUNTING USING EXCEL FOR SUCCESS, 2E leads students to accounting mastery while increasing Excel proficiency. Written with the modern business world in mind, this adaptation of the principles text--ACCOUNTING, 24E--offers an innovative four-step system for students: (1) read the accounting concept and illustration, (2) follow the same concept using the Excel Success Example, (3) practice using the Try It Tutorial, and (4) apply knowledge by completing the Excel Success Problem. This text reinforces key accounting concepts through six basic Excel formulas. Students build an Excel portfolio to demonstrate basic competencies in accounting and Excel. Each new copy of the book comes packaged with an access code that allows students to use the online Excel Try It Tutorials. These tutorials guide students through the hands-on process of entering formulas and understanding how to Excel for accounting. Excel Success Special Activities at the end of the chapter require students to manipulate spreadsheets and save the files to demonstrate Excel competency. Within the auto-graded online homework products (CengageNOWTM and ApliaTM), students are asked to document their Excel processes. For a complete demo of the Excel Success system, visit www.cengage.com/community/warren. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

101 Ready-to-Use Excel Formulas

Author: Michael Alexander,Richard Kusleika

Publisher: John Wiley & Sons

ISBN: 1118902599

Category: Computers

Page: 240

View: 6226

DOWNLOAD NOW »
Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas 101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work. Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented. Teaches you how to implement the required Excel formula Explains and details how the formulas work Lets you reuse or customize the given formula to address your particular needs Helps you make the formulas a regular part of your new, more efficient workflow Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas.

Administering Active Directory

Author: Mark Wilkins

Publisher: McGraw Hill Professional

ISBN: 0072228733

Category: Computers

Page: 507

View: 9052

DOWNLOAD NOW »
A must-have for busy administrators this comprehensive guide is organized in a task-at-a-glance fashion, making it easy to find the topic you need.

A Handbook for Teaching and Learning in Higher Education

Enhancing academic practice

Author: Heather Fry,Steve Ketteridge,Stephanie Marshall

Publisher: Routledge

ISBN: 1317650220

Category: Education

Page: 452

View: 2498

DOWNLOAD NOW »
This entirely new edition of a very successful book focuses on developing professional academic skills for supporting and supervising student learning and effective teaching. It is built on the premise that the roles of those who teach in higher education are complex and multi-faceted. A Handbook for Teaching and Learning in Higher Education is sensitive to the competing demands of teaching, research, scholarship, and academic management. The new edition reflects and responds to the rapidly changing context of higher education and to current understanding of how to best support student learning. Drawing together a large number of expert authors, it continues to feature extensive use of case studies that show how successful teachers have implemented these ideas. It includes key topics such as student engagement and motivation, internationalisation, employability, inclusive strategies for teaching, effective use of technology and issues relating to postgraduate students and student retention. Part 1 explores a number of aspects of the context of UK higher education that affect the education of students, looking at the drivers of institutional behaviours and how to achieve success as a university teacher. Part 2 examines learning, teaching and supervising in higher education and includes chapters on working with diversity, encouraging independent learning and learning gain. Part 3 considers approaches to teaching and learning in different disciplines, covering a full range including arts and humanities, social sciences, experimental sciences through to medicine and dentistry. Written to support the excellence in teaching and learning design required to bring about student learning of the highest quality, this will be essential reading for all new lecturers, particularly anyone taking an accredited course in teaching and learning in higher education, as well as those experienced lecturers who wish to improve their teaching practice. Those working in adult learning and educational development will also find the book to be a particularly useful resource. In addition it will appeal to staff who support learning and teaching in various other roles.

Excel 2013 For Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 1118559703

Category: Computers

Page: 64

View: 598

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

Microsoft Excel for Accounting

The First Course

Author: Katherine T. Smith,L. Murphy Smith,Lawrence C. Smith

Publisher: Pearson College Division

ISBN: N.A

Category: Business & Economics

Page: 100

View: 9703

DOWNLOAD NOW »
Microsoft Excel is the most widely used spreadsheet software available. By practicing with sample assignments using Excel, readers will work more efficiently while enhancing their understanding of accounting. Introduces the fundamental tools and techniques available in Excel today. Offers real-world applications throughout. Features example worksheets in each chapter. Provides detailed instructions for using Microsoft Excel; covers the most current version, but is applicable for most other versions as well. Includes a Website keyed to the book that offers additional information and related links. Accountants and business managers will find this a useful Excel handbook.

Exploring Microsoft Office 2016

Author: Mary Anne Poatsy,Keith Mulbery,Cynthia Krebs,Lynn Hogan,Eric Cameron,Jason Davidson,Linda Lau,Rebecca Lawson,Jerri Williams,Robert T. Grauer

Publisher: Pearson

ISBN: 0134511816

Category: Computers

Page: 1000

View: 3267

DOWNLOAD NOW »
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. This book covers introductory Microsoft Word, Excel, Access, and PowerPoint, with an additional Windows 10 chapter. Beyond point-and-click The goal of the Exploring series is to move students beyond the point-and-click, to understanding the why and how behind each skill. And because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, anytime. Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know. Also available with MyITLab MyITLab ® is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, which engages students and improves results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, helping students learn more quickly and effectively. Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. MyITLab builds the critical skills needed for college and career success. Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

Microsoft Excel for Accounting

Auditing and Accounting Information Systems

Author: Katherine T. Smith,L. Murphy Smith,Lawrence C. Smith

Publisher: N.A

ISBN: 9780130085528

Category: Business & Economics

Page: 122

View: 2048

DOWNLOAD NOW »
This comprehensive introduction provides readers with a review of the fundamental tools and techniques available in Microsoft Excel spreadsheet software. The volume features Excel assignments that are designed to enable users to work more efficiently while enhancing their understanding of auditing and AIS concepts and increasing their computer fluency as they learn through experience by following directions and creating the example worksheets. The book provides detailed instruction for using Microsoft Excel and the applications presented pertain to specific topics covered in auditing and AIS. The authors examine computer basics, making a worksheet, formulas, functions, and formatting, charts, worksheet manipulation, database tools, macro commands, guidelines for worksheet design and provide a step-by-step Excel example. For accountants and business managers.

Building Accounting Systems Using Access 2010

Author: James Perry,Richard Newmark

Publisher: Cengage Learning

ISBN: 1111530998

Category: Business & Economics

Page: 672

View: 4024

DOWNLOAD NOW »
BUILDING ACCOUNTING SYSTEMS USING ACCESS 2010 provides a concrete foundation for database theory and shows students how to construct effective accounting systems. Concepts and theories come alive through detailed Access 2010 screenshots and illustrations. Online tutorials provide instant feedback and help student's master concepts in a step-by-step manner. This textbook also offers detailed coverage of REA modeling, exploring the resources, events, and agents. Using Microsoft Access, your students will develop the knowledge and skills to design accounting systems that deliver timely, accurate, and complete information to decision makers. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Power Pivot and Power BI

The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

Author: Rob Collie,Avichal Singh

Publisher: Tickling Keys, Inc.

ISBN: 1615473491

Category: Computers

Page: 271

View: 3858

DOWNLOAD NOW »
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not; and how to create time-intelligent calculations in pivot tables such as "Year over Year" and "Moving Averages" whether they use a standard, fiscal, or a complete custom calendar. The "pattern-like" techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide. This updated second edition covers new features introduced with Office 2015.

Excel 2016 Bible

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 1119067510

Category: Computers

Page: 1152

View: 7977

DOWNLOAD NOW »
The complete guide to Excel 2016, from Mr. Spreadsheet himselfstrong style="box-sizing: border-box; color: #1b1c1d; font-family: 'Open Sans', sans-serif; font-size: 16px;" Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2016's new features and tools Customize downloadable templates and worksheets Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.