Please note that the questions may test on, but will not be limited to, the topics described below.
Links to Microsoft videos and articles are provided below for many of the exam topics. Some of these articles have different instructions depending on the version of Excel being used. If multiple sets of instructions are listed, make sure to select Windows rather than MacOS or Web, and/or Office 365/2019 or Newer Versions rather than Office 2016 or earlier.
Links in the See Also section at the bottom of each skillset group may also be helpful.
Create formulas (formula basics, about the formula bar)
Excel formulas and functions tutorials