Cov txheej txheem:

Yuav ua li cas kuv thiaj li tau txais kev tsom xam ToolPak hauv Excel rau Mac?
Yuav ua li cas kuv thiaj li tau txais kev tsom xam ToolPak hauv Excel rau Mac?

Video: Yuav ua li cas kuv thiaj li tau txais kev tsom xam ToolPak hauv Excel rau Mac?

Video: Yuav ua li cas kuv thiaj li tau txais kev tsom xam ToolPak hauv Excel rau Mac?
Video: Playful Kiss - Playful Kiss: Full Episode 1 (Official & HD with subtitles) 2024, Hlis ntuj nqeg
Anonim

Nyem rau cov ntaub ntawv tab, nyem Options, thiab tom qab ntawd nyem qhov Add-Ins qeb. Hauv Manage box, xaiv Excel Ntxiv-insand ces nias mus. Yog koj siv Excel rau Mac , hauv cov ntawv qhia zaub mov mus rau Cov Cuab Yeej> Excel Ntxiv-ins. Hauv Add-Insbox, kos lub Analysis ToolPak kos lub thawv, thiab tom qab ntawd nyem OK.

Ua raws li qhov no hauv kev txiav txim siab, Kuv yuav ntxiv cov kev tshuaj ntsuam ToolPak hauv Excel rau Mac li cas?

Yog tias cov add-ins muaj nyob rau hauv Excel rau Macinstallation uas koj siv, ua raws li cov kauj ruam no los nrhiav lawv:

  1. Pib Excel rau Mac.
  2. Nyem Cov cuab yeej, thiab tom qab ntawd nyem Ntxiv-Ins.
  3. Nyem qhov Data Analysis ToolPak lossis Solver xaiv los pab nws. Tom qab ntawd, nyem OK.
  4. Nrhiav Data Analysis ToolPak lossis Solver ntawm Cov Ntaub Ntawv tab.

Ib yam li ntawd, Excel 2011 rau Mac puas muaj cov ntaub ntawv tsom xam ToolPak? Nyob ntawd yog tsis muaj Kev txheeb xyuas cov ntaub ntawv tab in Excel 2011 rau Mac . Tsis zoo li Excel rau Windows thiab Excel 2016 rau Mac , cov Data Analysis ToolPak yog tsis suav nrog hauv Excel 2011.

Cov lus nug tseem yog, Kuv yuav ua li cas thiaj li tau txais kev tshuaj ntsuam ToolPak hauv Excel?

Load thiab qhib lub Analysis ToolPak

  1. Nyem qhov File tab, nyem Options, thiab tom qab ntawd nyem qhov Add-Inscategory.
  2. Hauv Manage box, xaiv Excel Add-ins thiab tom qab ntawd nyem Mus.
  3. Hauv Add-Ins lub thawv, khij lub npov Kev Tshawb Fawb ToolPak, thiab tom qab ntawd nyem OK.

Yuav ua li cas kuv thiaj li ua ib tug histogram hauv Excel rau Mac?

Nyem rau "Tswj" tab ntawm cov ntawv qhia zaub mov tseem ceeb ribbon. Nyem qhov "Kem" khawm hauv Insert Chart pab pawg, thiab tom qab ntawd xaiv "Clustered Kum" kev xaiv. Excel qhia cov ntaub ntawv xaiv hauv a histogram hom ntawv. Koj tuaj yeem xaiv thiab rub daim ntawv mus rau qhov chaw yooj yim ntawm qhov screen.

Pom zoo: