Microsoft Excel

AI Patasala is a pioneer institute for Data Science Artificial Intelligence Headed by real-time training experts, we offer the Best Online Courses with Certification

Free Excel 2019 Basic quick reference with shortcuts, tips, and tricks. Free to distribute!

Excel isn't only for business. Here are several Microsoft Excel formulas that will help you solve complex daily problems.

View ContentsThree core functions of ExcelUnderstanding Excel InterfaceExcel Interface labeled diagramExcel tools and featuresWorking with Excel – BasicsCells, Columns and RowsNavigating from one cell to anotherEntering the recordEditing the existing recordFetching contents of another cellTutorials on Excel WorkingFormatting and handling DataTutorials Specific to Home TabTutorials on Number FormattingTutorials on Tables/Conditional FormattingTutorials on Data EditingMaking changes […]

Get your hands on the Advanced VLOOKUP Cheat Sheet, which contains all the tips and tricks to take your VLOOKUP skills to the next level.

Our friends over at filtered.com have provided a handy Excel Shortcut info-graphic going over some popular Excel shortcuts. Hope you enjoy:

Learn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus Many More! With this book, you'll learn to apply the must know Excel Formulas & Functions to make your data analysis & reporting easier and will save time in the process. With this book you get the following: ✔ 101 Ready Made Formulas Covering: LOOKUP, LOGICAL, MATH, STATISTICAL, TEXT, DATE, TIME & INFORMATION ✔ Easy to Read Step by Step Guide with Color Screenshots ✔ Downloadable Practice Workbooks for each Formula with Solutions ✔ Interactive & Searchable E-Book to find any Formula with ease ✔ New Excel Formulas For Excel 2019 & Office 365 This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Excel Formulas FAST & stand out from the crowd!