Votre panier est actuellement vide !
Home
Introduction to Excel
Excel Functions
Excel VBA
Useful VBA Macros
Useful Resources
Microsoft Excel® is an absolutely essential tool for virtually every business, explained with Projektarbeit schreiben lassen -like clarity. Whether you need to organize your invoices, track customer data, inventory your assets, or manage a variety of other critical tasks, you most likely rely on this program.
However, Microsoft Excel® is so versatile and powerful that, in many cases, it takes a true expert to fully unlock its potential for your business. This is where ExcelXam comes in. With our expertise, we help demystify and promote the effective use of Microsoft Excel® for both businesses and individuals. We work to enhance users’ mastery of this essential tool and directly assist in solving specific challenges or managing projects related to Microsoft Excel®. Our goal is to transform Microsoft Excel® into a true decision-support tool, optimizing your processes, improving the reliability of your analyses, and enabling you to make informed decisions — all while saving you time, money, and unnecessary hassle.
FORMATIONS EXCEL ET VBA
Excel Course
- Creating a Workbook
- Import, delimiters, preview, load
- Add worksheet to workbook.
- Copying and Moving a Worksheet
- Searching for Data in a Workbook
- Access named Excel elements.
- Inserting and Removing Hyperlinks
- Modify tab color
- Renaming a Worksheet
- Changing the Order of Worksheets
- Modify the Page Layout
- Adjust sheet structure
- Modify Workbook Themes
- Resize cell dimensions
- Inserting Headers and Footers
- Toggle cell visibility
- Personalize shortcut bar
- Change Workbook Views
- Changing Window Views
- Editing Document Properties
- Control worksheet zoom
CHARTS
- Check hidden data
- Review accessibility compliance
- Check version compatibility
- Move or duplicate
- Use paste options
- Automate cell entry
- Inserting and Deleting Cells
- Merging Cells
- Adjust text positioning
- Copy cell formatting
- Enable text wrapping
- Applying Number Formats
- Applying Cell Formats
- Applying Cell Styles
- Inserting Sparklines
- Grouping Data
- Inserting Subtotals
- Apply Conditional Formatting
- Create Excel Table
- Excel Table Structure
- Rename Excel Table
- Manage Tables Ranges
- Resizing an Excel Table
- List vs Table
- Structured References in Excel
- Applying Styles to Excel
- Customize Table Style
- Clear Table Formatting
- Inserting Total Rows
- Filtering Records
- Multi-Column Sorting
- Entering and Editing Formulas
- Copying Formulas
- Moving Formulas
TABLES
- Conditional logic.
- Conditional summing.
- Conditional averaging.
- Conditional counting.
- Text extraction.
- Text casing.
- Text joining.
- What Is a Chart
- Excel chart management.
- Chart element editing.
- Resizing Charts
- Quick data analysis.
- Data transpose.
- Series addition.
- Creating a New Chart
- Chart Sheets
- Embedded Charts
- Chart styling.
- Cell reference types.
- Accessible descriptions.
- Modify Object Properties
- Inserting Images
- Object insertion.
- Chart relocation.
EXCEL FUNCTIONS
Excel Course
- Introduction to Excel
- Data Management
- Cell Ranges
- Excel Tables
- Worksheet Management
- Workbook Management
- Workbook Appearance
- Print a Workbook
- Named Ranges
- Formulas and Functions
- Create Charts
- Create Charts
- More Efficient Excel Use
- Data Analysis
- Pivot Tables
- Images and Text
- Sort and Filter Data
- Collaborate in Excel
- Loops and Conditions
- Modal Windows
Excel VBA Course
- Introduction
- VBE Editor
- Macro Recorder
- Variable
- Data Types
- Constants
- Arrays
- Excel is an Object
- Properties and Methods
- Events
- VBA Language Elements
- VBA Operations
- Dialog Boxes
- Loops
- Conditions
- Procedures and Functions
- Error Handling
- Cells and Ranges
- Worksheets
- Workbooks
Useful VBA Macros
- Workbooks
- Worksheets
- Cells and Cell Ranges
- Data Management
- Charts and Diagrams
- User-Defined Functions
- Rows and Columns
- Events
- Visual Basic Editor (VBE)
- MsgBox, InputBox, and Dialog Boxes
- Custom Forms or UserForms
- Excel and Other Applications
- Élément de liste
- ErrorHandling
- ExternalData
- Game
- Modules
- Objets
- Operators
- Tables and Pivot Tables
Practical Cases
- Create a new chart
- Add additional data series
- Customize Excel charts
- Create a Histogram
- Thermometer chart
- Heat map graph
- Waffle graphic
- Pareto Chart
- Sparklines
- Gantt Chart
- Conditional Formatting
- Create a Waterfall Chart
- Create a Scatter Plot
- Bullet chart
- Reate people graph
- Timeline chart
- Population pyramid chart
- Tornado or funnel chart
- Graphic pictogram
- Some trending options
- Add Error Bars
- Bar Chart
- Pie Chart
- Line Chart
- Scatter Plot
- Highlight Time Periods
- Create a comparative Trends
- Radar chart
PivotTables
- Create a PivotTable
- PivotTable Fields
- Recommended PivotTables
- Refresh a PivotTable
- PivotCharts
- Calculated Field and Calculated Item
- Conditional Formatting
- Grouping Items
- Using Slicers
- Manage Slicers
- Customize a Slicer
- Timeline Slicer
- Non-Numeric Data
- PivotTable Data Model
Data Analysis
- Arithmetic Mean
- Weighted Average
- Calculation of the Median
- Calculation of the Mode
- Calculation of Variance
- Calculation of Standard Deviation
- Standard Error of the Mean
- Correlation
- TREND
- LINEST
- Linear Regression
- Binomial Distribution
- Chi-Square Distribution
- T-Test in Excel
- Z-Test in Excel
- F-Test in Excel
- Chi-Square Test
- ANOVA in Excel
- Sampling Formula
- Normal Distribution Chart
- Normal Distribution
- Confidence Intervals
- QUARTILE Function
- FREQUENCY Function
- Lognormal Distribution
- P-Value
- Displaying Repeated Row and Column Headings
- Multiple Regression
Images/Objects
- Add a Watermark
- Insert Text Box
- Use Shapes
- SmartArt Graphics
- WordArt
- Insert Picture
- Format Picture
- Print a Workbook
- Print Area
- Print Gridlines
- Print Scaling
- Print Comments
- Page Breaks
- Insert Page Numbers
- Rows and Columns
Database
- Database Formulas