Title Page 3 Copyright Page 4 Table of Contents 7 Introduction 15 About This Book 15 How to Use This Book 16 What You Can Safely Ignore 16 Foolish Assumptions 16 How This Book Is Organized 17 Part I: Getting Started with Excel 2016 18 Part II: Editing without Tears 18 Part III: Getting Organized and Staying That Way 18 Part IV: Digging Data Analysis 18 Part V: Life beyond the Spreadsheet 19 Part VI: The Part of Tens 19 Conventions Used in This Book 19 Selecting Ribbon commands 19 Icons Used in This Book 21 Where to Go from Here 21 Part I Getting Started with Excel 2016 23 Chapter 1 The Excel 2016 User Experience 25 Excel’s Ribbon User Interface 26 Going Backstage 28 Using the Excel Ribbon 29 Customizing the Quick Access toolbar 34 Having fun with the Formula bar 38 What to do in the Worksheet area 39 Showing off the Status bar 46 Launching and Quitting Excel 48 Starting Excel from the Windows 10 Start menu 48 Starting Excel from the Windows 10 Ask Me Anything text box 48 Starting Excel from the Windows 8 Start screen 49 Starting Excel from the Windows 7 Start menu 49 Adding an Excel 2016 shortcut to your Windows 7 desktop 50 Pinning Excel 2016 to your Windows 7 Start menu 51 Pinning Excel 2016 to the Windows 7 taskbar 51 Exiting Excel 52 Help Is on the Way 53 Using the Tell Me help feature 53 Getting online help 54 Chapter 2 Creating a Spreadsheet from Scratch 55 So What Ya Gonna Put in That New Workbook of Yours? 56 The ins and outs of data entry 57 You must remember this . . . 58 Doing the Data‐Entry Thing 58 It Takes All Types 61 The telltale signs of text 61 How Excel evaluates its values 62 Fabricating those fabulous formulas! 69 If you want it, just point it out 72 Altering the natural order of operations 72 Formula flub‐ups 74 Fixing Those Data Entry Flub‐Ups 75 You really AutoCorrect that for me 76 Cell editing etiquette 77 Taking the Drudgery out of Data Entry 79 I’m just not complete without you 79 Fill ’er up with AutoFill 80 Fill it in a flash 87 Inserting special symbols 89 Entries all around the block 90 Data entry express 91 How to Make Your Formulas Function Even Better 91 Inserting a function into a formula with the Insert Function button 92 Editing a function with the Insert Function button 95 I’d be totally lost without AutoSum 96 Sums via Quick Analysis Totals 99 Making Sure That the Data Is Safe and Sound 100 Changing the default file location 102 The difference between the XLSX and XLS file formats 103 Saving the Workbook as a PDF File 104 Document Recovery to the Rescue 105 Part II Editing without Tears 107 Chapter 3 Making It All Look Pretty 109 Choosing a Select Group of Cells 110 Point‐and‐click cell selections 111 Keyboard cell selections 115 Using the Format as Table Gallery 118 Customizing table formats 120 Creating a new custom Table Style 121 Cell Formatting from the Home Tab 123 Formatting Cells Close to the Source with the Mini‐bar 126 Using the Format Cells Dialog Box 127 Understanding the number formats 128 The values behind the formatting 134 Make it a date! 135 Ogling some of the other number formats 135 Calibrating Columns 136 Rambling rows 137 Now you see it, now you don’t 138 Futzing with the Fonts 140 Altering the Alignment 141 Intent on indents 142 From top to bottom 143 Tampering with how the text wraps 143 Reorienting cell entries 145 Shrink to fit 146 Bring on the borders! 147 Applying fill colors, patterns, and gradient effects to cells 148 Doing It in Styles 149 Creating a new style for the gallery 150 Copying custom styles from one workbook into another 150 Fooling Around with the Format Painter 151 Conditional Formatting 152 Formatting with scales and markers 153 Highlighting cells ranges 155 Formatting via the Quick Analysis tool 155 Chapter 4 Going Through Changes 159 Opening Your Workbooks for Editing 160 Opening files in the Open screen 161 Operating the Open dialog box 162 Changing the Recent files settings 164 Opening multiple workbooks 164 Find workbook files 165 Using the Open file options 165 Much Ado about Undo 166 Undo is Redo the second time around 166 What to do when you can’t Undo? 167 Doing the Old Drag‐and‐Drop Thing 167 Copies, drag‐and‐drop style 169 Insertions courtesy of drag and drop 170 Copying Formulas with AutoFill 171 Relatively speaking 173 Some things are absolutes! 173 Cut and Paste, Digital Style 176 Paste it again, Sam . . . 177 Keeping pace with Paste Options 178 Paste it from the Clipboard task pane 180 So what’s so special about Paste Special? 181 Let’s Be Clear about Deleting Stuff 183 Sounding the all clear! 183 Get these cells outta here! 184 Staying in Step with Insert 185 Stamping Out Your Spelling Errors 186 Eliminating Errors with Text to Speech 188 Chapter 5 Printing the Masterpiece 191 Previewing Pages in Page Layout View 192 Using the Backstage Print Screen 193 Printing the Current Worksheet 196 My Page Was Set Up! 198 Using the buttons in the Page Setup group 198 Using the buttons in the Scale to Fit group 203 Using the Print buttons in the Sheet Options group 205 From Header to Footer 205 Adding an Auto Header and Footer 206 Creating a custom header or footer 208 Solving Page Break Problems 212 Letting Your Formulas All Hang Out 214 Part III Getting Organized and Staying That Way 217 Chapter 6 Maintaining the Worksheet 219 Zooming In and Out 220 Splitting the Worksheet into Windows 223 Fixed Headings with Freeze Panes 224 Electronic Sticky Notes 227 Adding a comment to a cell 228 Comments in review 229 Editing comments in a worksheet 230 Getting your comments in print 231 The Range Name Game 231 If I only had a name . . . 231 Name that formula! 233 Naming constants 234 Seek and Ye Shall Find . . . 235 Replacing Cell Entries 239 Doing Your Research with Smart Lookup 240 Controlling Recalculation 241 Putting on the Protection 242 Chapter 7 Maintaining Multiple Worksheets 247 Juggling Multiple Worksheets 248 Sliding between the sheets 249 Editing en masse 251 Don’t Short‐Sheet Me! 252 A worksheet by any other name . . . 253 A sheet tab by any other color . . . 254 Getting your sheets in order 254 Opening Windows on Your Worksheets 256 Comparing Worksheets Side by Side 261 Shifting Sheets to Other Workbooks 262 Summing Stuff on Different Worksheets 266 Part IV Digging Data Analysis 269 Chapter 8 Doing What‐If Analysis 271 Playing What‐If with Data Tables 271 Creating a one‐variable data table 272 Creating a two‐variable data table 275 Playing What‐If with Goal Seeking 278 Making the Case with Scenario Manager 280 Setting up the various scenarios 280 Producing a summary report 282 Chapter 9 Playing with Pivot Tables 285 Data Analysis with Pivot Tables 285 Pivot tables via the Quick Analysis tool 286 Pivot tables by recommendation 288 Manually producing pivot tables 289 Formatting Pivot Tables 292 Refining the Pivot Table style 293 Formatting values in the pivot table 293 Sorting and Filtering Pivot Table Data 294 Filtering the report 294 Filtering column and row fields 295 Filtering with slicers 296 Filtering with timelines 297 Sorting the pivot table 299 Modifying Pivot Tables 299 Modifying the pivot table fields 299 Pivoting the table’s fields 300 Modifying the table’s summary function 301 Creating Pivot Charts 302 Moving pivot charts to separate sheets 303 Filtering pivot charts 304 Formatting pivot charts 305 Part V Life beyond the Spreadsheet 307 Chapter 10 Charming Charts and Gorgeous Graphics 309 Making Professional-Looking Charts 309 Charts thanks to Recommendation 310 Charts from the Ribbon 311 Charts via the Quick Analysis tool 312 Charts on their own chart sheets 315 Moving and resizing embedded charts 315 Moving embedded charts to chart sheets 316 Customizing charts from the Design tab 317 Customizing chart elements 318 Editing the generic titles in a chart 320 Adding Great-Looking Graphics 323 Sparking up the data with sparklines 323 Telling all with a text box 326 Inserting online images 329 Inserting local images 331 Editing inserted pictures 331 Formatting inserted images 332 Adding preset graphic shapes 333 Working with WordArt 335 Make mine SmartArt 336 Screenshots anyone? 338 Theme for a day 339 Controlling How Graphic Objects Overlap 340 Reordering the layering of graphic objects 340 Grouping graphic objects 342 Hiding graphic objects 342 Printing Just the Charts 343 Chapter 11 Getting on the Data List 345 Creating Data Lists 345 Adding records to data lists 346 Moving through records in the data form 351 Finding records with the data form 352 Sorting Data Lists 354 Sorting on a single field 355 Sorting on multiple fields 356 Filtering Data Lists 358 Using ready-made number filters 360 Using ready-made date filters 361 Using custom filters 361 Importing External Data 364 Querying Access database tables 365 Performing web queries 367 Chapter 12 Linking, Automating, and Sharing Spreadsheets 369 Using Office Add-ins 369 Using Excel Add-Ins 372 Adding Hyperlinks to a Worksheet 373 Automating Commands with Macros 376 Recording new macros 376 Running macros 380 Assigning macros to the Ribbon and the Quick Access toolbar 381 Sharing Your Worksheets 383 Sharing workbooks saved on OneDrive 384 E-mailing workbooks 386 Sharing workbooks with IM 387 Presenting worksheets online 388 Editing worksheets online 389 Part VI The Part of Tens 393 Chapter 13 Top Ten Beginner Basics 395 Chapter 14 The Ten Commandments of Excel 2016 397 Chapter 15 Top Ten Ways to Manage Your Data 399 Chapter 16 Top Ten Ways to Analyze Your Data 405 Index 409 EULA 435

Please Read Notes: Brand New, International Softcover Edition, Printed in black and white pages, minor self wear on the cover or pages, Sale restriction may be printed on the book, but Book name, contents, and author are exactly same as Hardcover Edition. Fast delivery through DHL/FedEx express.

Using MS Excel for powerful exploration, manipulation, and data visualization Key Features ● A deep dive into dashboarding in Excel, understanding the opportunities and limitations of Excel as a BI solution. ● Guiding the reader to understand more about data requests and the stakeholders that make them. ● Transform data into clear information and actionable insights for informed decisions. Description Everyone thinks of Excel differently, and its full potential is often untapped. Businesses tend to decide to invest heavily in proper BI tools, perhaps wrongfully assuming that Excel has a minimal role in that industry. Excel can be used effectively to collect, refresh, transform, and visualize your data in beautiful and eye-catching ways. This book covers building those skills and unlocking Excel and your potential in just seven days. The book explores the process of cleaning your data to ensure accuracy, using formulas to enhance and prepare the same for PivotTables. It will also help you understand how to use data visualization to create clear charts to communicate insights effectively and construct interactive dashboards for user exploration, including elements like slicers and timelines. The book also dives into discovering design principles for easy-to-understand dashboards, while gaining knowledge on maintaining and updating them for ongoing usability. Understanding the full power behind Excel will allow you to improve your spreadsheet game and prove that you can do it all with one industry standard tool and this book. What you will learn ● Better spreadsheet control using conditional formatting, data validation, useful shortcuts, and flash file. ● How to aggregate your data with PivotTables, basic aggregation formula, and advanced aggregation formula. ● Slicers, data validation dropdowns to control the page and getting your end user control. ● Visualize your data by drawing a chart, making it look good, and building a dashboard page. ● Power Query data refreshing and best practices for maintaining your work. Who this book is for This book is for everyone who wants to be a powerful user of Excel, finance teams, sales and marketing teams, MIS Analysts, BI aspirants, and all those who work with Excel sheets daily and want to refine that skill set into something more practical.

Using MS Excel for powerful exploration, manipulation, and data visualization Key Features ● A deep dive into dashboarding in Excel, understanding the opportunities and limitations of Excel as a BI solution. ● Guiding the reader to understand more about data requests and the stakeholders that make them. ● Transform data into clear information and actionable insights for informed decisions. Description Everyone thinks of Excel differently, and its full potential is often untapped. Businesses tend to decide to invest heavily in proper BI tools, perhaps wrongfully assuming that Excel has a minimal role in that industry. Excel can be used effectively to collect, refresh, transform, and visualize your data in beautiful and eye-catching ways. This book covers building those skills and unlocking Excel and your potential in just seven days. The book explores the process of cleaning your data to ensure accuracy, using formulas to enhance and prepare the same for PivotTables. It will also help you understand how to use data visualization to create clear charts to communicate insights effectively and construct interactive dashboards for user exploration, including elements like slicers and timelines. The book also dives into discovering design principles for easy-to-understand dashboards, while gaining knowledge on maintaining and updating them for ongoing usability. Understanding the full power behind Excel will allow you to improve your spreadsheet game and prove that you can do it all with one industry standard tool and this book. What you will learn ● Better spreadsheet control using conditional formatting, data validation, useful shortcuts, and flash file. ● How to aggregate your data with PivotTables, basic aggregation formula, and advanced aggregation formula. ● Slicers, data validation dropdowns to control the page and getting your end user control. ● Visualize your data by drawing a chart, making it look good, and building a dashboard page. ● Power Query data refreshing and best practices for maintaining your work. Who this book is for This book is for everyone who wants to be a powerful user of Excel, finance teams, sales and marketing teams, MIS Analysts, BI aspirants, and all those who work with Excel sheets daily and want to refine that skill set into something more practical.

Improve your daily work efficiency and productivity using Microsoft Excel Key Features ● Get familiar with some of the most useful basic and advanced features in Excel. ● Discover important Excel functions that can quickly and easily perform calculations and analysis. ● Get tips and tricks to become an expert in spreadsheets. Description Microsoft Excel is one of the most significant and widely used tools in various professions and industries. If you want to master Excel, then this book is for you. This book focuses on Excel formulas and functions that transform Excel from a simple spreadsheet into a dynamic and powerful analytics data source for business intelligence. The book demonstrates the formulas and functions with examples, big datasets, and storytelling scenarios. It explains how to use 200+ Excel functions and formulas to create dynamic Excel dashboards, filter relevant data, and show informative and analyzed information. The book also covers instructions on how to develop formulas by combining existing functions to obtain the necessary analysis. After reading the book, you will be well prepared to use Excel for personal and professional tasks ranging from analyzing data to making forecasts and organizing information. What you will learn ● Build complex data-driven models using the lookup and reference functions. ● Learn how to speed up tedious and time-consuming tasks with the user-defined functions in Excel. ● Use a wide range of financial functions to perform complex financial calculations. ● Analyze data and perform various statistical calculations using the statistical functions. ● Explore and work with different mathematical functions in Excel. Who this book is for This book is for everyone who uses Excel daily. It is also for business professionals, researchers, scientists, statisticians, and students who want to use Excel for managing and analyzing data. Table of Contents 1. Getting Started with Excel 2. The 10 Most Popular Functions in Excel 3. Logical Functions in Excel 4. Lookup and Reference Functions in Excel 5. Math Functions in Excel 6. Statistical Functions in Excel 7. Text Functions in Excel 8. Information Functions in Excel 9. Financial Functions in Excel 10. Date and Time Functions in Excel 11. Database Functions in Excel 12. Cube Functions in Excel 13. Web Functions in Excel 14. User-defined Functions in Excel

Improve your daily work efficiency and productivity using Microsoft Excel Key Features ● Get familiar with some of the most useful basic and advanced features in Excel. ● Discover important Excel functions that can quickly and easily perform calculations and analysis. ● Get tips and tricks to become an expert in spreadsheets. Description Microsoft Excel is one of the most significant and widely used tools in various professions and industries. If you want to master Excel, then this book is for you. This book focuses on Excel formulas and functions that transform Excel from a simple spreadsheet into a dynamic and powerful analytics data source for business intelligence. The book demonstrates the formulas and functions with examples, big datasets, and storytelling scenarios. It explains how to use 200+ Excel functions and formulas to create dynamic Excel dashboards, filter relevant data, and show informative and analyzed information. The book also covers instructions on how to develop formulas by combining existing functions to obtain the necessary analysis. After reading the book, you will be well prepared to use Excel for personal and professional tasks ranging from analyzing data to making forecasts and organizing information. What you will learn ● Build complex data-driven models using the lookup and reference functions. ● Learn how to speed up tedious and time-consuming tasks with the user-defined functions in Excel. ● Use a wide range of financial functions to perform complex financial calculations. ● Analyze data and perform various statistical calculations using the statistical functions. ● Explore and work with different mathematical functions in Excel. Who this book is for This book is for everyone who uses Excel daily. It is also for business professionals, researchers, scientists, statisticians, and students who want to use Excel for managing and analyzing data. Table of Contents 1. Getting Started with Excel 2. The 10 Most Popular Functions in Excel 3. Logical Functions in Excel 4. Lookup and Reference Functions in Excel 5. Math Functions in Excel 6. Statistical Functions in Excel 7. Text Functions in Excel 8. Information Functions in Excel 9. Financial Functions in Excel 10. Date and Time Functions in Excel 11. Database Functions in Excel 12. Cube Functions in Excel 13. Web Functions in Excel 14. User-defined Functions in Excel

Unleash Julia’s power: Code Your Data Stories, Shape Machine Intelligence!Book DescriptionThis book takes you through a step-by-step learning journey, starting with the essentials of Julia's syntax, variables, and functions. You'll unlock the power of efficient data handling by leveraging Julia arrays and DataFrames.jl for insightful analysis. Develop expertise in both basic and advanced statistical models, providing a robust toolkit for deriving meaningful data-driven insights. The journey continues with machine learning proficiency, where you'll implement algorithms confidently using MLJ.jl and MLBase.jl, paving the way for advanced data-driven solutions. Explore the realm of Bayesian inference skills through practical applications using Turing.jl, enhancing your ability to extract valuable insights. The book also introduces crucial Julia packages such as Plots.jl for visualizing data and results.The handbook culminates in optimizing workflows with Julia's parallel and distributed computing capabilities, ensuring efficient and scalable data processing using Distributions.jl, Distributed.jl and SharedArrays.jl. This comprehensive guide equips you with the knowledge and practical insights needed to excel in the dynamic field of data science and machine learning.Table of Contents1. Julia In Data Science Arena2. Getting Started with Julia3. Features Assisting Scaling ML Projects4. Data Structures in Julia5. Working With Datasets In Julia6. Basics of Statistics7. Probability Data Distributions8. Framing Data in Julia9. Working on Data in DataFrames10. Visualizing Data in Julia11. Introducing Machine Learning in Julia12. Data and Models13. Bayesian Statistics and Modeling14. Parallel Computation in Julia15. Distributed Computation in JuliaIndex

In this book, Students will get very important information about Excel and will learn how to use Excel, with this they will get lots of information like Excel formulas , hints , tricks and password, security and privacy of Excel, In this book student will be able to learn Excel in very easy language with in 30Days

Excel 2016 For Dummies (9781119077015) is now being published as Excel 2016 For Dummies (9781119293439). While this version features an older Dummies cover and design, the content is the same as the new release and should not be considered a different product. Let your Excel skills sore to new heights with this bestselling guide Updated to reflect the latest changes to the Microsoft Office suite, this new edition of Excel For Dummies quickly and painlessly gets you up to speed on mastering the world's most widely used spreadsheet tool. Written by bestselling author Greg Harvey, it has been completely revised and updated to offer you the freshest and most current information to make using the latest version of Excel easy and stress-free. If the thought of looking at spreadsheet makes your head swell, you've come to the right place. Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest installment of the software, Microsoft Excel 2016. In no time, you'll begin creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, and more. Plus, you'll get easy-to-follow guidance on mastering more advanced skills, like adding hyperlinks to worksheets, saving worksheets as web pages, adding worksheet data to an existing web page, and so much more. Save spreadsheets in the Cloud to work on them anywhere Use Excel 2016 on a desktop, laptop, or tablet Share spreadsheets via email, online meetings, and social media sites Analyze data with PivotTables If you're new to Excel and want to spend more time on your actual work than figuring out how to make it work for you, this new edition of Excel 2016 For Dummies sets you up for success.

Excel 2016 For Dummies (9781119077015) is now being published as Excel 2016 For Dummies (9781119293439). While this version features an older Dummies cover and design, the content is the same as the new release and should not be considered a different product. Let your Excel skills sore to new heights with this bestselling guide Updated to reflect the latest changes to the Microsoft Office suite, this new edition of Excel For Dummies quickly and painlessly gets you up to speed on mastering the world's most widely used spreadsheet tool. Written by bestselling author Greg Harvey, it has been completely revised and updated to offer you the freshest and most current information to make using the latest version of Excel easy and stress-free. If the thought of looking at spreadsheet makes your head swell, you've come to the right place. Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest installment of the software, Microsoft Excel 2016. In no time, you'll begin creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, and more. Plus, you'll get easy-to-follow guidance on mastering more advanced skills, like adding hyperlinks to worksheets, saving worksheets as web pages, adding worksheet data to an existing web page, and so much more. Save spreadsheets in the Cloud to work on them anywhere Use Excel 2016 on a desktop, laptop, or tablet Share spreadsheets via email, online meetings, and social media sites Analyze data with PivotTables If you're new to Excel and want to spend more time on your actual work than figuring out how to make it work for you, this new edition of Excel 2016 For Dummies sets you up for success.

Printed in Asia - Carries Same Contents as of US edition - Opt Expedited Shipping for 3 to 4 day delivery -

This book is indispensable for Excel intermediate users, power users, and would-be power users. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else. Thoroughly updated to cover the Excel interface, file formats, enhanced interactivity with other Office applications, and upgraded collaboration features. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic for Applications. Includes a valuable CD-ROM with templates and worksheets from the book.About the AuthorJohn Walkenbach principal of J-Walk and Associates, Inc. is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at (http://www.j-walk.com/ss) www.j-walk.com/ss and promotes all his books at that site.Table of ContentsPart I: Some Essential Background.Introduction.Chapter 1: Excel 2010: Where It Came From.Chapter 2: Excel in a Nutshell.Chapter 3: Formula Tricks and Techniques.Chapter 4: Understanding Excel Files.Part II: Excel Application Development.Chapter 5: What Is a Spreadsheet Application?Chapter 6: Essentials of Spreadsheet Application Development.Part III: Understanding Visual Basic for Applications.Chapter 7: Introducing Visual Basic for Applications.Chapter 8: VBA Programming Fundamentals.Chapter 9: Working with VBA Sub Procedures.Chapter 10: Creating Function Procedures.Chapter 11: VBA Programming Examples and Techniques.Part IV: Working with UserForms.Chapter 12: Custom Dialog Box Alternatives.Chapter 13: Introducing UserForms.Chapter 14: UserForm Examples.Chapter 15: Advanced UserForm Techniques.Part V: Advanced Programming Techniques.Chapter 16: Developing Excel Utilities with VBA.Chapter 17: Wor

100% practical guide to understand and use basic to advance level Excel 2019 DESCRIPTION Excel is, by far, the most preferred spreadsheet program on this planet. People love it because of its simplicity and easy user interface. The primary focus of Excel is to perform basic to advanced level numeric calculations. Every industry, department, job role is dependent on Excel to perform day to day duties as well as data analysis and visualization. Microsoft Excel is available in both offline (Excel 2019) and online (Office 365) versions. If you are new to Excel or use this program day in day out, then this book will surely clear your logics and concepts of excel. This book starts with an introduction to Excel program and an overview of its interface and move towards an explanation of new features being introduced in Excel 2019 and Office 365, then an in-depth discussion on entering and transforming data. Understanding different formulas and functions with practical exercises. Afterwards, how to perform data analysis and present it using different data visualization tools. Finally, extracting data and automation of tasks through Macros. After going through this book, you will become conceptually strong in using various features of Excel. You will increase your productivity by understanding and using the right tool for the related data set. KEY FEATURES What’s New in Excel 2019 Office 365 Putting Data into Excel Transforming and Managing the Data Formulas and Functions Data Analysis techniques Data Visualization techniques Multiple ways of Data Extraction Automation in Excel through Macros WHAT WILL YOU LEARN By the end of the book, you will come across many case studies to put your knowledge to practice and understand many tools to solve real-life business problems such as importing data into Excel from different sources, data cleaning through various tools including flash fill, bringing data together into one place using lookup functionality, analysing it to get insights through pivot tables & what if analysis, generating forecast based on past trends, exporting final reports, understanding Power features like Power Pivot/Query/Map and automating manual processes through Macros . Remember to practice along with sample data files provided in the exercise files bundle of the book to master these techniques. WHO THIS BOOK IS FOR This book is for anyone who is either new to Excel or daily Excel user. This book will take you from basic concepts of Excel to Advanced level. Whether you belong to any industry or serving any department, as an Excel user, this book will make you a Pro in Excel. Table of Contents What’s New in Excel 2019/Office 365 Entering Data in Excel Transforming and Managing Data Formulas and Functions Data Analysis Data Visualization Data Extraction Automation in Excel through Macros

The power to build a successful career is at your fingertips with Excel 2021 DESCRIPTION Do you struggle with handling Excel data? Do you waste a lot of time figuring out which formulas and functions to use for your day-to-day office work? Even so, do you still want to become a master of Excel's most advanced features and techniques? This book will teach you the fundamentals and most beneficial uses of Microsoft Excel through various examples, practical illustrations, and good shortcuts to make your life easier with it. To begin, we'll look at the numerous features every professional needs to manage enormous volumes of data. The reader will discover how to import data from various sources and cleanse and arrange it. You'll learn how to use Excel's formulas and functions, as well as how to analyse data in a variety of ways. This book will demonstrate how Excel's new capabilities combine AI and ML to improve and simplify data visualisation straightforwardly. This book will teach you how to solve business problems using Excel's built-in functions. In this book, you will learn: ● Start with the essential Excel skills and gradually learn the sophisticated formulas. ● Discover how to quickly and easily import data from various external sources and formats. ● Eliminate complex data structures, adjust formats, and enhance data visibility. ● Discover hundreds of shortcuts, do complex computations, and study intelligent visuals. ● Learn how to use PivotTables, What-If Analysis and Array functions to generate valuable reports and dashboards. What makes this book your go-to Excel skill guide? ● Excel techniques and formulas. ● Several practical examples that make day-to-day job activities easier in minutes. ● With only a few clicks, you can learn to filter, manage, and analyse your business data. ● High-quality images and screenshots help you choose the correct tool in seconds. And there are many more to explore in this book. WHO THIS BOOK IS FOR Students, recent graduates, and professionals, such as Accountants, Retail Managers, Sales Executives, Business Analysts, Administrative Assistants, and HR Professionals who want to boost their day-to-day data management and analytical skills, will find this book to be an invaluable resource. This book, along with Excel or Microsoft 365, is all you need to become a professional Excel user. TABLE OF CONTENTS 1. What is New in Excel 2021 2. Excel Basics 3. Transforming and Managing Data 4. Achieving Data Consistency 5. Manipulating data 6. Power of Tables 7. Introduction to Formulas and Functions 8. Text & Other Functions 9. Date Functions 10. Logical and Lookup Functions 11. Array Functions 12. Formula Auditing 13. PivotTables 14. What-If Analysis 15. Protection and Security 16. Conditional Formatting 17. Charting Data 18. Excel Hacks and Tips - The Practical Side 19. The Way Forward

Simplify the Usage of Excel Features and Functionalities, with the Help of ExamplesBook is written in a lucid manner to explain the concepts in details, with adequate emphasis on examples. The intend of this book is to explain and simplify the usage of Excel features and functionalities, with help of examples. Book will enable users in working efficiently and will increase their workplace productivity. It explains:-Functions for calculations-Graphing tools-Pivot tables-Data analysis tools-Micro programming-Add-ins that enable core complex operations.KEY FEATURES1.Basic components of excel, the available menu options and tools, some customizations working with multiple workbooks and worksheets, most frequently used and useful keyboard shortcuts.2.An initial introduction to what are formulas, functions, and their components.3.Usage of multiple examples to explain the application in real world scenario.4.Explaining of different chart types available in Excel and how best it can be used for creating different views of data, good graphics, visualizations for dashboards, and so on.5.Different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends.6.Excel features that help in automating tasks.B WHAT WILL YOU LEARN-Performing functions with shortcut keys.-Formulas and functions-Data visualization with new chart types-Gantt and Milestone Chart-Smart Art and Organization Chart-Putting data in perspective with Pivots-Complex data analysis using Tool Pak-Forecasting in Excel-Mail Merge using Excel-Macros in Excel-What is in Excel 2019 WHO THIS BOOK IS FORAnyone who wants to learn Excel, do the mundane task easily and quickly, do complex calculations, analysis huge data from internal or external sources, take decisions based on predictions, do forecasting, create plans and charts, monitor dashboards for progress and status, and so on.

Unleash the power of Excel for advanced data analysis, automation, and productivity KEY FEATURES ● Build a solid foundation in Excel by learning the basics, including the creation and formatting cells, sheets, and workbooks. ● Explore advanced Excel techniques, including formulas, data analysis, and VBA macros. ● Discover the potential of ChatGPT for Excel automation, that enables you to automate tasks and generate insightful reports. DESCRIPTION Advanced Excel is a powerful tool that goes beyond basic spreadsheet functions, allowing users to perform complex calculations, manipulate large datasets, create interactive visualizations, automate tasks, and conduct in-depth data analysis. If you want to enhance your productivity, accuracy, and decision-making skills in Excel, look no further. This book is a comprehensive guide that explores the advanced features of Microsoft Excel. From creating macros with VBA to automating tasks, working with large datasets, creating visualizations, and conducting data analysis, this book covers it all. Additionally, it also introduces ChatGPT, an AI chatbot that enhances Excel automation. With practical examples and clear instructions, this guide empowers users to maximize their productivity, efficiency, and decision-making skills in Excel. By the end of this book, you will have developed the expertise and confidence to tackle complex tasks in Excel with ease. WHAT YOU WILL LEARN ● Develop proficiency in working with large datasets. ● Conduct data analysis using powerful tools like Vlookup and Advanced Pivot Tables. ● Create impactful charts and graphs that effectively communicate your findings and insights. ● Seamlessly integrate Excel with other applications to streamline your workflows and enhance collaboration. ● Discover time-saving techniques and shortcut keys to improve your productivity and efficiency in Excel. WHO THIS BOOK IS FOR For individuals seeking to enhance their Excel skills for advanced tasks, this extensive book serves as a valuable asset. It also caters to the needs of accountants, financial analysts, business analysts, and data scientists who aspire to boost their efficiency and productivity in Excel. TABLE OF CONTENTS 1. Overview of Excel 2021 2. Cell References and Range 3. Working with Formulas and Functions 4. Data Validation 5. Protection 6. Sorting a Database 7. Filtering a Database 8. Subtotals and Data Consolidation 9. Pivot Tables 10. Conditional Formatting 11. What-if-Analysis 12. Working with Multiple Worksheets, Workbooks and Applications 13. Working with Charts 14. Creating and Recording Macros in VBA 15. Assigning Buttons to Macros 16. Functions and Subroutines in VBA 17. Conditional Statements in VBA 18. Variables and Data Types in VBA 19. Looping Structures in VBA 20. Arrays and Collections in VBA 21. Debugging and Error Handling in VBA 22. User Forms and User Input in VBS 23. Advanced VBA Techniques and Best Practices 24. Building Custom Add-ins with VBA 25. ChatGPT with Excel

Improve your daily work efficiency and productivity using Microsoft Excel. Key Features: - Get familiar with some of the most useful basic and advanced features in Excel. - Discover important Excel functions that can quickly and easily perform calculations and analysis. - Get tips and tricks to become an expert in spreadsheets. Description: Microsoft Excel is one of the most significant and widely used tools in various professions and industries. If you want to master Excel, then this book is for you. This book focuses on Excel formulas and functions that transform Excel from a simple spreadsheet into a dynamic and powerful analytics data source for business intelligence. The book demonstrates the formulas and functions with examples, big datasets, and storytelling scenarios. It explains how to use 200+ Excel functions and formulas to create dynamic Excel dashboards, filter relevant data, and show informative and analyzed information. The book also covers instructions on how to develop formulas by combining existing functions to obtain the necessary analysis. After reading the book, you will be well prepared to use Excel for personal and professional tasks ranging from analyzing data to making forecasts and organizing information. What you will learn: - Build complex data-driven models using the lookup and reference functions. - Learn how to speed up tedious and time-consuming tasks with the user-defined functions in Excel. - Use a wide range of financial functions to perform complex financial calculations. - Analyze data and perform various statistical calculations using the statistical functions. - Explore and work with different mathematical functions in Excel. Who this book is for: This book is for everyone who uses Excel daily. It is also for business professionals, researchers, scientists, statisticians, and students who want to use Excel for managing and analyzing data.

Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends KEY FEATURES ● Use the Analysis ToolPak to perform complex Data analysis ● Get well versed with the formulas, functions, and components in Excel ● Handy templates to give you a head start ● Usage of multiple examples to explain the application in a real-world scenario ● Implement macros for your everyday tasks that will help you save your time ● Explore different Charts types for Data visualization DESCRIPTION Book explains and simplify the usage of Excel features and functionalities, with the help of examples. It starts with ‘Getting Started with Excel’ and ‘Performing functions with shortcut keys’ which will help you in getting started with Excel. Then ‘Formulas and Functions’ gives an initial understanding of what are operators, formulas, functions, their components. Further ‘Data Visualization with new Charts types’, ‘Gantt and Milestone chart’, ‘SmartArt and Organization Chart’ give details on the different chart types available in Excel. In the intermediate section you will learn ‘Get creative with Icons, 3D models, Digital Inking’ details multiple new and improved features that got introduced to enhance the visual presentation. In the end, Chapters ‘Mail Merge using Excel’, ‘Create Custom Excel Template’ and ‘Macros in Excel’ explain the Excel features that help in automating tasks. You will learn how to generate multiple documents automatically with customization, create and use your own templates and use of macros to do repeated task automatically. And at last Chapter ‘Get help for your problem’ lists few problem statements and their probable solutions with references to the Excel feature or functionality that can be used to resolve the problem. WHAT WILL YOU LEARN ● Get familiar with the most used advanced Excel formulas and functions for Data analysis ● Learn how to create a Gantt / Timeline / Milestone Chart in Excel ● Use charts for Better Data visualization ● Build organization charts with SmartArt tools in Excel ● Use the Analysis ToolPak & Power Pivots to perform complex Data analysis ● Learn how to link and share workbooks for automatic updates WHO THIS BOOK IS FOR This book is for professionals from any domain, who are searching for shortcuts & advanced methods to resolve their daily problems. Table of Contents 1. Getting Started with Excel 2. Perform Functions with Shortcut Keys 3. Formulas and Functions 4. Data Visualization with New Chart types 5. Gantt and Milestone Chart 6. SmartArt & Organization Chart 7. Get creative with Icons, 3D models, Digital Inking 8. Putting Data in perspective with Pivots 9. Complex Data Analysis using ToolPak 10. Forecasting in Excel 11. Mail Merge using Excel 12. Create Custom Excel Template 13. Macros in Excel 14. Get help for your problem AUTHOR BIO Manisha Nigam is a seasoned management professional with twenty plus years of information technology experience, working with multinationals across the globe. Her expertise in Excel comes from the vast experience she has in using and understanding the software over the years, that helped her in working efficiently and managing complex programs. A certified PMP (PMI – Project Management Professional), CSM (Scrum Alliance – Scrum Master), TOGAF 9.1 (The Open Group – Enterprise Architecture) and holds a post graduate degree in computer science and business management from prestigious universities in India. Her LinkedIn Profile: linkedin.com/in/mnigam10

Everything you need to know about using Excel for finance and accounting functions KEY FEATURES ● Learn how to create financial models in Excel. ● Explore ways to use Excel functions and formulas for financial calculations. ● Implement advanced Excel techniques for finance and accounting tasks. DESCRIPTION Excel is a widely-used tool in finance and accounting, and this book provides a comprehensive guide on how to utilize it for maximum efficiency. The book covers basic to advanced Excel functions such as data manipulation, financial modeling, and scenario analysis. It also offers practical tips on how to create professional-looking reports, charts, and tables, which are essential in presenting financial data to stakeholders. With Excel's ever-evolving features and functions, it can be challenging for professionals to keep up with its latest updates. This book keeps you updated with the latest Excel features and offers practical examples of how to apply them in finance and accounting. Additionally, it offers tips on how to use Excel to automate repetitive tasks, freeing up more time for strategic analysis and decision-making. With this book, you can learn to leverage Excel to its full potential and gain a competitive advantage in your roles. WHAT YOU WILL LEARN ● Learn how to effectively manage financial data in Excel. ● Discover different techniques for preparing financial statements. ● Learn how to perform budget analysis in Excel. ● Learn how to create a forecast in Excel. ● Build dynamic dashboards and reports for financial data. WHO THIS BOOK IS FOR For individuals working in finance and accounting positions, whether at an entry-level or in senior management, this book is a must-have. It will enable professionals to enhance their productivity, precision, and effectiveness, resulting in significant savings of time and resources. TABLE OF CONTENTS 1. Getting Started with Advance Excel 2. Preparing Financial Statements Smartly 3. Calculating and Projecting...

Novice or expert, learn to simplify and optimize data transformations KEY FEATURES ● Practical approaches to cleansing, connecting and transforming data in Power Query. ● Real-life examples that readers can apply to their own work. ● Master Power Query for Excel and Power BI with step-by-step recipes. DESCRIPTION “The Ultimate Power Query Cookbook for Power BI and Excel” serves up easy-to-follow recipes that transform data into meaningful insights. You will learn to clean messy files, combine datasets, and even use AI magic to Power BI and Excel. This book will walk you through the basics of getting connected to data with Power Query. You will understand how to ingest data from files, folders, databases, websites, APIs, and other third party sources. Once connected, you will learn how to transform the data so it is ready for your use. We will clean up columns, filter, replace, extract, and classify data in Power Query to meet your needs. The book offers over 100 practical recipes, ensuring you understand each step with clear explanations and examples. Lastly, we will go over advanced techniques to help optimize and simplify your transformations allowing fast refreshes all while helping you manage them in the future. This book will help you know how to apply these techniques and recipes to your data all while understanding the implications of making certain decisions. This will enable you to have better conversations with other data professionals who are providing data for your use. WHAT YOU WILL LEARN ● Learn to connect to files, databases, and third-party services. ● Manage data types and formats to optimize storage. ● Transform, create, and manipulate queries. ● Combine, merge, filter, and cleanse queries. ● Integrate artificial intelligence to accelerate insights. ● Perform complex and scalable transformations. WHO THIS BOOK IS FOR Novice or expert, this book is designed for all Excel users, data analysts, Power BI power users, business professionals and data enthusiasts to get the most out of your data solutions when transforming your data in Power Query. TABLE OF CONTENTS 1. Introduction to Power Query 2. Connect to File-Based Data Sources 3. Connect to Web-Based Data Sources 4. Connect to Database Sources 5. Connect to Third-Party Data Sources 6. Managing Data Types 7. Transforming Columns 8. Cleansing Columns 9. Creating New Columns 10. Combining and Manipulating Queries 11. Using Python, R, and AI 12. Indexing 13. Parameters 14. Functions 15. Advanced Web Connections 16. Manipulating Supporting Queries

This book provides practical knowledge, hands-on examples, and step-by-step instructions to master the capabilities of Excel, harness VBA for customization, and integrate ChatGPT for intelligent conversations. The book provides a thorough overview of Excel including navigating the interface, mastering array formulas and essential functions, completing repetitive tasks, exploring macros, and using ChatGPT for content generation and advanced data analysis. This book is ideal for beginners and experienced users, including data analysts, financial professionals, and anyone seeking to enhance their Excel skills with VBA and AI integration. FEATURES Master array formulas, e.g., VLOOKUP, INDEX MATCH, and other essential functions Automate repetitive tasks and enhance productivity with powerful macros Features step-by-step tutorials, clear instructions and practical examples for mastering Excel, VBA, and ChatGPT Includes best practices for integrating AI and automation into your workflows

Technical Interviews: Excel with Ease has been written keeping in view the large cross-section of job-seekers and professionals belonging to the discipline of Electronics, Communication, Instrumentation, Computer Science and Information Technology

Cover page Brief contents Half Title page Title page Copyright page about the author Acknowledgments contents Introduction Section I Understanding the BASICs Chapter 1:Introducing VBA What Is Vba? A Brief His Tory of Vba What Vba Can do for You Automating a Recurring Task Automating a Repetitive Task Running a Macro Automatically if Another Action Takes Place Creating Your Own Worksheet Functions Simplifying the Workbook’s Look and Feel for Other Users Controlling Other Office Applications from Excel Liabilities of Vba Try It Chapter 2:Getting Started with Macros Composing Your First Macro Accessing the VBA Environment Using the Macro Recorder Running a Macro The Macro Dialog Box Shortcut Key Try It Lesson Requirements Step-by-Step Chapter 3:Introducing the Visual Basic Editor What Is The Vbe? How to Get Into the Vbe Understanding the Vbe The Project Explorer Window The Code Window The Properties Window The Immediate Window Understanding Modules Using The Object Browser Exiting The Vbe Try It Chapter 4:Working in the VBE Toolbars In the Vbe Macros and Modules Locating Your Macros Understanding the Code Editing a Macro with Comments and Improvements to the Code Deleting a Macro Inserting a Module Renaming a Module Deleting a Module Locking and Protecting the Vbe Try It Lesson Requirements Step-by-Step Section II Diving Deeper into VBA Chapter 5:Object-oriented Programming — An Overview What “object-oriented Programming” Means The Object Model Properties Methods Collections Try It Chapter 6:Variables, Data Types, and Constants What is a Variable? Assigning Values to Variables Why You Need Variables Data Types Understanding the Different Data Types Declaring a Variable for Dates and Times Declaring a Variable with the Proper Data Type Forcing Variable Declaration Understanding a Variable’s Scope Local Macro Level Only Module Level Application Level Constants Choosing the Scope and Lifetime of Your Constants Try It Lesson Requirements Step-by-Step Chapter 7:Understanding Objects and Collections Workbooks Worksheets Cells and Ranges Special cells Try It Lesson Requirements Step-by-Step Chapter 8:Making Decisions with VBA Understanding Logical Operators AND OR NOT Choosing Between This or That If...Then If...Then...Else If...Then...ElseIf Select Case Getting Users to Make Decisions Message Boxes Input Boxes Try It Lesson Requirements Step-by-Step Section III Beyond the Macro Recorder: Writing Your Own Code Chapter 9:Repeating Actions with Loops What Is a Loop? Types of Loops For...Next For...Each...Next Exiting a For... Loop Looping In Reverse with Step Do...While Do...Until Do...Loop...While Do...Loop...Until While...Wend Nesting Loops Try It Lesson Requirements Step-by-Step Chapter 10:Working with Arrays What is an Array? What Arrays Can do for You Declaring Arrays The Option Base Statement Boundaries In Arrays Declaring Arrays With Fixed Elements Declaring Dynamic Arrays With Redim and Preserve Try It Lesson Requirements Step-by-Step Chapter 11:Automating Procedures with Worksheet Events What is an “event”? Worksheet Events — An Overview Where Does the Worksheet Event Code Go? Enabling and Disabling Events Examples of Common Worksheet Events Worksheet_Change Event Worksheet_SelectionChange Event Worksheet_BeforeDoubleClick Event Worksheet_BeforeRightClick Event Worksheet_FollowHyperlink Event Worksheet_Activate Event Worksheet_Deactivate Event Worksheet_Calculate Event Worksheet_PivotTableUpdate Event Try It Lesson Requirements Step-by-Step Chapter 12:Automating Procedures with Workbook Events Workbook Events — an Overview Where Does the Workbook Event Code Go? Entering Workbook Event Code Examples of Common Workbook Events Workbook_Open Event Workbook_BeforeClose Event Workbook_Activate Event Workbook_Deactivate Event Workbook_SheetChange Event Workbook_SheetSelectionChange Event Workbook_SheetBeforeDoubleClick Event Workbook_SheetBeforeRightClick Event Workbook_SheetPivotTableUpdate Event Workbook_NewSheet Event Workbook_BeforePrint Event Workbook_SheetActivate Event Workbook_SheetDeactivate Event Workbook_BeforeSave Event Try It Lesson Requirements Step-by-Step Chapter 13:Using Embedded Controls Working With Forms Controls And Ac Tivex Controls The Forms Toolbar The Control Toolbox Try It Lesson Requirements Step-by-Step Chapter 14:Programming Charts Adding a Chart to a Chart Sheet Adding an Embedded Chart to a Worksheet Moving a Chart Looping Through All Embedded Charts Deleting Charts Renaming a Chart Try It Lesson Requirements Step-by-Step Chapter 15:Programming PivotTables and PivotCharts Creating a Pivottable Report Hiding the PivotTable Field List Using the Report Filter Area Formatting Numbers in the Values Area Why It’s Called a PivotTable Creating a Pivotchart Understanding Pivotcaches Manipulating Pivotfields In Vba Manipulating Pivotitems With Vba Creating a Pivottables Collection Try It Lesson Requirements Step-by-Step Chapter 16:User Defined Functions What Is A User Defined Function? Characteristics of User Defined Functions Anatomy of a UDF UDF Examples That Solve Common Tasks Volatile Functions The Name of the Active Worksheet and Workbook UDFs with Conditional Formatting Calling Your Function from a Macro Adding a Description to the Insert Function Dialog Try It Lesson Requirements Step-by-Step Chapter 17:Debugging Your Code What Is Debugging? What Causes Errors? Weapons of Mass Debugging The Debugging Toolbar Trapping Errors Error Handler Bypassing Errors Try It Lesson Requirements Step-by-Step Section IV Advanced Programming Techniques Chapter 18:Creating UserForms What Is a Userform? Creating a Userform Designing a Userform Adding Controls to a Userform Showing a Userform Where Does the Userform’s Code Go? Closing a Userform Unloading a User Form Hiding a User Form Try It Lesson Requirements Step-by-Step Chapter 19:UserForm Controls and Their Functions Understanding The Frequently Used Userform Controls CommandButtons Labels TextBoxes ListBoxes ComboBoxes CheckBoxes OptionButtons Frames MultiPages Try It Lesson Requirements Step-by-Step Chapter 20:Advanced UserForms The Userform Toolbar Modal Versus Modeless Disabling the Userform’s Close Button Maximizing Your Userform’s Size Select Ing and Displaying Photographs on a Userform Unloading a Userform Automatically Pre-sorting The Listb Ox and Combobox Items Populating Listb Oxes and Comboboxes With Unique It Ems Display a Real-time Chart In a Userform Try It Lesson Requirements Step-by-Step Chapter 21:Class Modules What Is a Class? What Is a Class Module? Creating Your Own Objects An Important Benefit of Class Modules Creating Collections Class Modules For Embedded Objects Try It Lesson Requirements Step-by-Step Chapter 22:Add-Ins What Is an Excel Add-in? Creating an Add-in Converting a File to an Add-in Installing an Add-in Creating a User Interface For Your Add-in Changing the Add-in’s Code Closing Add-ins Removing an Add-in From The Add-ins List Try It Lesson Requirements Step-by-Step Chapter 23:Managing External Data Creating Querytables From Web Queries Creating a Querytable For Access Using Text Files to Store External Data Try It Lesson Requirements Step-by-Step Chapter 24:Data Access with ActiveX Data Objects Introducing ADO The Connection Object The Recordset Object The Command Object An Introduction to Structured Query Language (sql) The SELECT Statement The INSERT Statement The UPDATE Statement The DELETE Statement Try It Chapter 25:Not Gone, Not Forgotten Using Dialog Sheets What Does a Dialog Sheet Look Like? Option to Show Message Only Once Using Xlm Get.cell Functions Using The Sendkeys Method Try It Lesson Requirements Step-by-Step Section V Interacting with Other Office Applications Chapter 26:Overview of Office Automation from Excel Why Automate Another Application? Understanding Office Automation Early Binding Late Binding Which One is Better? Try It Lesson Requirements Step-by-Step Chapter 27:Working with Word from Excel Activating a Word Document Activating the Word Application Opening and Activating a Word Document Creating a New Word Document Copying an Excel Range to a Word Document Printing a Word Document From Excel Importing a Word Document to Excel Try It Lesson Requirements Step-by-Step Chapter 28:Working with Outlook from Excel Opening Outloo K Composing An E‐mail In Outloo K From Excel Creating a MailItem Object Transferring an Excel Range to the Body of Your E‐mail Putting It All Together E‐mailing A Single Worksheet Try It Lesson Requirements Step-by-S tep Chapter 29:Working with Access from Excel Adding a Record to an Access Table Exporting an Access Table to an Excel Spreadsheet Creating a New Table In Access Try It Lesson Requirements Step-by-Step Chapter 30:Working with PowerPoint from Excel Creating a New Powerpoint Presentation Copying a Worksheet Range to a Powerpoint Slide Copying Chart Sheets to Powerpoint Slides Running a Powerpoint Presentation From Excel Try It Lesson Requirements Step-by-Step Appendix What’s on the DVD? System Requirements Us Ing The Dvd What’s On The Dvd? Tr Oubleshooting Customer Car E Symbols A B C D E F H I G K L M N O P Q R S U T V W Y X Z Index Back cover

Learn Everything about Excel Charts, PivotTables, Dashboards and Master Analytic Techniques for Decision Making DESCRIPTION Excel's charts, graphs, and reports are beneficial, so it's time to use them to your advantage. Learn how to execute the most innovative analysis on your preferred data using PivotTables, PivotCharts, What-if-Analysis, descriptive statistics, correlations, histograms, sparklines, animated charts, dashboards, trendlines, and more than 100 other charts and graphs. The book includes the following: ● Try and practice new Excel 2022 Charts and Reports in your Excel 2019, Excel 2021 and Office 365 editions. ● Learn with easy-to-read, step-by-step instructions and screenshots. ● Learn to illustrate your data in a way that is readily digestible at a glance. ● Figure out how to make beautiful infographics that reflect your company's personality or culture. ● Learn the ins and outs of making and editing expert PivotTables and PivotCharts. ● Master PivotTables and PivotCharts to construct dynamic dashboards. ● Utilize Excel's What-If analysis to check your assumptions and theories. ● Create Sensitivity-Analysis tables to check the quality of your decision-making tools. ● Create summaries, cross-tabs, filtering, and other visualizations. ● Conduct in-depth statistical analysis in Excel with minimal effort. This book's thorough instructions on Excel charts will improve readers' skills in making the most innovative and visually appealing reports. You will be able to make dynamic, eye-catching dashboards once you complete reading this book. WHO THIS BOOK IS FOR No matter what your professional or academic status is, if you often engage in data analysis, summary creation, and report writing, this book is for you. You'll be able to generate relatively strong reports and infographics from your data, thereby allowing you to make more well-informed decisions. There is no need for you to be an Excel expert to use this book. TABLE OF CONTENTS Part I 1. Selecting Var

Students at higher education level in management are required to understand and apply statistical tools and techniques. This book is attempted to make the readers better understand business statistics using Microsoft Excel, which is a popular statistical tool used among the teaching fraternity and widely used by researchers and business analysts. In each chapter, problems are solved with the use of computer. Performing statistical tests using excel is essential today. With this as prime focus, all the chapters are discussed with practical approach.

Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends KEY FEATURES ● Use the Analysis ToolPak to perform complex Data analysis ● Get well versed with the formulas, functions, and components in Excel ● Handy templates to give you a head start ● Usage of multiple examples to explain the application in a real-world scenario ● Implement macros for your everyday tasks that will help you save your time ● Explore different Charts types for Data visualization DESCRIPTION Book explains and simplify the usage of Excel features and functionalities, with the help of examples. It starts with ‘Getting Started with Excel’ and ‘Performing functions with shortcut keys’ which will help you in getting started with Excel. Then ‘Formulas and Functions’ gives an initial understanding of what are operators, formulas, functions, their components. Further ‘Data Visualization with new Charts types’, ‘Gantt and Milestone chart’, ‘SmartArt and Organization Chart’ give details on the different chart types available in Excel. In the intermediate section you will learn ‘Get creative with Icons, 3D models, Digital Inking’ details multiple new and improved features that got introduced to enhance the visual presentation. In the end, Chapters ‘Mail Merge using Excel’, ‘Create Custom Excel Template’ and ‘Macros in Excel’ explain the Excel features that help in automating tasks. You will learn how to generate multiple documents automatically with customization, create and use your own templates and use of macros to do repeated task automatically. And at last Chapter ‘Get help for your problem’ lists few problem statements and their probable solutions with references to the Excel feature or functionality that can be used to resolve the problem. WHAT WILL YOU LEARN ● Get familiar with the most used advanced Excel formulas and functions for Data analysis ● Learn how to create a Gantt / Timeline / Milestone Chart in Excel ● Use charts for Better Data visualization ● Build organization charts with SmartArt tools in Excel ● Use the Analysis ToolPak & Power Pivots to perform complex Data analysis ● Learn how to link and share workbooks for automatic updates WHO THIS BOOK IS FOR This book is for professionals from any domain, who are searching for shortcuts & advanced methods to resolve their daily problems. Table of Contents 1. Getting Started with Excel 2. Perform Functions with Shortcut Keys 3. Formulas and Functions 4. Data Visualization with New Chart types 5. Gantt and Milestone Chart 6. SmartArt & Organization Chart 7. Get creative with Icons, 3D models, Digital Inking 8. Putting Data in perspective with Pivots 9. Complex Data Analysis using ToolPak 10. Forecasting in Excel 11. Mail Merge using Excel 12. Create Custom Excel Template 13. Macros in Excel 14. Get help for your problem AUTHOR BIO Manisha Nigam is a seasoned management professional with twenty plus years of information technology experience, working with multinationals across the globe. Her expertise in Excel comes from the vast experience she has in using and understanding the software over the years, that helped her in working efficiently and managing complex programs. A certified PMP (PMI – Project Management Professional), CSM (Scrum Alliance – Scrum Master), TOGAF 9.1 (The Open Group – Enterprise Architecture) and holds a post graduate degree in computer science and business management from prestigious universities in India. Her LinkedIn Profile: linkedin.com/in/mnigam10

Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends KEY FEATURES ● Use the Analysis ToolPak to perform complex Data analysis ● Get well versed with the formulas, functions, and components in Excel ● Handy templates to give you a head start ● Usage of multiple examples to explain the application in a real-world scenario ● Implement macros for your everyday tasks that will help you save your time ● Explore different Charts types for Data visualization DESCRIPTION Book explains and simplify the usage of Excel features and functionalities, with the help of examples. It starts with ‘Getting Started with Excel’ and ‘Performing functions with shortcut keys’ which will help you in getting started with Excel. Then ‘Formulas and Functions’ gives an initial understanding of what are operators, formulas, functions, their components. Further ‘Data Visualization with new Charts types’, ‘Gantt and Milestone chart’, ‘SmartArt and Organization Chart’ give details on the different chart types available in Excel. In the intermediate section you will learn ‘Get creative with Icons, 3D models, Digital Inking’ details multiple new and improved features that got introduced to enhance the visual presentation. In the end, Chapters ‘Mail Merge using Excel’, ‘Create Custom Excel Template’ and ‘Macros in Excel’ explain the Excel features that help in automating tasks. You will learn how to generate multiple documents automatically with customization, create and use your own templates and use of macros to do repeated task automatically. And at last Chapter ‘Get help for your problem’ lists few problem statements and their probable solutions with references to the Excel feature or functionality that can be used to resolve the problem. WHAT WILL YOU LEARN ● Get familiar with the most used advanced Excel formulas and functions for Data analysis ● Learn how to create a Gantt / Timeline / Milestone Chart in Excel ● Use charts for Better Data visualization ● Build organization charts with SmartArt tools in Excel ● Use the Analysis ToolPak & Power Pivots to perform complex Data analysis ● Learn how to link and share workbooks for automatic updates WHO THIS BOOK IS FOR This book is for professionals from any domain, who are searching for shortcuts & advanced methods to resolve their daily problems. Table of Contents 1. Getting Started with Excel 2. Perform Functions with Shortcut Keys 3. Formulas and Functions 4. Data Visualization with New Chart types 5. Gantt and Milestone Chart 6. SmartArt & Organization Chart 7. Get creative with Icons, 3D models, Digital Inking 8. Putting Data in perspective with Pivots 9. Complex Data Analysis using ToolPak 10. Forecasting in Excel 11. Mail Merge using Excel 12. Create Custom Excel Template 13. Macros in Excel 14. Get help for your problem AUTHOR BIO Manisha Nigam is a seasoned management professional with twenty plus years of information technology experience, working with multinationals across the globe. Her expertise in Excel comes from the vast experience she has in using and understanding the software over the years, that helped her in working efficiently and managing complex programs. A certified PMP (PMI – Project Management Professional), CSM (Scrum Alliance – Scrum Master), TOGAF 9.1 (The Open Group – Enterprise Architecture) and holds a post graduate degree in computer science and business management from prestigious universities in India. Her LinkedIn Profile: linkedin.com/in/mnigam10

Everything you need to know about using Excel for finance and accounting functions KEY FEATURES ● Learn how to create financial models in Excel. ● Explore ways to use Excel functions and formulas for financial calculations. ● Implement advanced Excel techniques for finance and accounting tasks. DESCRIPTION Excel is a widely-used tool in finance and accounting, and this book provides a comprehensive guide on how to utilize it for maximum efficiency. The book covers basic to advanced Excel functions such as data manipulation, financial modeling, and scenario analysis. It also offers practical tips on how to create professional-looking reports, charts, and tables, which are essential in presenting financial data to stakeholders. With Excel's ever-evolving features and functions, it can be challenging for professionals to keep up with its latest updates. This book keeps you updated with the latest Excel features and offers practical examples of how to apply them in finance and accounting. Additionally, it offers tips on how to use Excel to automate repetitive tasks, freeing up more time for strategic analysis and decision-making. With this book, you can learn to leverage Excel to its full potential and gain a competitive advantage in your roles. WHAT YOU WILL LEARN ● Learn how to effectively manage financial data in Excel. ● Discover different techniques for preparing financial statements. ● Learn how to perform budget analysis in Excel. ● Learn how to create a forecast in Excel. ● Build dynamic dashboards and reports for financial data. WHO THIS BOOK IS FOR For individuals working in finance and accounting positions, whether at an entry-level or in senior management, this book is a must-have. It will enable professionals to enhance their productivity, precision, and effectiveness, resulting in significant savings of time and resources. TABLE OF CONTENTS 1. Getting Started with Advance Excel 2. Preparing Financial Statements Smartly 3. Calculating and Projecting Various Financial Ratios 4. Modeling Working Capital 5. Preparing Business Valuation Modeling 6. Financial Modeling and Cash Flow Modeling 7. Preparing Different Budgets With Analysis 8. Capital Budgeting and Leverage Buyout Modeling 9. Dashboards With Excel

500% improvement in productivity by automating tedious chores KEY FEATURES ● Contains numerous automation projects, including excel sheets, word documents, pdf files, websites, and messenger. ● Provides a strong understanding of Automation, its fundamentals, and strategies to implement it across organizations. ● Nurtures various techniques to improvise operational efficiency around repetitive business processes. DESCRIPTION Written by ZappyAI's founder, this book gives real-world examples of how readers can implement automation in their businesses and business-as-usual tasks. Through a series of real-world examples and live demonstrations, this book shows how to automate various tasks using Python scripts. This book gives solutions to everyday automation needs and repetitive tasks at work every day. Readers will be able to discover the most typical business process that can be automated and write simple Python scripts to turn them automated. This book will teach you how to create, read, change, and extract data from Excel documents using Python programming. Readers can extract data from websites, PDF documents, Gmail, Outlook, and WhatsApp chats. Text extraction from photos and scanned documents is also smartly accomplished in this book. The final section will examine techniques for extending your Python scripting skills and constructing complicated end-to-end process automation. Throughout the book, readers will be utterly captivated by how to automate their tedious tasks and enhance their organisations' productivity by 500 percent. WHAT YOU WILL LEARN ● Learn to write automation scripts by learning how to use different Python scripts. ● Find out how to look at the business process to automate it. ● Create, read, edit, and extract data from spreadsheets, documents, and PDFs. ● Control mouse and keyboard activities, as well as automate several desktop apps. ● Examine strategies for automating the downloading and extraction of data from the Internet and websites. ● Organize the real-time transfer and reading of Gmail, Outlook, and WhatsApp messages. WHO THIS BOOK IS FOR Software Engineers, Business Analysts, Automation Engineers, QA Engineers, and anyone who wants to simplify and automate their tedious work with simple yet powerful Python scripts. Readers with little or no technical experience can also use the strategies discussed in this book to automate day-to-day tasks. TABLE OF CONTENTS 1. Setting up the automation environment 2. Fundamentals of Python 3. Automation mindset – Python as a tool for automation 4. Automating Excel-based tasks 5. Automating Web-based tasks 6. Automating File-based tasks 7. Automating Email, Messenger Applications and Messages 8. GUI - Keyboard and Mouse Automation 9. Image based Automations 10. Creating Time and Event-based Automations 11. Writing Complex Automations

Cover Cover Copyright Contents Chapter 1: Introduction to Accounting Introduction Exploring the Concepts of Accounting Business Entity Concept Dual Aspect Concept Accounting Period Concept Cost Concept Money Measurement Concept Going Concern Concept Accrual Concept Matching Concept Understanding the Conventions of Accounting Convention of Full Disclosure Convention of Materiality Convention of Consistency Convention of Conservatism Important Accounting Terms Double Entry System Accounts and its Types Personal Account Impersonal Account Explaining the Rules of Debit and Credit Describing a Journal Types of Journal Entry Recording a Transaction in a Journal Defining a Compound Journal Entry Ledger Difference Between Journal and Ledger Essential Features of Ledger Advantages of Ledger Subdivision of Ledger Posting Transaction to a Ledger Balancing an Account Trial Balance Objectives of Trial balance Features of Trial Balance Advantages of a Trial balance Methods of Preparing a Trial Balance Limitation of Trial Balance Rectification of Errors in Trail Balance Locating Errors in Trial Balance Summary Chapter 2: Business Organisation Introduction Form of Business Organisations Sole Proprietorship Partnership Limited Liability Partnership Company Hindu Undivided Family-HUF Co-operative Society Trust Classification of Business Organisations (Trading Organisation (Sevice Organisation Manufacturing Organisation Summary Chapter 3: Understanding Financial Statements Introduction Purchases Direct Expenses Indirect Expenses Difference between Income and Expenditure Understanding Revenue from Operation Difference between Assets and Liabilities Describing Financial Statements Objectives of Financial Statements Types of Financial Statements Format of Financial Statement Format of Financial Statement for Sole Proprietor Format of Financial Statement for Company The Trading and Manufacturing Account Manufacturing Account The Profit & Loss Account Balance Sheet Difference between Profit & Loss Account and Balance Sheet Cash Flow Statement Method for Preparing Cash Flow Statement Advantages and Disadvantages of Cash Flow Statement Fund Flow Statement Method of Preparing Fund Flow Statement Preparing Statement of Changes in Working Capital Calculating Operating Income Preparing Fund Flow Statement Summary Chapter 4: Computerised Accounting (Introduction Exploring Computerised Accounting (Need of Computerised Accounting Merits of Computerised Accounting Demerits of Computerised Accounting Different Computerised Accounting Software Tally Busy Zoho Books Sage 50 Accounting QuickBooks Marg SAP Summary Chapter 5: Valuation of Inventory Introduction Inventory Method of Taking Inventory Periodic Inventory System (Perpetual Inventory System Methods of Inventory Valuation First In First Out Method - FIFO Last In First Out Method - LIFO Average Cost Method Standard Price Method Summary Chapter 6: Introduction to Tally.ERP 9 Introduction Salient Features of Tally.ERP 9 Technological Advantages of Tally.ERP 9 Installing Tally.ERP 9 Software Opening Tally.ERP 9 Application Fundamentals of Tally.ERP 9 Title Bar Horizontal Button Bar Gateway of Tally Screen Button Bar Product Information Bar Status Bar Mouse/Keyboard Conventions Switching between Screen Areas Quitting Tally.ERP 9 Application Creating a Company Selecting a Company Shutting a Company Deleting a Company (Company Features Company Configuration Summary Chapter 7: Creating Masters in Tally.ERP 9 Introduction Creating a Chart of Accounts Creating Accounting Masters in Tally.ERP 9 Groups Ledgers Creating Inventory Masters in Tally.ERP 9 Stock Group Stock Categories Godowns Units of Measurement Stock Items (Summary Chapter 8: Working with Vouchers Introduction Types of Vouchers Creating Voucher Type Displaying Voucher Type Altering Voucher Type Accounting Vouchers Receipt Voucher Payment Voucher Contra Voucher Journal Voucher Purchase Voucher Purchase Invoice Sales Voucher Sales Invoice Debit Note Credit Note Inventory Voucher Receipt Note Voucher Delivery Note Voucher Physical Stock Voucher Order Processing Voucher Purchase Order Processing Sales Order Processing Summary Chapter 9: Advanced Accounting Features Introduction Bill-wise Details Cost Categories Creating a Single Cost Category Displaying a Single Cost Category Altering a Single Cost Category Creating Multiple Cost Categories Displaying Multiple Cost Categories Altering Multiple Cost Categories Cost Centres Creating a Single Cost Centre Displaying a Single Cost Centre Altering a Single Cost Centre Creating Multiple Cost Centres Displaying Multiple Cost Centres (Altering Multiple Cost Centre Creating a Voucher using Cost Centres Budget Creating a Budget Altering a Budget Displaying a Budget Variance Report Interest Calculation Enabling the Interest Calculation Feature Creating Party Ledger Creating Sales Voucher Booking Interest to Ledger Accounts Bank Reconciliation Statement Understanding Scenario Management Configuring Settings for Scenarios Creating a Scenario Altering a Scenario Creating Optional Journal Voucher Using Scenarios in Reports Summary Chapter 10: Generating and Printing Reports in Tally.ERP 9 Introduction Financial Statements Balance Sheet Profit & Loss Account Trial Balance Day Book Accounting Books and Registers Cash Book Bank Book Purchase Register Sales Register (Inventory Books and Registers (Stock Summary Stock Item Summary Stock Group Summary Sales Orders Book Purchase Orders Book Stock Ageing Analysis (Stock Valuation Method Statements of Accounts Bills Receivable Bills Payable Cost Category Summary Report Management Information System (MIS) Reports Cash Flow Statement Fund Flow Statement Ratio Analysis Exception Report Printing Reports Type of Print Configuration Options Print Format Multi-Accounting Printing (Summary Chapter 11A: Tax Deducted at Source Introduction Tax Deduction Account Number How to Apply for TAN?) Variouses Sections and Rates of TDS Basic Terminologies of TDS Enabling TDS in Tally.ERP 9 Creating TDS Statutory Masters Greating Ledgers for TDS Creating Expense Ledger Creating Party Ledger Creating Tax Ledger Creating TDS Voucher Creating Journal Voucher for TDS on Expense Creating Payment Voucher Viewing TDS Report Viewing the Form 26Q Report Viewing the Form 27Q Report Reconciliation of Challan Payments TDS Outstandings Ledgers without PAN Summary Chapter 11B: Income Tax Introduction Income Tax Permanent Account Number Entities which can Apply for PAN (Structure of the PAN Applying for PAN Card Tracking Status of PAN Application Application for Changes/Correction/Modification/Update in PAN Card Details (Types of Income Taxpayers in India Various Heads of Income Under Income Tax Act Income from Salary Income from House Property Income from Profits of Business or Profession Income from Capital Gains Income from Other Sources Types of Income Tax Return (ITR) Forms ITR-1 or SAHAJ ITR-2 ITR-3 ITR-4 or Sugam ITR-5 ITR-6) ITR-7 Tax Deduction Under Income Tax from Total Income Tax Deductions Under Section 80C Tax Deduction Under Section 80D Tax Deduction Under Section 80E Tax Deduction Under Section 80G Tax Deduction Under Section 80IA Tax Deduction Under Section 80J Tax Deduction Under Section 80LA Tax Deduction Under Section 80P Tax Deduction Under Section 80QQB Tax Deduction Under Section 80RRB Tax Deduction Under Section 80TTA Tax Deduction Under Section 80U Tax Audit Under Section 44AB of Income Tax Act Objective of Tax Audit Who all are Covered Under Tax Audit? Defining Form 3CA/3CB and 3CD Due Date for Taxpayer to Audit Accounts Penalty for not Getting the Accounts Audited as Required by Section 44AB Limit of Cash Transaction E-filing the Income Tax Return Responding to Defective Return Notice under Section 139(9)) Responding to Income Tax Notice under Section 143(1)) Summary Chapter 12A: Goods and Services Tax Introduction Features of GST Benefits of GST Classification of GST CGST IGST SGST UTGST Administrative Bodies of GST Legal Phrases Used in GST Sections of Goods and Services Tax GST Rates in India Difference Between CGST, SGST and IGST Expenses Under GST Regime 3 Enrolling Under GST Registration under GST Amendments in Core and Non-core fields in Registration in GST Difference between Regular Dealer and Composition Dealer Supply Necessary Elements that Constitute Supply under GST Law Self Supply and GST Time of Supply Time of Continous Supply of Goods Liability to Pay GST in Respect of Supply of Services Supply of Services based on Invoice for Defined Time Time of Supply in Continuous Supply of Services (Place of supply Place of Supply of Goods Place of Supply for Services Payment of GST Methods of Paying Tax Meaning of Date of Receiving Payment Input Credit Tax Considering GST as Input Tax upon Paying Reverse Charge Necessary Conditions for Obtaining ITC) Time Limit for Taking ITC Order of Utilization Ineligible Input and Their Credits Reversal of ITC Input Services Distributior (ISD)) Prerequisites for Enrolling as ISD Conditions for Distribution of Credit Credit Distribution under ISD Electronic Commerce Meaning of Aggregator e-Commerce Opetator (Deduction/Deposit of TCS by e-Commerce Opetator) Mismatching of Details Return and Input Tax Credit Importance of Filling Return under GST Uploading Challans/Bills Annual Return and Final Return (Making Changes after Filling the Return) Filling Return by Taxpayer Periodicity of Return Filing Levy of and Exemption from Tax Taxable Person Power to Grant Exemption from Tax Tax Refund in GST Process to claim Refund under GST Advance Ruling Objective of Advance Ruling Authority for A.A.R. and A.A.A.R. under GST Applicability of Advance Ruling and its Time Period Nullifying the Advance Ruling Procedure for Obtaining Advance Ruling Circumstances for Rejecting Applications under Advance Ruling Meaning of Seacrh Basic Requirements to be Observed During Search Operations Meaning of Inspection Meaning of Reasons to Believe Search Warrant Meaning of Seizure Difference between Seizure and Detention Safety Provisions Provided under GST Law for Search or Seizure Meaning of Arrest Precautions to be Taken During Arrest Offence and Penalties General Penalties General Disciplines Related To Penalty Circumstances under which Goods are Seized Offences which can Lead to Warrant Prosecution under GST Law (Summary Chapter 12B: Practical in GST Introduction HSN and SAC Code E-Way Bill Purpose of E-way Bill Objectives of E-way Bill Features of E-way Bill Benefits of E-Way Bill E-Way Bill under GST People Who Need E-Way Bill Participants of E-Way Bill Validity of E-way Bill Cancellation of E-way Bill Exceptions for E-way Bill Penalties on Issuing Wrong E-way Bill Mixed and Composite Supply under GST) Bill of Supply and Invoice Contents of invoice Contents of Bill of Supply Debit Note under GST Credit Note under GST GST Compliances Checklist (Switching in GST Deposit Tax in GST Summary Chapter 13: Working with GST in Tally.ERP 9 Introduction Enabling GST and Setting GST Details in Tally.ERP 9 Creating Tax Classification in GST Creating Masters for GST Creating Central Tax Ledger Creating State Tax Ledger Creating Party Ledger Creating Purchase Ledger Creating Sales Ledger Creating Service Ledger Creating Stock Item Creating Vouchers for GST Creating Purchase Voucher Creating Sales Voucher Creating Sales Voucher for Providing Services Creating Receipt Voucher for Advance Receipts from Customer Creating Payment Voucher Recording Voucher for Advance Payments to Supplier Creating Journal Voucher for Tax Adjustment Updating Party GSTIN Viewing GSTR-1 Report Viewing GSTR-3B Report (Summary Chapter 14A: Introducing Tax Return Preparer (TRP) Introduction Tax Return Preparer (TRP TRP Scheme Role of TRP Pre-requisite of TRP TRP Examination TRP Training Duties of TRP Incentive of TRP Resource Centre Some Cautious Points for TRP Do’s and Don’ts of TRP Summary Chapter 14B: Introducing GST Practitioner Introduction) GST Practitioner Section 48 of CGST Act, 2017 – GST Practitioners (Roles of GST Practitioner Eligibility Criteria for GST Practitioner GST Practitioner Registration Process GST Practitioner Exam Validity of GST Practitioner Certificate Benefits of GST Practitioner Summary Chapter 14C: Cashless Transaction Introduction Meaning of Cashless Transactions Different Ways of Making Cashless Transactions Cheque (Demand Draft Online Transactions through NEFT and RTGS Credit Card Debit Card Digital Wallet or E-Wallet (Mobile Wallet UPI App BHIM App Gift Cards Aadhaar Enabled Payment System (AEPS)) Unstructured Supplementary Service Data (USSD)) Summary Chapter 15: Basics of Other Relevant Miscellaneous acts Introduction ESI Act Benefits for the Employer Benefits for the Employee (EPF Act Applicability Definition of Wages Eligibility Provident Fund Contribution Gratuity Act Application to Whom and in What Manner [Section 7] Determination by Employer [Section 7] Payment of Gratuity (Tax on Gratuity Amount (Nomination Administrative Machinery Responsibility of the Employees Payment of Bonus Act (Eligibility Objective Definitions Payment of Bonus Act not to Apply to Certain Classes of Employees [Section 32] Micro, Small and Medium Enterprises Development (MSMED) Act) Definition of Micro, Small and Medium Enterprises(MSME)) Benefits to the MSME’s Registration IE Code Key Features of IE Code Procedure for obtaining IE Code Procedures of Incorporation of a Company Business Registration Number (BRN) Process Definitions of Business and Business Register (Scope and Coverage Shop & Establishment Act Premises Regulated by the Shop & Establishment Act) Aspects Regulated by Shop and Establishment Act Shop and Establishment Act License) (Summary Chapter6 16: Introduction to MS Excel 2010 (Introduction Defining the Need for MS Excel (Understanding Workbook and Worksheet Starting MS Excel 2010 Application Exploring the Ribbon Entering Data in a Worksheet Adjusting Column Width of Cells Saving a Workbook Closing a Workbook and Quitting MS Excel 2010 Application Summary Chapter 17: Using Functions in MS Excel Introduction Understanding Cell Referencing Relative Cell Referencing Absolute Cell Referencing Mixed Cell Referencing Basic Concepts Used in a Function Getting Information about a Function Syntax of a Function (Entering a Formula in a Cell Applying a Formula by Using the Copy and Paste Method Applying a Formula by Using the Auto Fill Feature Editing a Formula Copying Value Instead of a Formula Working with the Commonly Used Functions PRODUCT Function SUM Function AVERAGE Function Creating Your Own Function Printing a Worksheet Printing a Worksheet on a Single Page (Printing a Large Worksheet Summary About the CD