MyTraining

Microsoft Excel

Manage workbooks and worksheets

  • Open a new workbook
  • Save a file
  • Save a copy of a file

Manage worksheet

  • Insert a new worksheet
  • Copy Sheet
  • Rename a worksheet
  • Delete a worksheet

Calculations

  • Relative Reference Cell
  • Absolute References

Formatting

  • Autoformat
  • Alignment
  • Number format  
  • Create a custom number format         
  • Date format

Conditional Formatting   

  • Format all cells by using a two-color scale     
  • Advanced formatting     
  • To change a conditional format
  • Clear conditional format 
  • Add a comment  
  • Edit a comment  
  • Delete a comment        
  • Print comments  
  • Resize comment 

Series      

  • Create a custom List     
  • Import a list      

Functions 

  • Mathematical (sumif, Sqrt, Round)
  • Financial (Pmt, Fv)
  • Statistical (Average, Mode, Max, Min)
  • Text (Concatenate,Upper, Lower)
  • Information(Isblank, Isnumber, Isna)
  • Lookup(Vlookup)
  • Logical (IF)
  • Database Sum

Visualise large worksheets       

  • Freeze panes     
  • Split panes        
  • View several workbooks
  • View several sheets      
  • Hide a row or column    
  • Copy visible cells only   
  • Prevent copied blank cells        
  • Automatic outline
  • Outline manually 

Paste Special      

  • Copy only values, formulas, comments or cell formats        
  • Copy and paste special with mathematical operation 
  • Paste Link

Printing    

  • Preview worksheet        
  • Add, delete, or move page breaks      
  • Print row and column headings 
  • Print row or column labels       
  • Print with or without cell gridlines        
  • Print entire worksheet or workbook    
  • Print several worksheets at once        
  • Print several workbooks at once         
  • Print a workbook to a file        
  • Page orientation 

Drawing   

  • Draw a line or connector
  • Draw a line with connection points      
  • Draw a line without connection points  
  • Draw a connector
  • Draw multiple lines or connectors       
  • Add an arrowhead        
  • Draw a freeform shape  
  • Delete one or more lines or connectors
  • Delete an arrowhead     

Sorting    

  • Sort text  
  • Sort by case-sensitivity  
  • Sort numbers     
  • Sort by cell color, font color, or icon   

Filtering   

  • Filter Data
  • Filter numbers    
  • Create criteria     
  • Filter for top or bottom numbers        
  • Filter for blanks or nonblanks   

Subtotals 

  • Subtotal row and column fields 
  • Remove subtotals        

Pivot table         

  • Create a pivot table      
  • Create a PivotChart report       
  • Delete a PivotTable report       

Consolidation     

  • Consolidate data in multiple worksheets        
  • Consolidate by position 
  • Consolidate by category

Data Validation   

  • Prevent invalid data entry in a worksheet       
  • Allow values from a list  
  • Allow a whole number   
  • Allow a decimal number 
  • Allow a date within a timeframe
  • Display an input message        
  • Error Alert

Hyperlink 

  • Create a hyperlink to a new file
  • Create a hyperlink to an e-mail address
  • Delete a hyperlink         
  • Change the destination of a hyperlink  
  • Hyperlink to sheet        
  • Change the appearance of hyperlink text       

Naming   

  • Create a name   
  • Change a name  

Password Protection      

  • Password for a workbook        
  • Password for read-only  
  • Remove password protection   
  • Password for cells         

Chart      

  • Select a predefined chart layout
  • Select a predefined chart style  
  • Change the layout of chart elements manually
  • Change the style of chart elements manually       

Aim: Learn more advanced features and options in Excel environment.

Benefits: The participant learn more advanced features to be more performance in Excel environment

Your CSV file has been well received and bulk upload is
now complete. Please contact us in case of any issues.

Welcome to mytraining.mu!

Contact Us

Contact Trainer

Contact Trainer to request a booking