Excel Basic

Outline: Outline
Cheat Sheet:
Reading Material:

No.ModulesSharing
1
  • Excel Structure
  • Navigating in Excel
  • Ribbon and Tabs
  • Quick Access Toolbar (QAT)
  • Dialogue Box and Task Panes
  • Customizing Ribbons and QAT
  • Active Cell
  • Ctrl and Alt Shortcut keys
2
  • Data Entry
  • Modifying Cell Content
  • Deleting Data
  • Replacing Data
  • Editing Data
  • Introduction to Autofill
  • Introduction to Number Formatting
3
  • Accessing Formatting Tools
  • Formatting Tools
  • Format Painter
  • Named Styles
4
  • Cell Address Nomenclature
  • Selecting Cell/Range
  • Copying and Moving Cells/Ranges
  • Paste Special
  • Select Special Cells (Go To Special)
  • Using Find and Replace to Select Cells
  • Adding Comments to Cells
  • Quick Analysis
5
  • Navigating Through Worksheets
  • Changing Worksheet Name and Color
  • Adding/Deleting and Hiding/Un-hiding Worksheets
  • Moving and Copying Worksheets
  • Worksheet Views
  • Saving and Opening Workbooks
6
  • Autofill
  • Custom Lists
7
  • Accessing Number Formatting Options
  • Number Formatting Using Dialogue Box
  • Custom Number Formatting
8
  • Constituents of Excel Formula
  • Operators in Formula
  • Entering Formula
  • Editing Formula
  • Absolute/Relative Cell References
  • Copying/Pasting Formula
  • Formula Auditing and Debugging

Recommanded Books
TitleExcel Cookbook: Recipes for Mastering Microsoft Excel
ISBN978-1-098-14332-9
AuthorDawn Griffiths
Year2024
Publisher O'Reilly Media
TitleExcel Made Easy
ISBN
AuthorSeth Wallington
Year2024
Publisher
TitleMastering Microsoft Excel: From Novice to Pro in One Book
ISBN979-8-871-91659-9
AuthorChandan Kumar
Year2024
Publisher Independently Published
TitleThe Excel Book Of The Dead: Bring Your Sheets Back To Life
ISBN979-8-875-63296-9
AuthorBisette, Vincent; Van Der Post, Hayden
Year2024
Publisher Reactive Publishing
TitleMastering Microsoft Excel From Beginner to Expert
ISBNB0CW1BLTPR
AuthorSkipton Tech
Year2024
Publisher
TitleExcel: Mastering Data Analysis, Visualization, and Automation for Success with Microsoft 365
ISBNB0CK66LTDN
AuthorSAM O.A
Year2023
Publisher SA-Publishing
TitleData Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More
ISBN979-8-852-38845-2
AuthorAlex Holloway
Year2023
Publisher Independently published
TitleEssential Guide to Microsoft Excel for All Levels (2024 Collection: Forging Ahead in Tech and Programming)
ISBNB0CM1XBVQV
AuthorO., Adeolu
Year2023
Publisher
TitleBeginning Excel 2019
ISBN979-8-483-76402-1
AuthorNoreen Brown
Year2021
Publisher ndependently published
TitleExcel 2019 Project Book
ISBN978-1-683-92769-3
AuthorGary Bronson
Year2021
Publisher Mercury Learning and Information
TitleA Definitive Guide to Microsoft Excel 2019
ISBNB086BD7B6P
AuthorDerrick Richard
Year2020
Publisher
TitleExcel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)
ISBNB07TZ6FTG9
AuthorGeorge, Nathan
Year2020
Publisher
TitleExcel 2019: A Quick and Complete Guide to Master Spreadsheets, and Boosting Productivity. (Quick Ctrl Guides)
ISBNB087PPTVQN
AuthorGrey, Jonathan
Year2020
Publisher
TitleEssential Excel 2019: A Step-By-Step Guide
ISBN978-1-484-26208-5
AuthorDavid Slager, Annette Slager
Year2019
Publisher Apress
TitleExploring Data with Excel 2019
ISBNB08M6G7YKC
AuthorRockoff, Larry
Year2019
Publisher Deep Dive Press
TitleAdvanced Analytics with Excel 2019: Perform Data Analysis Using Excel’s Most Popular Features (English Editions)
ISBN978-9-389-84580-8
AuthorManisha Nigam
Year2019
Publisher BPB Publications
TitleExcel 2019 business basics & beyond
ISBN978-1-615-47061-7
AuthorChris Blanton Smith
Year2020
Publisher Holy Macro! Books
TitleTeach Yourself VISUALLY Excel 2016
ISBN978-1-119-07473-1
AuthorPaul McFedries
Year2016
Publisher Visual