Articles by "Microsoft"

Showing posts with label Microsoft. Show all posts

Chandan Kumar ... 434 pages - Language:‎ English - Publisher:‎ Independently; (December, 2023).

Unlock the full potential of Microsoft Excel with this comprehensive guide! Perfect for beginners and advanced users, this book takes you on a step-by-step journey through every aspect of Excel.

Key Features: Foundational Concepts: Understand the basics of Excel, key features, and practical uses. + Efficient Data Management: Master operators, data entry techniques, and effective data manipulation. + Data Formatting Mastery: Learn to format text, apply conditional formatting, and create visually appealing tables for impactful presentations. + Advanced Data Analysis Techniques: Dive into sorting, filtering, and analyzing data with powerful charts and illustrations. + Comprehensive Formulas and Functions: From basic calculations to advanced functions like VLOOKUP, HLOOKUP, XLOOKUP, and more. + Advanced Data Analysis: Harness the power of Pivot Tables for summary and reports, utilize the Slicer function for dynamic data filtering, and explore the Timeline feature for effective data visualization. + Workbook Security and Sheet Management: Secure your data with password protection, and efficiently manage sheets by renaming, deleting, hiding, and protecting them. + Useful Excel Shortcuts: Discover time-saving shortcuts to enhance your productivity and efficiency.

Unleash the power of Excel as you explore 100 chapters covering every essential formula and function. From basic principles to advanced techniques, this resource is designed to transform you from an Excel novice to a pro.

T.J. Quirk ... 264 Pages - Language: ‎English - Publisher: ‎Springer; 2nd edition (March, 2021).


This textbook is a step-by-step guide for high school, community college, and undergraduate students who are taking a course in applied statistics and wish to learn how to use Excel to solve statistical problems. All of the statistics problems in this book come from the following fields of study: business, education, psychology, marketing, engineering and advertising. Students will learn how to perform key statistical tests in Excel without being overwhelmed by statistical theory.Each chapter briefly explains a topic and then demonstrates how to use Excel commands and formulas to solve specific statistics problems. The book offers guidance in using Excel in two different ways: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel’s drop-down formula menus (e.g., simple linear regression, multiple correlations and multiple regression, and one-way ANOVA). Three practice problems are provided at the end of each chapter, along with their solutions in an appendix. An additional practice test allows readers to test their understanding of each chapter by attempting to solve a specific statistics problem using Excel; the solution to each of these problems is also given in an appendix. This book is a tool that can be used either by itself or along with any good statistics book.​

Ahmed Sheikh ... 92 pages - Language: English - Publisher: Independently published; (December, 2019) - ISBN-10: ‎1651129436 - ISBN-13: 978-1651129432.


Excel has its immense purposeful applications. 95% of the users apply the basic form. There are functions and advanced excel formula that can be used for complex calculations. The functions are designed for easy lookup and formatting of large pool of data whereas the advanced excel formula are implemented to get new information from a given particular set of data.

Allan Murray ... 368 pages - Publisher: ‎Apress; (December, 2020) - Language: English - ISBN-10 : 1484264665 - ISBN-13:‎ 978-1484264669.


Learn the Advanced Excel features and skills that are not taught in classes. Advanced Excel tricks, XLOOKUP, SUMPRODUCT, Power Query, Power Pivot and much more. This book is perfect for anyone who uses Excel regularly and wants to take the step to the next level. If you are a Beginner to Intermediate level Excel user, this book is a must-have. You will learn the advanced Excel features and techniques that others do not know.

In this book, you will learn: - Tricks and innovative ways to boost your productivity in Excel. - The best functions in Excel including XLOOKUP, FILTER, SORTBY, SWITCH and more with 'real world' examples. - Advanced formatting techniques to take your formatting to another level. - Create dynamic, interactive, and effective charts. - Power Query - possibly the greatest and most-important upgrade in the history of Excel. - Power Pivot - no more lookups. Learn to model your data, handle large volumes with ease and perform powerful DAX calculations. 

This book it a must-have to stay ahead of the crowd and be a success in the workplace. Take advantage of the power in modern Excel.

Linda Foulkes .... 794 pages - Publisher: Packt Publishing; (May, 2020) - Language: English - ISBN-10: 1839217251 - ISBN-13: 978-1839217258.


Learn Microsoft Office 2019 provides a comprehensive introduction to the latest versions of Microsoft Word, Excel, PowerPoint, Access, and Outlook. With the help of illustrated explanations, this Microsoft Office book will take you through the updated Office 2019 applications and guide you through implementing them using practical examples.

You'll start by exploring the Word 2019 interface and creating professional Word documents using elements such as citations and cover pages, tracking changes, and performing mail merge. You'll then learn how to create impressive PowerPoint presentations and advance to performing calculations and setting up workbooks in Excel 2019, along with discovering its data analysis features. Later chapters will focus on Access 2019, assisting you in everything from organizing a database to constructing advanced queries. You'll then get up to speed with Outlook, covering how to create and manage tasks, as well as how to handle your mail and contacts effortlessly. Finally, you'll find solutions to commonly encountered issues and best practices for streamlining various workplace tasks.

Flavio Morgado ... 787 pages - Publisher: Apress; (October, 2017) - Language: English.

Get hints, useful tricks, and solutions to those annoying problems that plague users of Microsoft’s ever-popular word processing software. This book goes beyond a how-to guide. You will understand where some of Word’s odd behavior comes from, how underlying inheritance rules can affect your formatting, and how to understand and make use of the many hidden characters that Word uses to control the text. By the end of the book, you’ll be able to fly through your Word processing without the usual headaches.

What You'll Learn: Understand why you should care about hidden characters, and how they can save you time and headaches + Use templates effectively, and produce your own templates + Employ fast desktop publishing techniques to produce a polished final document + Generate a table of contents and index
Fix those pesky tables forever!

Who This Book Is For: Everyone who uses Microsoft Word and has encountered difficulties and felt frustrated and slowed down.

Bryan Gambrel ... 528 pages - Publisher: Wiley; (October, 2013) ... Language: English - ISBN-10: 0470133074 - ISBN-13: 978-0470133071.

This Microsoft Word 2013, Exam 77-418 is the only Microsoft Official Academic Course (MOAC) textbook. This series includes a complete classroom instructional program. This Word 2013 text is mapped to the Word 2013 certification exam  objectives and is designed to re-enforce workforce skills. With this book students learn to create and edit professional-looking documents for a variety of purposes and situations. It also covers such skills as browsing, sorting and finding  information, accessing and sharing documents from anywhere, enhancing visual impact with picture editing tools, text effects, SmartArt Graphics, and much more. The Microsoft Official Academic Course (MOAC) Office series also  offers OfficeGrader. This valuable tool corrects your students tasked-based assignments. Students work on real-world problems like the ones they will encounter in the workforce ensuring they are ready for real professional challenges. OfficeGrader allows for efficient and  consistent grading saving time for other important teaching  activities. Grading is easier than ever allowing faster assignment turnaround to students. Word 2013 certification can help students with classwork and differentiate job hunters in todays competitive job market. Students who have earned certification can broaden their employment opportunities in such fields as clerical, office professionals, consultants, executives/managers, help desk personnel, instructors/trainers, marketing personnel, product developers, sales, and writers.

Bryan Gambrel ... 464 pages - Publisher: Wiley; (December, 2013) ... Language: English - ISBN-10: 0470133090 - ISBN-13: 978-0470133095. 

This Microsoft PowerPoint 2013, Exam 77-422 is the only Microsoft Official Academic Course (MOAC) textbook. This series includes a complete classroom instructional program. The PowerPoint 2013 text is mapped to the PowerPoint 2013 certification exam objectives and is designed to re-enforce workforce skills. With this book students learn to create complex slide shows such as product plans, reports, and marketing materials. Students will learn how to create slide shows based on custom templates generated by others and reuse slides. They will master the creation of slides that include sophisticated data presented in visual formats. They will know how to pause and move back and forth in slide shows, jump to specific slides, drill down to supporting data, mark up slides and much more. PowerPoint 2013 certification can help students with classwork and differentiate job hunters in today’s competitive job market. The Microsoft Official Academic Course (MOAC) Office series also offers OfficeGrader. This valuable tool corrects your students’ tasked-based assignments. Students work on real-world problems like the ones they will encounter in the workforce ensuring they are ready for real professional challenges. OfficeGrader allows for efficient and consistent grading saving time for other important teaching activities. Grading is easier than ever allowing faster assignment turnaround to students.

Walter Holland ... 672 pages - Publisher: Wiley; 1st edition (August, 2013) ... Language: English - ISBN-10: 1118568478 - ISBN-13: 978-1118568477

Featuring both a video training DVD and a full-color book, this training package is like having your own personal instructor guiding you through each lesson of learning Office 2013, all while you work at your own pace. The self-paced lessons allow you to discover the new features and capabilities of the new Office suite. Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This essential training package takes you well beyond the basics in a series of short, easy-to-absorb lessons. Takes you from the basics through intermediate level topics and helps you find the information you need in a clear, approachable manner + Walks you through numerous lessons, each consisting of easy-to-follow, step-by-step instructions in full color that make each task less intimidating + Covers exciting new features of Office 2013 applications: Word, Excel, PowerPoint, Outlook, and Publisher + Features a companion DVD that includes lesson files and video tutorials for a complete training experience.

John Walkenbach ... 312 pages - Publisher: Wiley; 1st edition (July, 2013) ... Language: English - ISBN-10: 111864218X - ISBN-13: 978-1118642184
    Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks. Reveals ways to maximize the power of Excel to create robust applications +  Draws on John Walkenbach's years of experience using Excel and writing more than 50 books + Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation  + Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables. 101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!

    June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey, Carol A. DesJardins ... 968 pages - Publisher: Cengage Learning; (October, 2013) ... Language: English - ISBN-10: 1285169336 - ISBN-13: 978-1285169330 ...

    With proven pedagogy that emphasizes critical-thinking, problem-solving, and in-depth coverage, New Perspectives helps students develop the Microsoft Office 2013 skills they need to be successful in college and beyond. Updated with all new case-based tutorials, New Perspectives Microsoft Excel 2013 continues to engage students in applying skills to real-world situations, making concepts relevant. A new Troubleshoot case problem enhances critical thinking, and a new tutorial on Managing Your Files helps students navigate Windows 8. As always, New Perspectives improves learning outcomes and transference of skills by helping students understand why what they're learning is important.

    E. Joseph Billo ... 480 pages - Publisher: Wiley-Interscience; 1st edition (April, 2007) ... Language: English - ISBN-10: 0471387347 - ISBN-13: 978-0471387343 ... 

    Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's(r) capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices * Find roots of equations and solve systems of simultaneous equations * Solve ordinary differential equations and partial differential equations * Perform linear and non-linear regression * Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix.

    Bernard Liengme ... 382 pages - Publisher: Academic Press; (March, 2015) ... Language: English - ISBN-10: 0128028173 - ISBN-13: 978-0128028179 ...

    Completely updated guide for students, scientists and engineers who want to use Microsoft Excel 2013 to its full potential. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.  Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2013. Features of Excel 2013 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results.  New to this edition: The Backstage is introduced (a new Office 2013 feature); all the ‘external’ operations like Save, Print etc. are now in one place + The chapter on charting is totally revised and updated – Excel 2013 differs greatly from earlier versions +Includes many new end-of-chapter problems + Most chapters have been edited to improve readability.

    Welcome to my BIGGEST, most complete, Microsoft Excel course ever!: Excel is one of the most important skills in today’s job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.

    If you need to know Excel, you’re in the right place: This course [Size: 2.34GB] walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros. My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve. This course was created using Excel 2016, but it is good for versions 2013 and 2010 as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn’t cover Mac-specific keyboard shortcuts and interface. We’ll start at the very beginning, with opening and saving a worksheet in Excel: I’ll show you what all the tools do and walk you through each Excel skill that you need to know. I’ll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I’ll teach you amazing keyboard shortcuts to make your work faster and more productive. You’ll learn how to record macros so you can do a whole series of actions with the just click of a button. We’ll keep going until you’re a pro at Excel. When you finish this course, you’ll know more than most people who use Excel at their job every day.

    June Jamrich Parsons, Dan Oja, Patrick Carey, Carol DesJardins ... Publisher: Course Technology; 1st edition (July, 2016) ... Language: English - ISBN-10: 133725147X - ISBN-13: 978-1337251471 ...

    Develop the complete set of Microsoft Excel 2016 skills you need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in New Perspectives Microsoft Office 365 and Excel 2016. Updated with all-new case scenarios, this edition clearly applies the thorough skills you are learning to real-world situations, making the concepts even more relevant. New Productivity Apps provide a visual introduction to Microsoft OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help you learn to use each app. New Perspectives Microsoft Office 365 and Excel 2016 demonstrates the importance of all of the Microsoft Excel 2016 skills you're learning while strengthening your outcomes and helping you transfer your thorough understanding of Microsoft Excel to other applications and disciplines for further success.

    Joan Lambert ... 624 pages - Publisher: Microsoft Press; 1st edition (January, 2016) ... Language: English - ISBN-10: 0735697779 - ISBN-13: 978-0735697775 ...

    This is learning made easy. Get more done quickly with Word 2016. Jump in wherever you need answers--brisk lessons and colorful screenshots show you exactly what to do, step by step. Get easy-to-follow guidance from a certified Microsoft Office Specialist Master - Learn and practice new skills while working with sample content, or look up specific procedures - Create visually appealing documents for school, business, community, or personal purposes - Use built-in tools to capture and edit graphics - Present data in tables, diagrams, and charts - Track and compile reference materials - Manage document collaboration and review - Fix privacy, accessibility, and compatibility issues - Supercharge your efficiency by creating custom styles, themes, and templates...

    Steven J. Peterson ... 432 pages - Publisher: Pearson; 2nd edition (January, 2011) ... Language: English - ISBN-10: 0138007195 - ISBN-13: 978-0138007195 ...

    Construction Estimating with Excel, Second Edition, introduces readers to the fundamental principles of estimating. Using drawing sets, real-world exercises, and examples, the text offers students critical estimating experience. The book moves step-by-step through the estimating process, discussing the art of estimating, the quantity takeoff, how to put costs to the estimate, and how to finalize the bid. As students progress through the text they are shown how Microsoft Excel can be used to improve the estimating process. Because it introduces spreadsheets as a way of increasing estimating productivity and accuracy, the book can help both beginning and experienced estimators improve their skills.

    Michael Alexander, John Walkenbach ... 240 pages - Publisher: Wiley; 1st edition (August, 2014) ... Language: English - ISBN-10: 1118902688 - ISBN-13: 978-1118902684 ... 

    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.

    Gunthar Pangaribuan ... 387 pages - Publisher: Createspace Independent Publishing Platform; (July, 2016) ... Language: English - ISBN-10: 1535196521 - ISBN-13: 978-1535196529 ...

    It's a Excel basics book that every civil engineer should have read by w. It addresses skills that may t be covered in most Excel for civil engineering texts, such as step by step guides to create an application program and how to convert the steps into VBA code, how to perform matrix operations (multiplication and inversion) using Excel-VBA, macro for creating an engineering chart, a brief and simple guide to become an instant Excel-VBA programmer, and more... Also to be presented the depiction in AutoCAD program. Yes! AutoCAD is chosen because one of its advantages that relies on high drawing accuracy. You will learn how to create a simple AutoCAD script file using Excel formulas and Excel-VBA. It is expected that you will be able to create simple Cartesian graph in AutoCAD, even you are an AutoCAD first time user! This book contains the author's collection of custom functions and also a series of engineering calculation programming that are very useful to adopt. With the ease of working with Excel, coupled with benefit of the given examples in this book, it is expected to increase the interest of the reader to create new original application programs. Thus, each model or even a specific calculation will be an exciting challenge for a programming job is already enjoyable. Happy Excel programming!

    Faithe Wempen ... 840 pages - Publisher: Wiley; 4th edition (April, 2013) ...
    Language: English - ISBN-10: 1118488113 -ISBN-13: 978-1118488119 ...

    Master PowerPoint and improve your presentation skills with one book!: In today's business climate, you need to know PowerPoint inside and out, and that's not all. You also need to be able to make a presentation that makes an impact. From using sophisticated transitions and animation in your PowerPoint presentations to interfacing in person with your audience, this information-packed book helps you succeed. Start creating professional-quality slides that captivate audiences and discover essential tips and techniques for making first-rate presentations, whether you're at a podium or online.

    Combines both the technical software skills and the soft presentation skills needed to be a successful presenter in today's business climate - Explains PowerPoint 2013's features and tools in detail, so you can create impressive,professional presentations for your job - Shows you essential formatting techniques, including tables and working with Layouts, Themes, and Masters - Covers working with drawings and SmartArt, photos, charts, sounds, music, video, and data from other sources - Explains how to prepare for live presentations and also how to create and present material in the Cloud or online, including e-learning. For compelling, successful presentations in person, in the cloud, or on the web, start with PowerPoint 2013 Bible.

    Contact Form

    Name

    Email *

    Message *

    Powered by Blogger.