Udemybeginneren

A beginners guide to Excel

Learn Excel basics! This beginner-friendly course covers essential skills and explores what Excel can do for you. Perfect for anyone starting out.

4.6(332)
4,699students
1h
Warren Thomas
Warren ThomasOwner / Consultant at Featherbrooke Consulting Services

Course Content

A beginners guide to Excel is a beginner-level Udemy course taught by Warren Thomas. It runs 1h and is taught in English. Learners rate it 4.6 out of 5 from 332 reviews, with 4,699 students enrolled. It is free to enroll, first published March 2020.

Master Microsoft Excel: A Complete Beginner's Guide

This course provides a comprehensive introduction to Microsoft Excel, designed for absolute beginners with no prior experience. Learn to navigate the Excel interface and unlock its powerful features quickly and efficiently. We'll cover every menu item in detail, showing you what each one does and how to use it effectively. Get familiar with Excel functionality in the shortest possible time!

Course Overview:

  • 1. Introduction:

    • Introduction PPT: A visual overview to kickstart your Excel journey.
    • Overview of Microsoft Excel: Understand the core concepts and capabilities of Excel.
    • Overview of the sample data: Familiarize yourself with the data sets we'll be using throughout the course.
  • 2. File Menu: Learn essential file management skills.

    • How to open and save a workbook: Master opening existing files and saving your work.
    • How to print a workbook: Learn to prepare your spreadsheets for printing.
  • 3. Home Menu: Essential tools for data manipulation and formatting.

    • Cut, Copy and Paste: Efficiently move and duplicate data.
    • Formatting font, colours and alignment: Enhance the visual appeal of your spreadsheets.
    • Change formats to number, text, date etc: Format data accurately for analysis and reporting.
    • What is conditional formatting?: Automatically highlight important data based on specific criteria.
    • Insert and delete rows and columns: Easily adjust the structure of your spreadsheets.
    • Intro to formulas: Begin learning the basics of creating formulas for calculations.
    • Sorting and filtering data: Organize and analyze large datasets.
  • 4. Insert Menu: Add visuals and data enhancements.

    • Tables and Pivot tables: Create structured data tables and powerful summaries.
    • Images and illustrations: Enhance your spreadsheets with visual elements.
    • Charts and sparklines: Visualize data effectively with various chart types.
    • Other insert ribbon options: Explore additional options for adding content.
  • 5. Page Layout Menu: Control the appearance and layout of your worksheets.

    • Themes: Apply pre-designed styles to your spreadsheets.
    • Page setup: Customize page margins, orientation, and size.
    • Change formats to number, text, date etc: Format data accurately for reporting.
    • Other page layout ribbon options: Fine-tune your worksheet layout.
  • 6. Data Menu: Powerful tools for data management and analysis.

    • Data sources: Connect to external data sources.
    • Sorting and filtering: Organize and analyze large datasets.
    • Data tools: Utilize data cleaning and transformation tools.
    • Other data ribbon options: Explore advanced data manipulation features.
  • 7. Review Menu: Ensure accuracy and collaboration.

    • Proofing: Check spelling and grammar.
    • Comments and notes: Add notes and comments for collaboration.
    • Other review ribbon options: Utilize tools for tracking changes and comparing versions.
  • 8. View Menu: Customize your workspace for optimal productivity.

    • Workbook views: Switch between different views like Print Layout, Web Layout, and Slide Show.
    • Freeze and split panes: Keep important sections of your spreadsheet visible.
    • Other view ribbon options: Customize your view settings.
  • 9. Help Menu, Add-ins & Where to go from here: Resources for support and further learning.

    • Help: Access Excel's built-in help documentation.
    • Add-ins: Explore and install add-ins to extend Excel's functionality.
    • Course review: A summary of key concepts covered in the course.
    • Where to go from here: Resources for continued learning and advanced Excel skills.
$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

skillshare
5.0(413)
3h 45m
beginner
skillshare
5.0(673)
8h 32m
all
skillshare
5.0(1,333)
2h 34m
beginner
skillshare