Microsoft Excel

The Excel 2023 User Experience

• Excel 2023’s Sleek Look and Feel
• Excel’s Start Screen
• Excel’s Ribbon User Interface
• Getting Help
• Launching and Quitting Excel

Customizing Excel 2023

• Tailoring the Quick Access Toolbar to Your Tastes
• Exercising Your Options
• Using Office Add-ins
• Using Excel’s Own Add-ins

Building Worksheets

• Designer Spreadsheets
• It Takes All Kinds (Of Cell Entries)
• Data Entry 101
• Saving the Data
• Document Recovery to the Rescue

Formatting Worksheets

• Making Cell Selections
• Adjusting Columns and Rows
• Formatting Tables from the Ribbon
• Formatting Tables with the Quick Analysis Tool
• Formatting Cells from the Ribbon
• Formatting Cell Ranges with the Mini-Toolbar
• Using the Format Cells Dialog Box
• Hiring Out the Format Painter
• Using Cell Styles
• Conditional Formatting

Editing and Proofing Worksheets

• Opening a Work Session
• Cell Editing 101
• A Spreadsheet with a View
• Copying and Moving Stuff Around
• Find and Replace This Disgrace!
• Spell Checking Heaven
• Looking Up and Translating Stuff
• Marking Invalid Data
• Eliminating Errors with Text to Speech

Managing Worksheets

• Reorganizing the Worksheet
• Reorganizing the Work Session
• Working with Multiple Work Sessions
• Consolidating Worksheets

Printing Worksheets

• Printing from the Excel 2023 Backstage View
• Quick Printing the Worksheet
• Working with the Page Setup Options
• Using the Print Options on the Sheet tab of the Page Setup dialog box
• Headers and Footers
• Solving Page Break Problems
• Printing the Formulas in a Report

Building Basic Formulas

• Formulas 101
• Copying Formulas
• Adding Array Formulas
• Range Names in Formulas
• Adding Linking Formulas
• Controlling Formula Recalculation
• Circular References

Logical Functions and Error Trapping

• Understanding Error Values
• Using Logical Functions
• Error-Trapping Formulas
• Whiting-Out Errors with Conditional Formatting
• Formula Auditing
• Removing Errors from the Printout

Date and Time Formulas

• Understanding Dates and Times
• Using Date Functions
• Using Time Functions

Financial Formulas

• Financial Functions 101
• The PV, NPV, and FV Functions
• The PMT Function
• Depreciation Functions
• Analysis Tool Pak Financial Functions

Math and Statistical Formulas

• Math & Trig Functions
• Statistical Functions
• Lesson # 6 : Lookup, Information, and Text Formulas
• Lookup and Reference
• Information, Please …
• Much Ado about Text

Protecting Work Sessions and Worksheet Data

• Password-Protecting the File
• Protecting the Worksheet

 Using Hyperlinks

• Hyperlinks 101
• Using the HYPERLINK Function

Preparing a Work Session for Distribution

• Getting Your Work Session Ready for Review
• Annotating Work Sessions

Sharing Work Sessions and Worksheet Data

• Sharing Your Work Sessions Online
• Excel 2023 Data Sharing Basics
• Exporting Work Sessions to Other Usable File Formats

Charting Worksheet Data

• Worksheet Charting 101
• Adding Sparkline Graphics to a Worksheet
• Adding Infographics to a Worksheet
• Printing Charts

Adding Graphic Objects

• Graphic Objects 101
• Inserting Different Types of Graphics
• Drawing Graphics
• Adding Screenshots of the Windows 10 Desktop
• Using Themes

Building and Maintaining Data Lists

• Data List Basics
• Sorting Data
• Subtotaling Data

Filtering and Querying a Data List

• Data List Filtering 101
• Filtering Data
• Using the Database Functions
• External Data Query

Performing What-If Scenarios

• Using Data Tables
• Exploring Different Scenarios
• Hide and Goal Seeking
• Using the Solver

Performing Large-Scale Data Analysis

• Creating Pivot Tables
• Formatting a Pivot Table
• Sorting and Filtering the Pivot Table Data
• Modifying the Pivot Table
• Creating Pivot Charts
• Using the Power Pivot Add-in
• Using the 3D Map feature
• Creating Forecast Worksheets

Recording and Running Macros

• Macro Basics
• Assigning Macros to the Ribbon and the Quick Access Toolbar
• Macro Security

VBA Programming

• Using the Visual Basic Editor
• Creating Custom Excel Functions