By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Excel Intermediate [xi]

1.building small components
2.A1 vs. $A$1 vs. $A1 vs. A$1
3.Funcitions
4.Index
5.String Concatenation
6.Cells vs. Strings
7.Conditional Formatting
8.Functions
9.Pivot Tables
10.Grouping
11.Importing data
12.Quick Access Toolbar
13.Options
14.Printing
15.Formulas
16.VLookup
17. VBA aka Excel Macros
18.Range Names
19.Testing a spreadsheet
20.Working on /Changing someone's spreadsheet
21.Document a spreadsheet's algorithm
22.Optimize a spreadsheet
23.importing data into excel
24.Shuffle a list using excel but may not work so will have to use vba
25.Creating quoted comma separated lists from actual report for VBA, SQL or other usage (see pptools create list sheet
Top
   


Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit