Excel for IT & Technology 4

What's inside

Excel for IT & Technology 4: 14 courses, 280 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 14 complete courses, 280 lessons, 280 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Algorithms by the Numbers: Counting Steps, Growth Rates, Binary Search, Sorting Comparisons, Hash Table Load & Caching
• Game Development Math: Vectors & Movement, Frame-Rate Independence, Easing Curves, Collision Checks, Damage Formulas & Difficulty Curves
• Operating System Scheduling by Hand: FCFS, Shortest Job First, Round Robin, Priorities, Page Replacement & Disk Scheduling
• Error Detection & Correction by Hand: Parity Bits, Check Digits, Checksums, CRC Division & Hamming Codes
• Video Surveillance Storage & Bandwidth Sizing: Cameras, Bitrates, Motion Recording, Retention Days, Disks & Network Load
• CPU Caches by Hand: Address Bits, Direct-Mapped & Set-Associative Caches, Hit/Miss Traces, Average Memory Access Time & Multi-Level Caches
• Load Balancing & Hashing by Hand: Round Robin, Weighted & Least-Connections Rules, Hash Mod N, Consistent Hashing Rings & Capacity Headroom
• Dynamic Programming by Hand: Overlapping Subproblems, Memo Tables, Coin Change, Knapsack, Longest Common Subsequence & Grid Paths
• Data Structures by Hand: Arrays, Stacks, Queues & Ring Buffers, Linked Lists, Binary Heaps, Search Trees and Sorting Passes
• How Blockchains Work by Hand: Ledgers, Toy Hashes & Chained Blocks, Merkle Trees, Proof-of-Work Targets, Difficulty Adjustment, Unspent Outputs & Fee Markets
• 3D Graphics by Hand: Vertex Tables, Rotations, Camera Space, Perspective Projection, Screen Mapping, Back-Face Culling, Depth Buffers & Flat Shading
• Programming Logic by Hand: Variables, Trace Tables, Conditions, Loops, Arrays & Strings, Functions, Recursion and Debugging Off-by-One Errors
• Python Fundamentals by Hand: Types & Operators, Floor Division & Modulo, String Indexing & Slicing, Lists & Aliasing, Dictionaries, Sets, Comprehensions and Sorting with Keys
• Unit Test Design by Hand: Equivalence Partitions, Boundary Values, Decision Tables, Statement & Branch Coverage, Path Counts, Mutation Scores, Flaky Tests and Test-Suite Time Budgets

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	745
Series	The Tabellab Workbook, volume 4
Author	Babala Özdemir
Delivery	Instant download after payment