Basic Microsoft Excel tutorials

5 Essential Excel Tips Everyone Should Know

Excel is a powerful tool used across various industries, and mastering its features can significantly boost your productivity. In this blog post, we'll explore five essential Excel tips that every user should know.

Excel Focus Cell: Enhancing Active Cell Visibility and Navigation

Microsoft Excel has introduced an exciting new feature called Focus Cell, designed to improve the visibility of the active cell and enhance navigation within spreadsheets. This powerful tool highlights the current cell's row and column, making it easier to track your position in large datasets.

Excel 7 Easy Tips Everyone Should Know

Excel is a powerful tool that can significantly enhance productivity when used effectively. Here, we present seven time-saving Excel tips that will help you work more efficiently.

Copilot In Excel: NEW Feature Enables Copilot Use Without a Table

Copilot in Excel has introduced some exciting new features that are designed to enhance your productivity. Copilot in Excel handles sorting, conditional formatting, pivottables, and asking questions. You can now do this without having a Table.

Discover Excel New Features: A Guide to 6 Exciting Updates in Excel for the Web

Explore six exciting new features in Excel for the Web that streamline workflows and boost productivity. Discover how these updates can transform your data management.

Essential Excel Keyboard Shortcuts for Selecting Data

Join me as I guide you through essential keyboard shortcuts to quickly select ranges in Excel. Discover the power of Ctrl, Shift, Home, End, and arrow keys to enhance your productivity. I'll share tips for navigating data efficiently, dealing with blanks, utilizing tables, and selecting large ranges with ease.

Oct 28, 2024 - I'll be Speaking at the Administrative Professionals Conference on Excel Copilot: Data Analysis Simplified

I'll be speaking at ASAP's Administrative Professional Conference in Aurora, CO on October 28, 2024. My deep dive session will be on Excel Copilot: Data Analysis Simplified

Sep 28, 2024 - Excel Training for Executive MBA Students at the University of Georgia

I'll be speaking on September 28,2024 to the Executive MBA students from The University Of Georgia's Terry College of Business. We will cover many Excel topics including Financial Analysis in Excel.

Optimizing Microsoft Excel Files for Better Performance

Excel has a new feature called Check Performance. Check Performance will determine if your workbook is slow and optimize performance.

Excel Business Functions - Functions everyone should know - Excel Essentials Training

Did you know that there are over 500 Functions in Excel? In this short video, part of my Excel Essentials Training Course, we look at the seven business functions I use all the time, and these functions should be used by every Excel user.

Excel Print Options - Set Print Area, Print Selection, Margins, and Printing Gridlines

Excel has many print options. We will look at setting the Print Area, Print Selection, working with Margins, Printing Gridlines, and Printing Row and Column headings. This is part of my Excel Essentials training course, available in July 2023!

Excel Page Break Preview and Inserting Page Breaks - Excel Essentials

Excel has three views in the status bar - Normal, Page Layout, and Page Break Preview. We will look at using Page Break Preview to move and lose page breaks and using the Insert Tab to Insert Page Breaks and Reset All Page Breaks. These commands are part of my Excel Essentials Course.