Short Introduction to MS Office Excel
- Length: 29 pages
- Edition: 1
- Language: English
- Publication Date: 2021-01-04
- ISBN-10: B08RYCQNJY
- Sales Rank: #3468 (See Top 100 Books)
The book is part of a series that include MBA Core & Elective coursework taught at prestigious universities like Harvard and Wharton. The series consist of Core & Elective courses that stemmed from more than ten years of professional experience in Wall Street and Startups. The elective courses introduce Machine Learning, Python, Blockchain and Cryptocurrencies, Communications skills, R language, Excel advanced features, PowerPoint advanced features, interview questions, and more.
Introduction to Excel Preface I.INTRODUCTION II.VLOOKUP Exact Match Vlookup Looks Right III.INDEX MATCH Match Function Index Index and Match IV.INDIRECT FUNCTION Cell Reference Range Reference V.PIVOT TABLES Insert Pivot Table Two-dimensional Pivot Table Insert Pivot Chart VI.IFERROR, ISERROR IfError IsError VII.ADVANCED FILTER AND criteria OR criteria Formula as Criteria VIII.GOAL SEEK IX.Visual Basic for Applications (VBA) Enable Developer Option Program in VBA X.POWER BUSINESS INTELLIGENCE (Power BI) Power Map Power Pivot Power View XI.Reference & Sources
Donate to keep this site alive
To access the Link, solve the captcha.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.