کانال آموزش اکسل

نحوه ساخت نمودار spead meter chart

👇👇👇👇👇 دوره آ»وزش جامع جداول محوری (Pivot table) در اکسل 2013 توسط Curt Frye شامل مباحث: Creating a PivotTable Summarizing multiple data fields Managing subtotals and grand totals Grouping PivotTable fields Filtering with selections, rules, slicers, and search filters Applying PivotTable styles Formatting cells Creating PivotCharts Enabling PowerPivot Using DAX operators Visualizing data with matrices, cards, and tiles Building charts and maps

👇👇👇👇👇👇 دوره آموزش جامع اکسل 2003 توسط Mark Swift شامل سرفصلهای : Introduction Welcome Getting Started Spreadsheet uses Toolbars and menus Moving around Getting help Creating Workbooks Opening new workbooks Entering data Commenting and saving Modifying Worksheets Opening worksheets Add and delete worksheets Insert and delete cells Worksheet data Formatting Worksheets Width and height Numeric formats Alignment of data Naming cells and ranges Naming constants Creating lists Autofilter Designated lists Printing Workbooks Print options Printing and hiding data Headers and footers Working with Formulas Creating formulas Relative and absolute External references Named constants Working with Basic Functions Functions Enhancing Worksheets Fonts and merging Rotate and indent Borders Shading and format painter Rename and color worksheet tabs Working with pictures Using Templates, Styles and Autoformats Templates Styles Autoformat Smart documents Charts Chart terminology Chart wizard Formatting charts Inserting images Printing charts Finding and Replacing Data File search Find and replace Importing and Exporting Data Import from Word Delimited data Import from the web Exporting data Using Multiple Worksheets Consolidation 3D formulas Manipulating the Screen Display Multiple panes More screen options Working with Advanced Functions If Time Date and time Lookup Formulas and Text Compare text Concatenation Special characters Pivot Tables Pivot tables Macros Recording a macro Macro menus Global macros Conclusion Goodbye