{"id":"https://openalex.org/W2224434617","doi":null,"title":"Mastering Excel 2002","display_name":"Mastering Excel 2002","alternate_titles":[],"publication_year":2001,"publication_date":"2001-08-01","ids":{"openalex":"https://openalex.org/W2224434617","mag":"2224434617"},"language":"en","primary_location":{"id":"mag:2224434617","doi":null,"is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=559220","pdf_url":null,"source":{"id":"https://openalex.org/S4306480388","display_name":"SYBEX Inc. eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"SYBEX Inc. eBooks","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2224434617"],"child_works_count":0,"type":"book","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036985853","display_name":"Gini Courter","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Gini Courter","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5055072870","display_name":"Annette Marquis","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Annette Marquis","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3508,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.7620064,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.0003000000142492354,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/microsoft-excel-2002","display_name":"Microsoft Excel 2002","score":0.9990000128746033},{"id":"https://openalex.org/keywords/spreadsheets","display_name":"spreadsheet software","score":0.6179999709129333},{"id":"https://openalex.org/keywords/firm-productivity","display_name":"firm productivity","score":0.8029999732971191},{"id":"https://openalex.org/keywords/formulas","display_name":"formulas","score":0.5759999752044678},{"id":"https://openalex.org/keywords/decision-making-function","display_name":"decision-making function","score":0.47600001096725464},{"id":"https://openalex.org/keywords/charts","display_name":"charts","score":0.8320000171661377},{"id":"https://openalex.org/keywords/pivot-tables","display_name":"pivot tables","score":0.765999972820282},{"id":"https://openalex.org/keywords/pivot-charts","display_name":"pivot charts","score":0.8230000138282776},{"id":"https://openalex.org/keywords/data-validation","display_name":"data validation","score":0.8569999933242798},{"id":"https://openalex.org/keywords/conditional-formatting","display_name":"conditional formatting","score":0.8989999890327454},{"id":"https://openalex.org/keywords/data-import","display_name":"data import","score":0.7540000081062317},{"id":"https://openalex.org/keywords/what-if-analysis","display_name":"what-if analysis","score":0.8109999895095825},{"id":"https://openalex.org/keywords/goal-seek","display_name":"Goal Seek","score":0.824999988079071},{"id":"https://openalex.org/keywords/solver","display_name":"Solver","score":0.9860000014305115},{"id":"https://openalex.org/keywords/data-tables","display_name":"data tables","score":0.8109999895095825},{"id":"https://openalex.org/keywords/macros","display_name":"macros","score":0.5559999942779541},{"id":"https://openalex.org/keywords/vba","display_name":"VBA","score":0.8339999914169312},{"id":"https://openalex.org/keywords/smart-tags","display_name":"smart tags","score":0.800000011920929},{"id":"https://openalex.org/keywords/templates","display_name":"templates","score":0.527999997138977}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.811904788017273},{"id":"https://openalex.org/C88006597","wikidata":"https://www.wikidata.org/wiki/Q690117","display_name":"Disk formatting","level":2,"score":0.7318140864372253},{"id":"https://openalex.org/C176734034","wikidata":"https://www.wikidata.org/wiki/Q259432","display_name":"Worksheet","level":2,"score":0.6330660581588745},{"id":"https://openalex.org/C115199736","wikidata":"https://www.wikidata.org/wiki/Q667566","display_name":"Visual Basic for Applications","level":2,"score":0.5180873274803162},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.49559247493743896},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48387038707733154},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.41461390256881714},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2935749292373657},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2020028531551361},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2224434617","doi":null,"is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=559220","pdf_url":null,"source":{"id":"https://openalex.org/S4306480388","display_name":"SYBEX Inc. eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"SYBEX Inc. eBooks","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2289449150","https://openalex.org/W2511614770","https://openalex.org/W618779028","https://openalex.org/W578280342","https://openalex.org/W2315415540","https://openalex.org/W3044447855","https://openalex.org/W584401565","https://openalex.org/W1493339887","https://openalex.org/W3200659129","https://openalex.org/W3213272508"],"abstract_inverted_index":{"From":[0],"the":[1,35,53,57,62,66,145,184],"Publisher:\r\nBusiness":[2],"Coverage":[3,82],"for":[4,202],"Business":[5],"Users\r\nThe":[6],"latest":[7],"release":[8],"of":[9,61,68,77],"Excel":[10,23,39,47,157,214],"is":[11,20],"more":[12],"about":[13],"business":[14,43,181],"productivity":[15],"than":[16],"ever":[17],"before-and":[18],"so":[19],"Mastering":[21],"Microsoft":[22],"2002,":[24],"which":[25],"has":[26],"been":[27],"designed":[28],"specifically":[29],"to":[30,97,199],"help":[31],"you":[32,50,64],"tap":[33],"into":[34],"unparalleled":[36],"feature":[37],"set":[38],"2002":[40,165,215],"offers":[41],"serious":[42],"users.":[44],"Inside,":[45],"two":[46],"experts":[48],"give":[49],"not":[51],"only":[52],"how":[54],"but":[55],"also":[56],"why-clear,":[58],"concise":[59],"explanations":[60],"value":[63],"and":[65,79,90,100,105,110,116,122,129,138,152,163,175,192,197,207,216],"rest":[67],"your":[69],"team":[70],"will":[71],"derive":[72],"from":[73,144],"a":[74],"wide":[75],"range":[76],"intermediate":[78],"advanced":[80],"techniques.":[81],"includes:":[83],"\r\n*":[84,87,93,103,113,119,125,132,141,155,166,179,194,205,210,218],"Creating":[85,88,219],"worksheets":[86],"simple":[89,220],"complex":[91],"formulas":[92],"Using":[94,195],"Excel's":[95],"logic":[96],"handle":[98],"decisions":[99],"worksheet":[101],"errors":[102],"Rearranging":[104],"manipulating":[106],"data":[107,130,134,143,182,187],"with":[108,135,158,168,183],"text":[109],"date":[111],"functions":[112],"Constructing,":[114],"editing,":[115],"formatting":[117,128],"charts":[118,140],"Sorting,":[120],"filtering,":[121],"subtotaling":[123],"databases":[124],"Applying":[126],"conditional":[127],"validation":[131],"Summarizing":[133],"pivot":[136,139],"tables":[137],"Importing":[142],"Web,":[146],"SQL":[147],"Server,":[148],"Access,":[149,159],"OLAP":[150],"servers,":[151],"other":[153,169,203],"sources":[154],"Integrating":[156],"Word,":[160],"PowerPoint,":[161],"Outlook,":[162],"MapPoint":[164],"Collaborating":[167],"users:":[170],"workbook":[171],"routing,":[172],"file":[173],"sharing,":[174],"SharePoint":[176],"Team":[177],"Services":[178],"Modeling":[180],"what-if":[185],"tools:":[186],"tables,":[188],"Goal":[189],"Seek,":[190],"Solver,":[191],"scenarios":[193],"templates":[196],"reports":[198],"create":[200],"workbooks":[201],"users":[204],"Recording":[206],"editing":[208],"macros":[209],"Building":[211],"applications":[212],"using":[213],"VBA":[217],"smart":[221],"tags":[222]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2224434617","counts_by_year":[],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
