DARREN TROFIMCZUK
  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact

Excel Basics

 Part 1 YouTube Excel file (Excel basics)
Uploaded 1st February 2021
excel_example_youtube.xlsx
File Size: 12 kb
File Type: xlsx
Download File


Basic Tasks in Microsoft Excel Link:
https://support.office.com/en-us/article/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca
Creating a Workbook
Entering Data
Cell Reference (absolute, relative, and mixed): Click Here for detailed explanation
Editing (adding and removing columns & rows)
Formatting
Simple Formula & Autosum
Excel Keyboard Shortcuts:
http://www.excelfunctions.net/Excel-Keyboard-Shortcuts.html


** SPREADSHEET CLASS TASK SHEET 1 **

*All spreadsheet tasks must be completed using Excel offline

Video Tutorials (Workbooks, Saving & Printing, Inserting Columns & Rows, Formulae):
https://support.office.microsoft.com/en-us/article/Create-your-first-Excel-2013-workbook-ea173bff-ff4c-476f-9c1f-3768acb9c8db
  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact