Skillshareallen

Microsoft Excel - Up to Speed

Learn Microsoft Excel fast! Master spreadsheets with this beginner-friendly course. Get up to speed with the latest features and boost your productivity.

301students
10h 28m
Certificate
Roger Hyttinen
Roger HyttinenInstructor

Course Content

Microsoft Excel - Up to Speed is an all-levels Skillshare course taught by Roger Hyttinen. It runs 10h 28m, is taught in English, and includes a certificate of completion. 301 students have enrolled. It is a paid course, first published May 2020.

Master Microsoft Excel: From Beginner to Advanced User

Unlock the power of Microsoft Excel with this comprehensive course designed to take you from spreadsheet novice to confident user. This step-by-step training starts with the fundamentals and progresses to advanced techniques, empowering you to boost productivity and analyze data effectively.

What You'll Learn:

  • Excel Basics:
    • Navigate the Excel interface: learn to open, save, and manage workbooks and worksheets.
    • Master cell ranges: select, enter, and manipulate data within cells.
    • Formulas & Functions: Understand and utilize basic formulas, AutoSum, and essential functions like MIN, MAX, COUNT, and AVERAGE.
    • Data Entry & Editing: Learn to enter text, numbers, and special symbols; find and replace data; and utilize spellcheck.
  • Worksheet Formatting & Design:
    • Customize cell appearance: format text, values, borders, colors, and styles.
    • Page Setup & Printing: Control margins, orientation, paper size, headers, footers, and print ranges.
    • Worksheet Views: Freeze panes, hide/unhide rows/columns, and manage page breaks.
  • Advanced Worksheet Management:
    • Workbooks & Worksheets: Add, delete, copy, rename, and organize worksheets.
    • 3D Formulas & References: Utilize advanced referencing techniques for complex calculations.
    • Templates: Create and utilize Excel templates for efficient data entry.
    • Workbook Security: Protect workbooks with passwords, lock/unlock cells, and manage sharing permissions.
  • Data Visualization with Charts:
    • Create & Customize Charts: Generate various chart types (pie, map, funnel) and customize their appearance.
    • Chart Layouts & Styles: Apply professional styles and customize chart elements.
    • Dynamic Charts: Link charts to data, create templates, and move charts between workbooks.
  • Enhance with Graphics:
    • Insert Images & Shapes: Add images, shapes, icons, and 3D objects to your spreadsheets.
    • Drawing Tools: Modify and format drawing objects, add organization charts, SmartArt, and WordArt.
    • Hand Drawings & Equations: Incorporate hand-drawn elements and complex equations.
  • Collaboration & Sharing:
    • Share Workbooks: Email workbooks, preview as webpages, and insert hyperlinks.
    • Comments & Tracking: View, edit, and manage comments within workbooks.
  • Powerful Formulas & Functions:
    • Financial Functions: Master functions like IF, IFS, PMT, and FV for financial calculations.
    • Date & Time Functions: Work with dates, date intervals, and time calculations.
    • AutoCalculate: Perform on-the-fly calculations.
  • Data Analysis & Manipulation:
    • Working with Tables: Create, format, sort, and filter data within tables.
    • PivotTables: Analyze data with PivotTables, Slicers, and Timelines.
    • Data Validation: Ensure data accuracy with data validation rules.
    • Error Checking: Trace precedents and dependents, fix errors, and create error checks.
    • Goal Seek, Solver & Scenario Manager: Find optimal solutions and analyze "what-if" scenarios.
    • Data Tables & Forecast Sheets: Predict future values and analyze formula impacts.
  • Import & Export Data:
    • Import Data: Bring data from text files, databases, and other applications.
    • Export Data: Export data to various file formats, including webpages.
    • Data Conversion: Convert text to columns and remove duplicate rows.
    • Linking & Embedding: Link to and embed objects from other files.
  • Advanced Excel Techniques:
    • Named Ranges: Define and utilize named ranges in formulas.
    • VLOOKUP Function: Lookup data from table arrays.
    • Macros: Automate repetitive tasks with macros.
    • Quick Analysis: Utilize the Quick Analysis feature for data summarization.

Who is this course for?

  • Beginners: Individuals new to spreadsheets and Microsoft Excel.
  • Intermediate Users: Excel users looking to enhance their skills and learn advanced features.
  • Professionals: Anyone seeking to improve data analysis, reporting, and productivity.

Ready to take control of your data? Let's get started!

My Promise to You: I'm committed to your success. Feel free to ask questions and provide feedback throughout the course. I'm here to help you master Microsoft

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(234)
1h 36m
all
skillshare
skillshare
5.0(122)
3h 38m
all
skillshare