# How do you turn on formula suggestions in Excel for Mac?

1. All topics

Preview

## Skills youll gain

• Microsoft Excel

## Earn a sharable certificate

Share what youve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

### Learning      LinkedIn Learning     Certificate of Completion

Share as image online to demonstrate your skill

## Learner reviews

### 4.9 out of 5                                                   71 ratings                 How are ratings calculated?         The overall rating is calculated using the average of submitted ratings. Ratings and reviews can only be submitted when non-anonymous learners complete at least 40% of the course. This helps us avoid fake reviews and spam.

• 5 star Current value: 65                       91%
• 4 star Current value: 6                       8%                                               Don Don

## Contents

• Introduction Introduction
• Master the formulas and functions of Excel for Mac                      1m 6s
• 1. Formula and Function Tools 1. Formula and Function Tools
• Write formulas using a hierarchy of operators                      4m 19s
• Save time with AutoSum, AutoCalc, and extended features                      4m 18s
• Absolute, Relative, and Mixed references                      5m 57s
• 2. IF and Related Functions 2. IF and Related Functions
• Use relational operators and IF logical tests                      4m 48s
• Create and expand nested IF functions                      4m
• Create compound logical tests using AND and OR functions with IF                      6m 1s
• 3. Lookup and Reference Functions 3. Lookup and Reference Functions
• Look up information with VLOOKUP, HLOOKUP, and XLOOKUP (365)                      2m 20s
• Find approximate matches with XLOOKUP and VLOOKUP (365)                      5m 9s
• Find exact matches with XLOOKUP and VLOOKUP (365)                      3m 48s
• Extended uses of XLOOKUP (365)                      4m 50s
• Retrieve information by location with INDEX                      2m 30s
• Identify the presence of data with MATCH and XMATCH (365)                      5m 38s
• 4. Statistical Functions 4. Statistical Functions
• Use MEDIAN for middle value, MODE for most frequent                      3m 40s
• Tabulate blank cells with COUNTBLANK                      2m 46s
• Use COUNT, COUNTA, and the status bar                      3m 9s
• Tabulate with COUNTIF, SUMIF, and AVERAGEIF                      4m 57s
• Tabulate with COUNTIFS, SUMIFS, and AVERAGEIFS                      4m 5s
• 5. Math Functions 5. Math Functions
• Decimal rounding with ROUND, ROUNDUP, and ROUNDDOWN                      5m 51s
• Other rounding with MROUND, CEILING, and FLOOR                      4m
• Generate random values with RAND, RANDBETWEEN, and RANDARRAY (365)                      5m 50s
• Bypass errors and hidden data with AGGREGATE                      5m 5s
• 6. Date and Time Functions 6. Date and Time Functions
• Use dates and times in Excel formulas                      5m 9s
• Use TODAY and NOW for dynamic date and time entry                      3m 51s
• Identify the day of the week with WEEKDAY                      3m 38s
• Working days with NETWORKDAYS and WORKDAY                      4m 39s
• Tabulate date differences with DATEDIF                      4m 18s
• 7. Text Functions 7. Text Functions
• Locate data with FIND and SEARCH                      5m 36s
• Extract specific data with LEFT, RIGHT, and MID                      2m 22s
• Remove extra spaces with TRIM                      4m 29s
• Use ampersand (&), CONCAT, and TEXTJOIN to combine cell data                      6m 4s
• Adjust case within cells using the PROPER, UPPER, and LOWER                      3m 38s
• Conclusion Conclusion
• Continue your Excel journey                      23s

## Whats included

• Practice while you learn    1 exercise file
• Learn on the go    Access on tablet and phone

37m

1h 59m