اکسل ۲۰۱۹: راهنمای سریع و کامل برای تسلط بر صفحات گسترده و افزایش بهره‌وری (راهنماهای سریع Ctrl)

Mastering Excel Has Never Been so Quick! Does the thought of working in spreadsheets make your head spin? Do you find it extremely hard to work in Excel? Do you want to sharpen your Excel skills with all the functions and formulas quickly? If so, then keep reading. Excel is an established powerful tool for businesses, but many people find it complicated, or they don't make the most of it, because they don't know how to use all its functions effectively. They end up spending hours on simple calculations that can be done with one or two functions. Furthermore, Excel has so many unexplored tools, even by more advanced users, that if applied correctly can make a difference in terms of productivity. This book bridges this knowledge gap in a simple yet effective way. It is one of its kind book that cuts right to the chase and gives a step-by-step guide to master excel functions and formulas and many other features. Here's a small sampling of things you will learn with this book: Useful Excel shortcuts that make your work easier Simple ways to analyze your data thoroughly Creating pivot tables and charts to present your data visually Creating Budget plans and calculating all types of payments Creating VBA in Excel to automate various tasks Filter and sorting data Using functions and formulas like IF, DATE, DATEDIF, LEN, MID, and VLOOKUP Business Modelling, and much more! So, whether you are a beginner and you want to jumpstart your understanding of Excel, or you already know how to use the software and want to take your skills to the next level, this book will help you boost the productivity of your business. CHAPTER ONE WHAT IS EXCEL Where are the Pieces on Your Worksheet? What are the Characteristics of the Workbook? Why does Excel Store Worksheets for You? How Many Worksheets Can be Created in a Single Workbook? CHAPTER TWO OPENING EXCEL WORKSHEET HOME TAB Home Tab Themes Group: PAGE LAYOUT Formula Tab Data Tab IMPORTING EXTERNAL DATA Where Do You Decide to Put the Data? SORTING DATA LISTS CHAPTER THREE EXCEL FUNCTIONS: LOGICAL AND TEXT EXCEL FUNCTIONS EXAMPLES OF EXCEL FUNCTIONS COMPATIBILITY FUNCTIONS DATABASE FUNCTIONS INFORMATION FUNCTIONS LOGICAL FUNCTIONS LOOKUP AND REFERENCE FUNCTIONS CHAPTER FOUR ENTERING DATA Create a New Ribbon Tab. FORMATTING CELLS Apply Excel Styles ENTERING FORMULAS CALIBRATING COLUMNS COPYING FORMULAS WITH AUTOFILL CHAPTER FIVE TIPS AND TRICKS SHORTCUTS FOR WINDOWS AND MAC SIMPLE WAYS TO MANAGE YOUR DATA Data Storage Data analysis Multi-user collaboration Security SIMPLE WAYS TO ANALYZE YOUR DATA PRACTICAL APPLICATIONS HOW TO CREATE AN INVOICE HOW TO CREATE A BUDGET PLAN HOW TO CREATE A CREDIT CALCULATING HOW TO CALCULATE CREDIT PAYMENTS IN EXCEL INTEREST CALCULATION FORMULA FOR LOANS IN EXCEL THE CALCULATION OF THE EFFECTIVE INTEREST RATE IN EXCEL CONCLUSION GLOSSARY