+(254) 769 090 623
support@multilabcreatives.com
Categories
English flag
English
$
USD
0
English flag
English
$
USD
0
Explore All Courses icon
Explore All Courses
Microsoft Excel in Easy Steps: Microsoft 365 Guide

Microsoft Excel in Easy Steps: Microsoft 365 Guide

  • Microsoft Excel in Easy Steps is a 194-page illustrated PDF guide that teaches Excel for Microsoft 365 from the ground up. Learn workbooks, formulas, functions, tables, charts and macros through clear, numbered steps.
$2.50

Quantity

Buy with 20 points
Send Product as Gift

Send as a gift to friends

Get Cashback
Buy this product to earn $0.25 as cashback.

About This Product

Learn Microsoft Excel, step by step

Microsoft Excel in Easy Steps is a 194-page, full-colour PDF guide to spreadsheets in Microsoft 365. Each topic is a short, numbered walkthrough with screenshots, so you can follow along in your own workbook.

What you will learn

  • Build and format workbooks: enter data, fill cells, format text and numbers, and print cleanly.
  • Write formulas and functions with relative, absolute and named references, and fix common formula errors.
  • Organise data with Excel tables, sorting, filters, duplicate removal, frozen headers and worksheet protection.
  • Use the function library: logical, lookup, financial, date, text, math and statistical functions.
  • Create charts, from 3-D column and pie charts to stock and mixed charts, and print them ready to share.
  • Record, edit and debug macros with VBA, and explore templates, What-If Analysis, Goal Seek and Solver.

A practical reference for students, office professionals, small-business owners and anyone moving from spreadsheet basics to confident Excel use.

See the Specifications tab for the full chapter list, requirements and publication details.

Microsoft Excel in Easy Steps is an independent educational publication. It is not affiliated with, sponsored by or endorsed by Microsoft. Microsoft and Excel are trademarks of Microsoft Corporation.

Product Specifications

Publisher
AcademyLab
Edition
1st
ISBN / Catalogue ID
MLC-EX-2026-6294
Pages
194
Language
English
Format
PDF ebook (instant download)
Subject
Microsoft Excel, spreadsheets and data analysis
Skill level
Beginner to intermediate
Delivery
Instant download after purchase from your AcademyLab account

Requirements

Microsoft Excel (Microsoft 365 recommended) and a PDF reader. Basic computer and file-management skills are helpful; no prior spreadsheet experience is required.

Contents

11 chapters in this ebook. Expand any chapter to see the topics covered.

1. Introduction
  • The Spreadsheet Concept
  • Microsoft Excel
  • Microsoft 365
  • System Requirements
  • Getting Excel
  • Excel and Windows
  • The Excel Ribbon
  • Exploring Excel
  • Excel Online App
2. Begin with Excel
  • The Excel Window
  • Create a Workbook
  • Add Data to the Worksheet
  • Build the Worksheet
  • Fill Cells
  • Complete the Worksheet
  • Format the Text
  • Format the Numbers
  • Print the Worksheet
  • Insert, Copy, and Paste
  • Excel Help
  • Contextual Help
  • Excel File Formats
3. Manage Data
  • Use Existing Data
  • Import Data
  • Navigate the Worksheet
  • Scroll with the Mouse Wheel
  • Keystrokes and Touch
  • Sort Rows
  • Find Entries
  • Filter Information
  • Remove Duplicate Entries
  • Check Spelling
  • Freeze Headers and Labels
  • Hide Columns or Rows
  • Protect a Worksheet
4. Formulas and Functions
  • Number Formats
  • Text Formats
  • Relative References
  • Absolute References
  • Name References
  • Operators
  • Calculation Sequence
  • Functions
  • AutoSum
  • Formula Errors
  • Add Notes
5. Excel Tables
  • Create an Excel Table
  • Edit Tables
  • Table Styles
  • Table Totals
  • Count Unique Entries
  • Structured References
  • Calculated Columns
  • Insert Rows
  • Custom Sort
  • Print a Table
  • Summarize a Table
  • Convert to a Range
6. Advanced Functions
  • Function Library
  • Logical Functions
  • Lookup/Reference Functions
  • Financial Functions
  • Date & Time Functions
  • Text Functions
  • Math & Trig Functions
  • Random Numbers
  • Statistical Functions
  • Engineering Functions
  • Excel Add-ins
  • Evaluate Formula
7. Control Excel
  • Audit Formulas
  • Protect Formulas
  • Check for Errors
  • Backup
  • AutoSave and AutoRecover
  • Startup Switches
  • Create a Shortcut
  • Ribbon Key Tips
  • Using Key Tips
  • Collapse the Ribbon
  • Quick Access Toolbar
  • Mini Toolbar
  • Print Worksheets
8. Charts
  • Create a Chart
  • Recommended Chart Type
  • Change Chart Layout
  • Legend and Data Table
  • Change Chart Type
  • Pie Chart
  • 3-D Pie Chart
  • 3-D Column Chart
  • Share Price Data
  • Line Chart
  • Stock Chart
  • Mixed Types
  • Print Charts
9. Macros in Excel
  • Macros
  • Create Macros
  • Record a Macro
  • Apply the Macro
  • View the Macro
  • Macro to Make a Table
  • Edit the Macro
  • Use the Macro
  • Create Macros with VBA
  • Add Macros to the Toolbar
  • Debug Macros
10. Templates and Scenarios
  • Templates
  • Online Templates
  • More Excel Resources
  • What-If Analysis
  • Summary Reports
  • Goal Seek
  • Optimization
  • Project Worksheet
  • Solver
11. Links and Connections
  • Link to Workbooks
  • Create External References
  • Styles of Reference
  • Source Workbook Changes
  • Apply Updates
  • Turn Off the Prompt
  • Save Workbook Online
  • Using the Excel Online App
  • Excel in Word
  • Publish as PDF (or XPS)

FAQs

View frequently asked questions about this product

How do I learn Microsoft Excel step by step as a beginner?
This 194-page illustrated PDF starts with the Excel window and your first workbook, then builds up through formatting, formulas, Excel tables and charts. Every topic is a short numbered walkthrough with screenshots, so you can follow along in Excel while you read.
Which version of Microsoft Excel does this ebook cover?
Microsoft Excel in Easy Steps is illustrated using Excel in Microsoft 365. The steps use the standard desktop ribbon, so they match current Microsoft 365 desktop installations; Excel for the web and very old Excel versions may look different.
Does the ebook cover Excel formulas, functions, tables and charts?
Yes. Chapter 4 covers number and text formats, relative, absolute and named references, operators, AutoSum and formula errors. Chapter 5 covers Excel tables and structured references, Chapter 6 covers the function library, and Chapter 8 walks through column, pie, line, stock and mixed charts.
Is this Excel ebook suitable for work and office jobs?
Yes. The manual focuses on practical spreadsheet skills used in offices and small businesses: building and formatting workbooks, organising and filtering data, summarising with tables, reporting with charts, and automating repetitive tasks with recorded macros and VBA.
How do I download the Excel ebook after purchase?
The PDF is attached to your paid ebook purchase in AcademyLab. Sign in to your account and use the download access provided through the existing purchase-entitlement system.
Reply to Comment
Comments Approval

Your comment will be visible after admin approval.

0
0 Reviews
Product Quality (0)
Value for Money (0)
Delivery Quality (0)
Seller Quality (0)
Reply to Review
Submit Reply

Your reply to this review will be visible to all users.

The Ultimate Digital Hub
More from MultiLab Creatives
Artificial Intelligence for Beginners

Artificial Intelligence for ...

Technology & Computing
Android Complete Manual

Android Complete Manual

Technology & Computing