Excel: 2020 User Manual to Learn the Basics of Excel Fast and Use It Effectively with Smart Method. 25 Essential Tips & Tricks Included

Excel can be more than a grid for storing numbers. Allan Gedsbury’s beginner-oriented manual explains the spreadsheet basics, interface terms, and everyday commands that help make the program easier to approach. It also introduces Excel Online and gathers practical tips for navigating worksheets and working with files.

Get oriented in Excel

The guide names the parts of the interface readers encounter as they work: the Ribbon, Backstage view, Quick Access Toolbar, Name Box, Formula Bar, cells, columns, and sheets. It also covers selecting commands with a mouse, keyboard, or touch, then shows how the Quick Access Toolbar can be customized.

Explore Excel Online

One chapter considers Excel’s online version, outlining its features and differences from the desktop program. Topics listed include editing and formatting cells, calculations, filtering, tables, OneDrive synchronization, and sharing documents.

Keep useful shortcuts close

The tips-and-tricks chapter includes Excel function keys and keyboard shortcuts for moving around a worksheet. It also addresses moving between workbook sheets, using the onscreen keyboard and scroll bars, and finding help through “Tell Me.”

From percentages to file export

Alongside navigation advice, the contents point to explanations of calculating percentages and interest, compatibility mode, converting files, and exporting an Excel workbook to PDF or other file types. The emphasis is on foundational tasks and helpful interface habits, not advanced data analysis.

A starting point for new spreadsheet users

Readers who are new to Excel or want a straightforward orientation to its main controls may appreciate the manual’s practical spread of topics. One detail to note: although the title identifies the book as a 2020 manual, its contents label the interface chapter “Excel 2019.”