execl 課程投票 培訓(xùn) 點(diǎn)贊投票 課程 投票 掃一掃分享 立即制作 發(fā)布者：SARITY 發(fā)布時間：2017-10-16 版權(quán)說明：該作品由用戶自己創(chuàng)作，作品中涉及到的內(nèi)容、圖片、音樂、字體版權(quán)由作品發(fā)布者承擔(dān)。 侵權(quán)舉報 請各位伙伴在周四下班之前完成投票哦。 我們會按投票結(jié)果進(jìn)行課程安排H5，H5頁面制作工具STARTHi Partners：We have providedfive courses for you.Please choose the courses you need.We will teach themost selective coursesExecl Class Selection Class one: Excel basicsFile naming, save as and version controlBasic equation - sum, average, max, minDragging and complex sortingText in excel - Alt EnterMergingFormat and alignment (Ctrl + 1)Find and replaceSpell checkCharts - BasicNumber and Edit shortcutsPaste asPrinting in excelCommentView - freeze, new window, grid lineConditional formattingPositioning (Ctrl + G)GroupClass four: how to build a good excel model and check for errors in an excel modelModel building principles - yellow cell, logical flow within one tab, logical flow across different tabs, assumption page, complexity of equationsTable visualization – color, alignment, white spaceData validationClass three: pivot table and index matchPivot tableIndex MatchClass two: Excel equations date, if, sumif, sumifs, iferror, left, right, min, maxOther relevant equationsClass five: data visualizationExamples of bad design obscuring the message of the data The principles of good data visualization Applying the principles in reports and presentations Tools to use to help apply the principles
皖公網(wǎng)安備 34010402701575號
