دانلود کتاب Excel Workbook: 160 Exercises with Solutions and Comments

فهرست مطالب :

Description Biography Title Copyright Table of Contents PREFACE PLAN OF THE WORKBOOK SECTION 1. EXERCISES UNIT 1. EXCEL BASICS EXERCISE 1.1 - Quarterly sales EXERCISE 1.2 - Four elections EXERCISE 1.3 - Income EXERCISE 1.4 - Cinema EXERCISE 1.5 - Courses EXERCISE 1.6 - Population by age EXERCISE 1.7 - Sales data EXERCISE 1.8 - Exams EXERCISE 1.9 - Balance sheet EXERCISE 1.10 - TV shows EXERCISE 1.11 - Cigarettes EXERCISE 1.12 - Families EXERCISE 1.13 - Beer and wine EXERCISE 1.14 - Three elections EXERCISE 1.15 - Athletics EXERCISE 1.16 - Bills EXERCISE 1.17 - Turnover analysis EXERCISE 1.18 - US and foreign sales EXERCISE 1.19 - Rainfall EXERCISE 1.20 - UFO EXERCISE 1.21 - Accidents EXERCISE 1.22 - Music sales EXERCISE 1.23 - Seven dwarfs EXERCISE 1.24 - Expenses EXERCISE 1.25 - Three musketeers EXERCISE 1.26 - Murders EXERCISE 1.27 - City council EXERCISE 1.28 - Parliamentary groups EXERCISE 1.29 - Regional chief towns EXERCISE 1.30 - Population (summary exercise) UNIT 2. FROM SIMPLE FUNCTIONS TO NESTED FUNCTIONS EXERCISE 2.1 - Home loans EXERCISE 2.2 - Internet users EXERCISE 2.3 - Top sellers EXERCISE 2.4 - Alphabet Inc. EXERCISE 2.5 - Show EXERCISE 2.6 - Productivity EXERCISE 2.7 - Customer care EXERCISE 2.8 - Istat EXERCISE 2.9 - Planets (summary exercise) EXERCISE 2.10 - Home Sweet Home (summary exercise) UNIT 3. MATH FUNCTIONS AND ADVANCED CHARTS EXERCISE 3.1 - Drugstores EXERCISE 3.2 - Men at work EXERCISE 3.3 - Car Insurances EXERCISE 3.4 - Exam EXERCISE 3.5 - Clothing Store EXERCISE 3.6 - Beauty Business EXERCISE 3.7 - Cosmetics Shop EXERCISE 3.8 - International Education EXERCISE 3.9 - Dinner with classmates (summary exercise) EXERCISE 3.10 - Wages (summary exercise) UNIT 4. FINANCIAL FUNCTIONS AND WHAT-IF ANALYSIS EXERCISE 4.1 - Emerald EXERCISE 4.2 - Smart Courses EXERCISE 4.3 - Credits and debts EXERCISE 4.4 - Cloth Paradise EXERCISE 4.5 - Discount on rates EXERCISE 4.6 - Smart Investments Bank EXERCISE 4.7 - Garden Center (summary exercise) EXERCISE 4.8 - GreenBio (summary exercise) EXERCISE 4.9 - PhotoMagic (summary exercise) EXERCISE 4.10 - Bright Sun (summary exercise) UNIT 5. TEXT FUNCTIONS AND PIVOT TABLES EXERCISE 5.1 - IBAN codes EXERCISE 5.2 - Names EXERCISE 5.3 - Superstore EXERCISE 5.4 - Beauty EXERCISE 5.5 - Europe sales EXERCISE 5.6 - Erasmus EXERCISE 5.7 - Vitanic EXERCISE 5.8 - Office Line EXERCISE 5.9 - Greenwich Village (summary exercise) EXERCISE 5.10 - Black-yellow supporters (summary exercise) UNIT 6. MANAGING DATES AND TIMES EXERCISE 6.1 - Two hours EXERCISE 6.2 - Timesheet EXERCISE 6.3 - Date check EXERCISE 6.4 - Linguistic certifications EXERCISE 6.5 - Techno Building EXERCISE 6.6 - Hotel Booking EXERCISE 6.7 - My Friends EXERCISE 6.8 - Temporary workers EXERCISE 6.9 - Payments (summary exercise) EXERCISE 6.10 - Stationery (summary exercise) UNIT 7. LOOKUP & REFERENCE FUNCTIONS, DATA PROTECTION EXERCISE 7.1 - Rocky Sports EXERCISE 7.2 - Property Evaluation EXERCISE 7.3 - Copy shop EXERCISE 7.4 - Paper and related EXERCISE 7.5 - Purchasing Department EXERCISE 7.6 - DoReMi EXERCISE 7.7 - Thinkstore EXERCISE 7.8 - Print Service EXERCISE 7.9 - European University EXERCISE 7.10 - Consulteam EXERCISE 7.11 - Candidates selection EXERCISE 7.12 - MagicWood EXERCISE 7.13 - Phone calls (summary exercise) EXERCISE 7.14 - Box Office Star (summary exercise) EXERCISE 7.15 - Sunshine Events (summary exercise) UNIT 8. MACROS AND ELEMENTS OF VBA EXERCISE 8.1 - Students EXERCISE 8.2 - Tickets EXERCISE 8.3 - Product list EXERCISE 8.4 - Stores EXERCISE 8.5 - Household linens EXERCISE 8.6 - Arithmetic EXERCISE 8.7 - Airbnb EXERCISE 8.8 - Filtered data EXERCISE 8.9 - Deliveries EXERCISE 8.10 - Subtotals EXERCISE 8.11 - Table EXERCISE 8.12 - Worksheet protection EXERCISE 8.13 - Chart axis EXERCISE 8.14 - Table template EXERCISE 8.15 - Alternate rows EXERCISE 8.16 - Sales chart EXERCISE 8.17 - Add worksheets EXERCISE 8.18 - Sales pivot EXERCISE 8.19 - Insert rows EXERCISE 8.20 - Stock Exchange (summary exercise) UNIT 9. MORE FUNCTIONS AND SOLVER EXERCISE 9.1 - Hot deals EXERCISE 9.2 - Blue Vision EXERCISE 9.3 - Gold EXERCISE 9.4 - Personal loan EXERCISE 9.5 - New car EXERCISE 9.6 - Gluten-free products EXERCISE 9.7 - Condo fees EXERCISE 9.8 - Car purchase EXERCISE 9.9 - Promotional Campaign EXERCISE 9.10 - German course EXERCISE 9.11 - Overtime EXERCISE 9.12 - Home video EXERCISE 9.13 - Hotel Eden (summary exercise) EXERCISE 9.14 - TechMind contest (summary exercise) EXERCISE 9.15 - PluriPlast (summary exercise) UNIT 10. DATABASE FUNCTIONS AND CHART OPTIONS EXERCISE 10.1 - Payroll office EXERCISE 10.2 - Sport shoes EXERCISE 10.3 - Budget EXERCISE 10.4 - District competition EXERCISE 10.5 - Admission office EXERCISE 10.6 - Distributors EXERCISE 10.7 - Car dealer EXERCISE 10.8 - Fruit & Vegetables EXERCISE 10.9 - Albert Einstein EXERCISE 10.10 - SEFCO (summary exercise) UNIT 11. FINANCIAL APPLICATIONS EXERCISE 11.1 - Premium Bonds EXERCISE 11.2 - Coupon&Coupon EXERCISE 11.3 - FRN EXERCISE 11.4 - Reverse floater EXERCISE 11.5 - Capital budgeting EXERCISE 11.6 - Super Leasing EXERCISE 11.7 - Stock performance EXERCISE 11.8 - Stock analysis EXERCISE 11.9 - Regression EXERCISE 11.10 - Market Analysis (summary exercise) UNIT 12. DATA ANALYSIS AND REPORTING EXERCISE 12.1 - Turnover EXERCISE 12.2 - Orders EXERCISE 12.3 - Gifts EXERCISE 12.4 - Product IDs EXERCISE 12.5 - Counties and offices EXERCISE 12.6 - Variable period EXERCISE 12.7 - Choose your category EXERCISE 12.8 - Chart with bands EXERCISE 12.9 - Scroll bar EXERCISE 12.10 - Dashboard (summary exercise) SECTION 2. COMMENTS AND FUNCTIONS COMMENTS AND FUNCTIONS UNIT 1 EXERCISE 1.1 - Quarterly sales (commented) EXERCISE 1.2 - Four elections (commented) EXERCISE 1.3 - Income (commented) EXERCISE 1.4 - Cinema EXERCISE 1.5 - Courses (commented) EXERCISE 1.6 - Population by age (commented) EXERCISE 1.7 - Sales data (commented) EXERCISE 1.8 - Exams (commented) EXERCISE 1.9 - Balance sheet EXERCISE 1.10 - TV shows EXERCISE 1.11 - Cigarettes EXERCISE 1.12 - Families EXERCISE 1.13 - Beer and wine EXERCISE 1.14 - Three elections EXERCISE 1.15 - Athletics (commented) EXERCISE 1.16 - Bills EXERCISE 1.17 - Turnover analysis EXERCISE 1.18 - US and foreign sales (commented) EXERCISE 1.19 - Rainfall (commented) EXERCISE 1.20 - UFO EXERCISE 1.21 - Accidents EXERCISE 1.22 - Music sales (commented) EXERCISE 1.23 - Seven dwarfs EXERCISE 1.24 - Expenses (commented) EXERCISE 1.25 - Three musketeers EXERCISE 1.26 - Murders EXERCISE 1.27 - City council (commented) EXERCISE 1.28 - Parliamentary groups EXERCISE 1.29 - Regional chief towns (commented) EXERCISE 1.30 - Population (commented) COMMENTS AND FUNCTIONS UNIT 2 EXERCISE 2.1 - Home loans (commented) EXERCISE 2.2 - Internet users (commented) EXERCISE 2.3 - Top sellers (commented) EXERCISE 2.4 - Alphabet Inc. EXERCISE 2.5 - Show EXERCISE 2.6 - Productivity EXERCISE 2.7 - Customer care EXERCISE 2.8 - ISTAT (commented) EXERCISE 2.9 - Planets (commented) EXERCISE 2.10 - Home Sweet Home (commented) COMMENTS AND FUNCTIONS UNIT 3 EXERCISE 3.1 - Drugstores (commented) EXERCISE 3.2 - Men at work (commented) EXERCISE 3.3 - Car insurances (commented) EXERCISE 3.4 - Exam EXERCISE 3.5 - Clothing Store EXERCISE 3.6 - Beauty Business EXERCISE 3.7 - Cosmetics Shop EXERCISE 3.8 - International Education EXERCISE 3.9 - Dinner with classmates (commented) EXERCISE 3.10 - Wages (commented) COMMENTS AND FUNCTIONS UNIT 4 EXERCISE 4.1 - Emerald (commented) EXERCISE 4.2 - Smart Courses (commented) EXERCISE 4.3 - Credits and debts (commented) EXERCISE 4.4 - Cloth Paradise EXERCISE 4.5 - Discount on rates EXERCISE 4.6 - Smart Investments Bank EXERCISE 4.7 - Garden Center (commented) EXERCISE 4.8 - GreenBio EXERCISE 4.9 - PhotoMagic (commented) EXERCISE 4.10 - Bright Sun COMMENTS AND FUNCTIONS UNIT 5 EXERCISE 5.1 - IBAN codes (commented) EXERCISE 5.2 - Names (commented) EXERCISE 5.3 - Superstore (commented) EXERCISE 5.4 - Beauty (commented) EXERCISE 5.5 - Europe sales EXERCISE 5.6 - Erasmus EXERCISE 5.7 - Vitanic EXERCISE 5.8 - Office Line EXERCISE 5.9 - Greenwich Village EXERCISE 5.10 - Black-yellow supporters (commented) COMMENTS AND FUNCTIONS UNIT 6 EXERCISE 6.1 - Two hours (commented) EXERCISE 6.2 - Timesheet (commented) EXERCISE 6.3 - Date check (commented) EXERCISE 6.4 - Linguistic Certifications EXERCISE 6.5 - Techno Building EXERCISE 6.6 - Hotel booking (commented) EXERCISE 6.7 - My friends EXERCISE 6.8 - Temporary workers (commented) EXERCISE 6.9 - Payments (commented) EXERCISE 6.10 - Stationery (commented) COMMENTS AND FUNCTIONS UNIT 7 EXERCISE 7.1 - Rocky Sports (commented) EXERCISE 7.2 - Property evaluation (commented) EXERCISE 7.3 - Copy shop EXERCISE 7.4 - Paper and related (commented) EXERCISE 7.5 - Purchasing Department EXERCISE 7.6 - DoReMi EXERCISE 7.7 - Thinkstore EXERCISE 7.8 - Print Service EXERCISE 7.9 - European University EXERCISE 7.10 - Consulteam EXERCISE 7.11 - Candidates selection EXERCISE 7.12 - MagicWood EXERCISE 7.13 - Phone calls (commented) EXERCISE 7.14 - Box Office Star EXERCISE 7.15 - Sunshine Events (commented) COMMENTS AND FUNCTIONS UNIT 8 EXERCISE 8.1 - Students (commented) EXERCISE 8.2 - Tickets (commented) EXERCISE 8.3 - Product list (commented) EXERCISE 8.4 - Stores (commented) EXERCISE 8.5 - Household linens EXERCISE 8.6 - Arithmetic (commented) EXERCISE 8.7 - Airbnb (commented) EXERCISE 8.8 - Filtered data (commented) EXERCISE 8.9 - Deliveries (commented) EXERCISE 8.10 - Subtotals EXERCISE 8.11 - Table (commented) EXERCISE 8.12 - Worksheet protection (commented) EXERCISE 8.13 - Chart axis (commented) EXERCISE 8.14 - Table template (commented) EXERCISE 8.15 - Alternate rows (commented) EXERCISE 8.16 - Sales chart (commented) EXERCISE 8.17 - Add worksheets (commented) EXERCISE 8.18 - Sales pivot (commented) EXERCISE 8.19 - Insert rows (commented) EXERCISE 8.20 - Stock Exchange (commented) COMMENTS AND FUNCTIONS UNIT 9 EXERCISE 9.1 - Hot deals (commented) EXERCISE 9.2 - Blue Vision (commented) EXERCISE 9.3 - Gold (comment) EXERCISE 9.4 - Personal loan (commented) EXERCISE 9.5 - New car EXERCISE 9.6 - Gluten-free products EXERCISE 9.7 - Condo fees EXERCISE 9.8 - Car purchase EXERCISE 9.9 - Promotional campaign (commented) EXERCISE 9.10 - German course EXERCISE 9.11 - Overtime EXERCISE 9.12 - Home video EXERCISE 9.13 - Hotel Eden (commented) EXERCISE 9.14 - TechMind contest EXERCISE 9.15 - Pluriplast COMMENTS AND FUNCTIONS UNIT 10 EXERCISE 10.1 - Payroll office (commented) EXERCISE 10.2 - Sport shoes (commented) EXERCISE 10.3 - Budget (commented) EXERCISE 10.4 - District competition (commented) EXERCISE 10.5 - Admission office EXERCISE 10.6 - Distributors EXERCISE 10.7 - Car dealer EXERCISE 10.8 - Fruit and vegetables EXERCISE 10.9 - Albert Einstein EXERCISE 10.10 - SEFCO (commented) COMMENTS AND FUNCTIONS UNIT 11 EXERCISE 11.1 - Premium Bonds EXERCISE 11.2 - Coupon&Coupon EXERCISE 11.3 - FRN EXERCISE 11.4 - Reverse floater EXERCISE 11.5 - Capital budgeting EXERCISE 11.6 - Super leasing EXERCISE 11.7 - Stock performance (commented) EXERCISE 11.8 - Stock analysis EXERCISE 11.9 - Regression EXERCISE 11.10 - Market Analysis (commented) COMMENTS AND FUNCTIONS UNIT 12 EXERCISE 12.1 - Turnover EXERCISE 12.2 - Orders EXERCISE 12.3 - Gifts EXERCISE 12.4 - Product IDs EXERCISE 12.5 - Countries and offices EXERCISE 12.6 - Variable period EXERCISE 12.7 - Choose your category EXERCISE 12.8 - Chart with bands EXERCISE 12.9 - Scroll bar EXERCISE 12.10 - Dashboard (commented) AUTHORS