Excel 2013 In Depth


Book Description

Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets Get more productive with Excel 2013’s new Start Screen and Timelines Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens Quickly apply attractive, consistent formats Master every function you’ll ever need,- including powerful new web services functions Solve real-world business intelligence analysis problems Create amazing PowerPivot data mashups that integrate information from anywhere Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations Share workbooks on the Web and social networks Leverage the improved Excel Web App to create highly interactive web pages and online surveys Automate repetitive functions using Excel macros Supercharge your workbooks with new apps from the Excel App Store Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!




Python for Excel


Book Description

While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. In fact, it's the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein--creator of xlwings, a popular open source package for automating Excel with Python--shows experienced Excel users how to integrate these two worlds efficiently. Excel has added quite a few new capabilities over the past couple of years, but its automation language, VBA, stopped evolving a long time ago. Many Excel power users have already adopted Python for daily automation tasks. This guide gets you started. Use Python without extensive programming knowledge Get started with modern tools, including Jupyter notebooks and Visual Studio code Use pandas to acquire, clean, and analyze data and replace typical Excel calculations Automate tedious tasks like consolidation of Excel workbooks and production of Excel reports Use xlwings to build interactive Excel tools that use Python as a calculation engine Connect Excel to databases and CSV files and fetch data from the internet using Python code Use Python as a single tool to replace VBA, Power Query, and Power Pivot




Web Scraping with Excel


Book Description

The art of web scraping with Microsoft Excel can be intimidating to non-programmers and beginners. This book, however, demonstrates that this skill can be learned quickly and effectively with the right knowledge and practice. Beginners, aspiring VBA developers, and experienced programmers alike will find valuable lessons, tips, and tricks in this simple yet concise guide that can help master this valuable skill which continues to be in high demand.




M Is for (Data) Monkey


Book Description

Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.




Web Scraping with Python


Book Description

Learn web scraping and crawling techniques to access unlimited data from any web source in any format. With this practical guide, you’ll learn how to use Python scripts and web APIs to gather and process data from thousands—or even millions—of web pages at once. Ideal for programmers, security professionals, and web administrators familiar with Python, this book not only teaches basic web scraping mechanics, but also delves into more advanced topics, such as analyzing raw data or using scrapers for frontend website testing. Code samples are available to help you understand the concepts in practice. Learn how to parse complicated HTML pages Traverse multiple pages and sites Get a general overview of APIs and how they work Learn several methods for storing the data you scrape Download, read, and extract data from documents Use tools and techniques to clean badly formatted data Read and write natural languages Crawl through forms and logins Understand how to scrape JavaScript Learn image processing and text recognition




Hands-On Web Scraping with Python


Book Description

Collect and scrape different complexities of data from the modern Web using the latest tools, best practices, and techniques Key Features Learn different scraping techniques using a range of Python libraries such as Scrapy and Beautiful Soup Build scrapers and crawlers to extract relevant information from the web Automate web scraping operations to bridge the accuracy gap and manage complex business needs Book DescriptionWeb scraping is an essential technique used in many organizations to gather valuable data from web pages. This book will enable you to delve into web scraping techniques and methodologies. The book will introduce you to the fundamental concepts of web scraping techniques and how they can be applied to multiple sets of web pages. You'll use powerful libraries from the Python ecosystem such as Scrapy, lxml, pyquery, and bs4 to carry out web scraping operations. You will then get up to speed with simple to intermediate scraping operations such as identifying information from web pages and using patterns or attributes to retrieve information. This book adopts a practical approach to web scraping concepts and tools, guiding you through a series of use cases and showing you how to use the best tools and techniques to efficiently scrape web pages. You'll even cover the use of other popular web scraping tools, such as Selenium, Regex, and web-based APIs. By the end of this book, you will have learned how to efficiently scrape the web using different techniques with Python and other popular tools.What you will learn Analyze data and information from web pages Learn how to use browser-based developer tools from the scraping perspective Use XPath and CSS selectors to identify and explore markup elements Learn to handle and manage cookies Explore advanced concepts in handling HTML forms and processing logins Optimize web securities, data storage, and API use to scrape data Use Regex with Python to extract data Deal with complex web entities by using Selenium to find and extract data Who this book is for This book is for Python programmers, data analysts, web scraping newbies, and anyone who wants to learn how to perform web scraping from scratch. If you want to begin your journey in applying web scraping techniques to a range of web pages, then this book is what you need! A working knowledge of the Python programming language is expected.




Introduction to Research Methods


Book Description

The Second Edition of Introduction to Research Methods: A Hands-On Approach by Bora Pajo continues to make research easy to understand and easy to construct. Covering both quantitative and qualitative methods, this new edition lays out the differences between research approaches so readers can better understand when and how to use each research design. Through clear, simple, and even humorous prose, this text offers students a straightforward introduction to a new world of social science research. Rather than making research seem intimidating, Introduction to Research Methods shows students that research is an ongoing conversation concerning topics that matter in their lives, a conversation that′s easy to understand and easy to join. The new edition features updated chapters on qualitative designs and qualitative data analysis, a new chapter on big data and digital methods, and updated citation and report styles for APA Style 7th Edition. This title is accompanied by a complete teaching and learning package in SAGE Vantage, an intuitive learning platform that integrates quality SAGE textbook content with assignable multimedia activities and auto-graded assessments to drive student engagement and ensure accountability. Unparalleled in its ease of use and built for dynamic teaching and learning, Vantage offers customizable LMS integration and best-in-class support.




Learn Excel 2007 from Mr Excel


Book Description

Covers how to effectively use Microsoft Excel using examples of real-world business problems.




Python Automation Cookbook


Book Description

Get a firm grip on the core processes including browser automation, web scraping, Word, Excel, and GUI automation with Python 3.8 and higher Key FeaturesAutomate integral business processes such as report generation, email marketing, and lead generationExplore automated code testing and Python’s growth in data science and AI automation in three new chaptersUnderstand techniques to extract information and generate appealing graphs, and reports with MatplotlibBook Description In this updated and extended version of Python Automation Cookbook, each chapter now comprises the newest recipes and is revised to align with Python 3.8 and higher. The book includes three new chapters that focus on using Python for test automation, machine learning projects, and for working with messy data. This edition will enable you to develop a sharp understanding of the fundamentals required to automate business processes through real-world tasks, such as developing your first web scraping application, analyzing information to generate spreadsheet reports with graphs, and communicating with automatically generated emails. Once you grasp the basics, you will acquire the practical knowledge to create stunning graphs and charts using Matplotlib, generate rich graphics with relevant information, automate marketing campaigns, build machine learning projects, and execute debugging techniques. By the end of this book, you will be proficient in identifying monotonous tasks and resolving process inefficiencies to produce superior and reliable systems. What you will learnLearn data wrangling with Python and Pandas for your data science and AI projectsAutomate tasks such as text classification, email filtering, and web scraping with PythonUse Matplotlib to generate a variety of stunning graphs, charts, and mapsAutomate a range of report generation tasks, from sending SMS and email campaigns to creating templates, adding images in Word, and even encrypting PDFsMaster web scraping and web crawling of popular file formats and directories with tools like Beautiful SoupBuild cool projects such as a Telegram bot for your marketing campaign, a reader from a news RSS feed, and a machine learning model to classify emails to the correct department based on their contentCreate fire-and-forget automation tasks by writing cron jobs, log files, and regexes with Python scriptingWho this book is for Python Automation Cookbook - Second Edition is for developers, data enthusiasts or anyone who wants to automate monotonous manual tasks related to business processes such as finance, sales, and HR, among others. Working knowledge of Python is all you need to get started with this book.




Automated Data Collection with R


Book Description

A hands on guide to web scraping and text mining for both beginners and experienced users of R Introduces fundamental concepts of the main architecture of the web and databases and covers HTTP, HTML, XML, JSON, SQL. Provides basic techniques to query web documents and data sets (XPath and regular expressions). An extensive set of exercises are presented to guide the reader through each technique. Explores both supervised and unsupervised techniques as well as advanced techniques such as data scraping and text management. Case studies are featured throughout along with examples for each technique presented. R code and solutions to exercises featured in the book are provided on a supporting website.